Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Synchronization task example

Synchronization
task example

You work for an e-commerce organization that stores sales order details in a MySQL database. Your organization needs to move the data from the MySQL database to an Amazon Redshift target.
Configure a
synchronization
task to write to Amazon Redshift.
You perform the following
synchronization
tasks:
Define the
synchronization
task.
Configure a
synchronization
task to use the insert operation.
Use a MySQL source object.
The source for the mapping is a MySQL connection that contains the sales order details. The MySQL object is a single source in the
synchronization
task. You can include the Customer ID, Item_codes, Item_quantity, and Price columns. Specify
sales_order_details
as the resource for the source object.
Create an Amazon Redshift target object.
Select the fields
Customer_ID
,
Item_codes
,
Item_quantity
, and
Price
from the source object that you want to insert into the target object. Provide a name
sales_order_details
for the target object and specify the connection type as MySQL. The
synchronization
task writes the data to Amazon Redshift. You can also use an existing target object.
Configure a field mapping.
Map all the fields under
sales_order_details
source data to all the fields in the target
sales_order_details
. The
synchronization
application writes the mapped source data to Amazon Redshift.
Configure the advanced target properties.
In the advanced target properties, you choose properties that are specific to Amazon Redshift. Specify an Amazon S3 bucket name for the Amazon Redshift target data. Use an S3 bucket in the same region as your Amazon Redshift cluster. You can also specify options for the copy command, and turn on server side and client side encryption.
Open Amazon Redshift to visualize the exported data.