On this Page
The SnapLogic Free Trial offers Amazon Redshift Snap Patterns that let you load and synchronize data from sources such as Oracle, MySQL, and SQL Server directly into Amazon Redshift. Available as a 30-day free trial with no on-premises software required, the Redshift Snap Patterns are ideal for organizations considering Redshift as a low-cost, faster alternative to traditional data warehousing.
You will need:
|
Select a Snap Pattern based on the source database you will use to load data into Amazon Redshift. The Pipeline Configuration Wizard will then display and guide you to enter the required information needed to migrate the data from your source database to Amazon Redshift.
Redshift clusters may allow incoming requests only from whitelisted IP addresses. If this is the case, please allow the SnapLogic cloud machines to talk to your Redshift cluster before running this wizard. If you are using a VPC, authorize All TCP traffic for 694702677705/fullsail-stage and 694702677705/fullsail-prod.
If you are not using a VPC, you may add CIDR records for the following IP addresses:
See the Amazon Redshift Getting Started Guide for details.
If the source database is RDS, a similar whitelisting needs to happen as well. See the Amazon RDS User Guide for details.
Step 1: PrerequisitesYou will need to whitelist certain IP addresses as per the Amazon Redshift Getting Started Guide. The IP addresses are listed on the first page of the Pipeline Configuration Wizard when you open the Oracle to Redshift Pattern. Step 2: Oracle Account ReferenceClick Add Account to provide your database login information. You will need your Oracle hostname, port number, and database name. You will also need to upload a JDBC driver and specify the JDBC driver class. Step 3: Redshift Account ReferenceClick Add Account to provide your database login information. You will need your Redshift endpoint, port number, and database name. Step 4: Oracle - Select Snap ConfigurationSupply the table name. If necessary, supply the “where” clause and set the order. Step 5: Redshift - Bulk Load Snap ConfigurationSupply the table name. Set any other settings as necessary. Step 6: Run the Pipeline |
You will need to download last_modified.json (zipped file), extract it, and upload it to the project you’re using to save this pipeline. Step 1: Oracle Account ReferenceClick Add Account to provide your database login information. You will need your Oracle hostname, port number, and database name used for the initial loading pipeline. Step 2: Redshift Account ReferenceClick Add Account to provide your database login information. You will need your Redshift endpoint, port number, and database name used for the initial loading pipeline. Step 3: Run the Pipeline |
Step 1: PrerequisitesYou will need to whitelist certain IP addresses as per the Amazon Redshift Getting Started Guide. The IP Addresses are listed on the first page of the Pipeline Configuration Wizard when you open the MySQL to Redshift pattern. Step 2: MySQL Account ReferenceClick Add Account to provide your database login information. You will need your MySQL hostname, port number and database name. Step 3: Redshift Account ReferenceClick Add Account to provide your database login information. You will need your Redshift endpoint, port number, and database name. Step 4: MySQL - Select Snap ConfigurationSupply the table name. If necessary, supply the where clause and set the order. Step 5: Redshift - Bulk Load Snap ConfigurationSupply the table name. Set any other settings as necessary. Step 6: Run the Pipeline |
Step 1: Review Pipeline PurposeYou will need to download last_modified.json (zipped file), extract it, and upload it to the project you’re using to save this pipeline. Step 2: MySQL Account ReferenceClick Add Account to provide your database login information. You will need your MySQL hostname, port number, and database name used for the initial loading pipeline. Step 3: Redshift Account ReferenceClick Add Account to provide your database login information. You will need your Redshift endpoint, port number, and database name used for the initial loading pipeline. Step 4: Run the Pipeline. |
Step 1: PrerequisitesYou will need to whitelist certain IP addresses as per the Amazon Redshift Getting Started Guide. The IP Addresses are listed on the first page of the Pipeline Configuration Wizard when you open the Oracle to Redshift pattern. Step 2: SQL Server Account ReferenceClick Add Account to provide your database login information. You will need your SQL Server hostname, port number, database name, and database version. You will also need to upload a JDBC driver and specify the JDBC driver class. Step 3: Redshift Account ReferenceClick Add Account to provide your database login information. You will need your Redshift endpoint, port number, and database name. Step 4: SQL Select - Select Snap ConfigurationSupply the table name. If necessary, supply the “where” clause and set the order. Step 5: Redshift - Bulk Load Snap ConfigurationSupply the table name. Set any other settings as necessary. Step 6: Run the Pipeline |
Step 1: Review Pipeline PurposeYou will need to download last_modified.json (zipped file), extract it, and upload it to the project you’re using to save this pipeline. Step 2: SQL Server Account ReferenceClick Add Account to provide your database login information. You will need your SQL Server hostname, port number, database name and version used for the initial loading pipeline. Step 3: Redshift Account ReferenceClick Add Account to provide your database login information. You will need your Redshift endpoint, port number, and database name used for the initial loading pipeline. Step 4: Run the Pipeline |
|
|
|