marquine/php-etl

Extract, Transform and Load data using PHP.

v2.3.1 2020-06-28 01:11 UTC

Requires

• flow/jsonpath: ^0.3.1
• illuminate/container: ^5.0|^6.0|^7.0

Requires (Dev)

• phpunit/phpunit: ^7.3

MIT

• Leonardo Marquine

• data
• transform
• extraction
• laravel
• extract
• etl
• transformation
• load
• seed

README

Extract, Transform and Load data using PHP.

Installation

In your application's folder, run:

composer require marquine/php-etl

Documentation

Documentation can be found here.

Example

In the example below, we will extract data from a csv file, trim white spaces from the name and email columns and then insert the values into the users table:

use Marquine\Etl\Etl;

$etl = new Etl;

$etl->extract('csv', '/path/to/users.csv')
    ->transform('trim', ['columns' => ['name', 'email']])
    ->load('insert', 'users')
    ->run();

License

PHP ETL is licensed under the MIT license.