Amazon Redshift Connectors > Part III: Data Integration with Amazon Redshift Connector > Introduction to Amazon Redshift Connector > Amazon Redshift Connector example
  

Amazon Redshift Connector example

You work for an organization that stores purchase order details, such as customer ID, item codes, and item quantity in an on-premise MySQL database. You need to analyze purchase order details and move data from the on-premise MySQL database to an affordable cloud-based environment. Create a mapping to read all the purchase records from the MySQL database and write them to an Amazon Redshift target for data analysis.