DataDuck ETL currently supports extracting from MySQL and PostgreSQL databases. It supports loading into Amazon Redshift. If you would like to extract or load into a database not yet supported, contact us.
First, create a new, empty directory. Inside this directory, create a file named Gemfile with the following:
source 'https://rubygems.org' gem 'dataduck'
$ bundle install
Finally, run the quickstart command:
$ dataduck quickstart
It will ask you for the credentials to your database, and then create the basic setup for your project.
You will still need to update your .env and config/base.yml files with additional details, such as your AWS S3 api keys.
After you are completely setup, your project's ETL can be run by running
dataduck etl all
If you would like to run this regularly, such as every night, it's recommended to use the whenever gem to manage a cron job to regularly run the ETL.