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. Click Save and Finish the task.
Open Amazon Redshift to visualize the exported data.
Schedule the task.
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.