This is a common integration patterns that customers tend to use as they are moving from on-prem to cloud.
The following videos describe this integration pattern and the attached reference implementation pipelines help you get a head start on the implementation.
The pipeline moves all the tables from an Oracle database to Redshift. The pipelines are designed to use our best practices like parameterization of all aspects of the pipeline (eg. account names , db names, table names). All are dynamic and controlled via pipeline parameters.
Source: Oracle Tables
Target: Redshift Tables
- Step 1: Oracle - Table List, Filter, Oracle - Execute, Mapper, Pipeline Execute
- Step 2: Mapper, Redshift - Execute, Router, Join, Oracle - Select, Shard Offsets*, Redshift - Bulk Load, Pipeline Execute, Exit, Union
- Step 3: Mapper, Oracle - Select, Redshift - Bulk Load, Exit
*This is a Snap developed by the SnapLogic Professional Services team.
Pattern 1 - Step 1.0 - Oracle to Redshift Parent_2018_06_25.slp (9.4 KB)
Pattern 1 - Step 1.1 - Oracle to Redshift No Shredding_2018_06_25.slp (20.9 KB)
Pattern 1 - Step 1.2 - Oracle to Redshift Shred_2018_06_25.slp (7.7 KB)