gromnan / angetl

PHP7.4+ library to build ETL (Extract, Transform, Load)

Introduction

Uses cases:

• Migrate data between two databases.
• Aggregate data
• Import a CSV or an Excel file to the database and validate each rows.

Readers

• CSV
• Pdo (database)
• Qif (bank accounts)
• RSS
• XML

Filters

• Closure: Apply any function to each record to modify it
• Map: Rename and aggregate fields
• Unique: Ensure records are uniques
• Validation: Validate records using Symfony2 validator

Writers

• CSV
• ... Others to come

Credits

• Jérôme Tamarelle [email protected]

License

Angetl is released under the MIT License. See the bundled LICENSE file for details.

angetl's Issues

Record should be injected instead of initiated

for example here https://github.com/GromNaN/Angetl/blob/master/src/Angetl/Reader/PdoReader.php#L36

How to use ClosureFilter

Could you please provide an example on how to use ClosureFilter