ETL with relational databases

In Etlworks you can extract data from one relational database and load into another. 

This is the most common use when working with databases.

Process

Step 1. Create a source database Connection.

Step 2. Create a destination database Connection.

Step 3. In the Flows start creating a Flow by selecting Database to database in the Gallery.

Step 4. Add a new source to destination transformation.

Step 5. Define the transformation parameters when the source is a database.

Step 6. Define the transformation parameters when the destination is a database.

Step 7. Define the SQL action: INSERT, UPDATE, DELETE, MERGE, IfExist.

Step 8. If you want to extract only recently updated records, configure high watermark change replication. Please note that other types of change replication are available as well.

Learn how to move tables matching a wildcard name from one schema or database to another.