cancel
Showing results for 
Search instead for 
Did you mean: 

[10-Minute Exercise] How to load data from Oracle to Amazon Redshift

Karen
Former Employee

Difficulty Level: Medium

In this exercise, you will learn how to load data from Oracle to Amazon Redshift.

Watch this 3-minute video to learn how to load Oracle data to Amazon Redshift:

Step 1: Go to the Pattern Catalog and select “Oracle Redshift Loader” to use this pipeline pattern. If you don’t see it on your Pattern Catalog, upload this: Oracle Redshift Loader_2021_02_24.slp (3.2 KB)

60ebc9190c6ea6674bf90f07e9929c60a73b0c2a.png

Step 2: Make sure 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 Amazon Redshift pattern.

Step 3: Open the Oracle - Select Snap and click on the Account tab to provide your database login information. You will need to label the account and provide your account properties, such as the Oracle hostname, port number, and database name. You will also need to upload a JDBC driver and specify the JDBC driver class.

77f777bb07701306c3b195ae849e0dde304c7f34.png

Step 4: Now open the Amazon Redshift - Bulk Load Snap to add your Redshift account information in the Account tab. You will also need to label the account name and the account properties, such as the Redshift endpoint, port number, and database name. Now you are ready to load data into Redshift.

1465176a2d21ae658df792c76ee4ceb0c6a7df9f.png

Step 5: Open up the Oracle - Select Snap. Provide the table name, the where clause, and the order. Click Save and close the dialog.

01a9cb5292f1d9f313a36abcc2e19492cd5c6f77.png

Step 6: Now open up the Redshift - Bulk Load Snap. You will need to provide the table name and set any other settings as needed. Click Save and close the dialog.

500fc068f8d5881820a9b658b75592461be61b38.png

Step 7: Click on image to validate the pipeline. The pipeline is ready to be executed, you can click on f94f3438-034f-4696-b74d-c17799ffb2d3 on the toolbar. The pipeline will turn green once it’s successfully executed.

Congratulations! You have completed this pipeline exercise!

Need more help?

You can launch the step-by-step exercise and additional resources on the SnapLogic Knowledge Center 1237f18be960ef242bb507281ab607b7581b867e.png on our SnapLogic platform, or peruse through the categories and topics on the SnapLogic Community.

[ The SnapLogic Knowledge Center is only available within the SnapLogic Free Trial. ]

0 REPLIES 0