Versions Compared

Old Version 9

changes.mady.by.user Ankur Parekh

Saved on

compared with

New Version 10

changes.mady.by.user Ankur Parekh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The SnapLogic Free Trial offers Amazon Redshift Snap Patterns that let you load and synchronise data 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 organisations considering organizations considering Redshift as a low-cost, faster alternative to traditional data warehousing.

Before You Begin

You will need:

Note
  • If you already have an account for the SnapLogic Enterprise Integration CloudIIP, you will need to create a Free Trial account with a different email address to get access to the appropriate Free Trial Snaps and pipelines. 
  • If you’re an existing user, you will not be able to create new projects using a Free Trial account.

  • The SnapLogic trial is hosted in a shared environment. Please be mindful of the data you use during the trial.

Get Started

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.

...

If the source database is RDS, a similar whitelisting needs to happen as well. See the Amazon RDS User Guide for details.

Steps to Configure Pipelines

Oracle to Redshift

Expand
titleInitial loading pipeline

Step 1: Prerequisites

You 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 Reference

Click 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 Reference

Click Add Account to provide your database login information. You will need your Redshift endpoint, port number, and database name.

Step 4: Oracle - Select Snap Configuration

Supply the table name. If necessary, supply the “where” clause and set the order.

Step 5: Redshift - Bulk Load Snap Configuration

Supply the table name. Set any other settings as necessary.

Step 6: Run the Pipeline


Expand
titleSynchronising 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 Reference

Click 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 Reference

Click 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

MySQL to Redshift

Expand
titleInitial loading pipeline

Step 1: Prerequisites

You 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 Reference

Click Add Account to provide your database login information. You will need your MySQL hostname, port number and database name.

Step 3: Redshift Account Reference

Click Add Account to provide your database login information. You will need your Redshift endpoint, port number, and database name.

Step 4: MySQL - Select Snap Configuration

Supply the table name. If necessary, supply the where clause and set the order.

Step 5: Redshift - Bulk Load Snap Configuration

Supply the table name. Set any other settings as necessary.

Step 6: Run the Pipeline


Expand
titleSynchronising pipeline

Step 1: Review Pipeline Purpose

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 2: MySQL Account Reference

Click 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 Reference

Click 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.

SQL Server to Redshift

Expand
titleInitial loading pipeline

Step 1: Prerequisites

You 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 Reference

Click 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 Reference

Click 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 Configuration

Supply the table name. If necessary, supply the “where” clause and set the order.

Step 5: Redshift - Bulk Load Snap Configuration

Supply the table name. Set any other settings as necessary.

Step 6: Run the Pipeline


Expand
titleSynchronising pipeline

Step 1: Review Pipeline Purpose

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 2: SQL Server Account Reference

Click 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 Reference

Click 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

Support for Data Types

Expand
titleOracle to Redshift


Oracle

Redshift

SUPPORTED DATA TYPES

SMALLINT

Smallint

INTEGER

Integer

REAL

Real

DOUBLE PRECISION

Double precision

DECIMAL

decimal

CHAR

CHAR

VARCHAR

VARCHAR

DATE

Date



UNSUPPORTED DATA TYPES

VARCHAR2*

VARCHAR

NVARCHAR2*

VARCHAR

NCHAR*

Text

Number*

Integer

LONG*

Integer

RAW*

Integer

INTERVAL YEAR*

Doesn’t exist

INTERVAL DAY*

Doesn’t exist

CLOB *

Doesn’t exist

BLOB*

Doesn’t exist

BFILE*

Doesn’t exist


...

Expand
titleMySQL to Redshift


MySQL

Redshift

SUPPORTED DATA TYPES

SMALLINT

SMALLINT

INTEGER

INTEGER

BIGINT

BIGINT

DECIMAL

DECIMAL

REAL

REAL

DOUBLE PRECISION

DOUBLE PRECISION

BOOLEAN

BOOLEAN

CHAR

CHAR

VARCHAR

VARCHAR

DATE

DATE

TIMESTAMP

TIMESTAMP



UNSUPPORTED DATA TYPES

TINYINT

Doesn't exist

BIT

Doesn't exist


Files

For more information:

  • Email trial-support@snaplogic.com with any support questions. Free trial support hours are Monday through Friday 9AM-5PM PT. You can expect responses within 24-hours.
  • Search this documentation portal for additional information you need.
  • Visit community.snaplogic.com to consult SnapLogic experts and watch the How To videos available in the Community’s Free Trial category.

See Also

Related documentation: