Getting Started

Installation

In your application's folder, run:

composer require marquine/php-etl

Database Configuration

If you are working with ETL, you probally need to read and/or write to databases. Currently, we support MySQL, PostgreSQL, SQL Server and SQLite.

These are the configuration parameters for each database driver:

• MySQL

  $config = [
    'driver' => 'mysql',
    'host' => 'localhost',
    'port' => '3306',
    'database' => 'database',
    'username' => 'user',
    'password' => 'password',
    'charset' => 'utf8',
    'collation' => 'utf8_unicode_ci',
  ];

• PostgreSQL

  $config = [
    'driver' => 'pgsql',
    'host' => 'localhost',
    'port' => '5432',
    'database' => 'database',
    'username' => 'user',
    'password' => 'password',
    'charset' => 'utf8',
    'schema' => 'public',
  ];

• SQL Server

  $config = [
    'driver' => 'sqlsrv',
    'host' => 'localhost',
    'port' => '1433',
    'database' => 'database',
    'username' => 'user',
    'password' => 'password',
  ];

• SQLite

  $config = [
    'driver' => 'sqlite',
    'database' => '/path/to/database.sqlite',
  ];

Adding connections

Adding the default connection:

use Marquine\Etl\Etl;

Etl::service('db')->addConnection($config); // connection name: 'default'

You can add more connections passing a name as the second argument to the addConnection method:

use Marquine\Etl\Etl;

Etl::service('db')->addConnection($config, 'name');

Laravel Integration

If you are using Laravel 5.5 or greater, the package will automatically register all database connections.

For other versions, you need to add the ServiceProvider to the providers array in the config/app.php file:

Marquine\Etl\EtlServiceProvider::class,