Installation:
- Save the files to your webroot
- Modify the config.php file with your repository database credentials and administrator logins
- Run "Create Table" commands in config.php file for your repository database
- Schedule /cron.php with crontab to run ETLs with a schedule
Supported source databases and ETL destinations:
Sources:
- MySQL/MariaDB
- PostgreSQL
Destinations:
- MySQL/MariaDB
- PostgreSQL
- S3 Object Storage
- SFTP
Supported ETL types:
- UPSERT to Database destinations
- CSV files to SFTP and S3
Requirements:
- PHP 8.x
- MySQL/MariaDB Database as repository DB
- If needed install PSQL extension for PHP
- Allocate enough memory for PHP for large data transfers
Made using:
- flightPHP framework - a light-weight php framework (http://flightphp.com)
- idiorm - ORM and query builder (https://github.com/j4mie/idiorm
- Twitter Bootstrap - UI CSS Framework (http://getbootstrap.com)
- Credits: Clone of old VisualQuery repository and updated to work with PHP 8.x