Microsoft Access Connector > Introduction to Microsoft Access > Microsoft Access Connector Example
  

Microsoft Access 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 Microsoft Access database. You need to analyze purchase order details and move data from the on-premise Microsoft Access database to an affordable cloud-based environment. Create a mapping to read all the purchase records from the Microsoft Access database and write them to an Amazon Redshift target for data analysis.