This flow extracts data from one database and loads into another database (or schema within the same database).
Step 3. Create a new
database to database flow.
Step 4. Add a new transformation and select from connection, and table and to connection and table.
Step 5. Click the MAPPING button and configure a Source SQL if needed.
Step 6. Add per-field mapping if needed.
Step 7. Test the transformation.
Step 8. Configure MERGE (UPSERT) if needed.
Step 9. Configure change replication if needed.
Step 10. Add as many pairs of source-to-destination transformations as needed.
Step 11. Save the flow and execute it manually.
Step 11. Schedule the flow to be executed periodically.