claonilton/php-etl

Extract, Transform and Load data using PHP.

v2.4.0 2024-05-02 16:18 UTC

Requires

• illuminate/container: ^5.0|^6.0|^7.0|^8.0
• softcreatr/jsonpath: ^0.7.2

Requires (Dev)

• phpunit/phpunit: ^7.3

MIT

• Leonardo Marquine
• Claonilton Jr

• 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 claonilton/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.

Origin of the project

This project is a fork and an improvement of the marquine/php-etl project by Leonardo Marquine.