Configure a

synchronization

task to use the insert operation.

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.

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.

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.

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.

Click

Save

and

Finish

the task.

Open Amazon Redshift to visualize the exported data.

You can schedule the task for each requirement and save. You can select the synchronization task from the

Explore

page and run the task. In

Monitor

, you can monitor the status of the logs after you run the task.