How to set up and test using Aurora

Environment

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. (https://aws.amazon.com/rds/aurora/)

Aurora can be accessed via ODBC as any ODBC-compliant RDBMS.

Once you have the Amazon Aurora RDS database set up, download and install Workbench management studio 8.0.x and MySQL Connector ODBC 8.0.19 (or later) from MySQL’s website ( https://dev.mysql.com/downloads/ ).

Even if you are going to focus on 32-bit for your application, you must also install the 64-bit MySQL Connector ODBC driver because the DataFlex Studio and other DataFlex tools are 64 bits.

Connect to Aurora through Workbench

  1. Open Workbench

  1. Click on the plus sign (+) to add a connection

  1. Add connection information – make sure to use the writer address (Amazon RDS information from the AWS site – see below) in the Hostname for the connection

  1. Test the connection
  2. Click OK to save the connection information

Creating a Unicode Database

  1. From the Workbench, select the connection to open (e.g. Aurora RDS)
  2. Click on Create a new schema
  3. Enter the database details, selecting charset utf8mb4 and collation utf8mb4_general_ci

  1. Click on Apply
  2. Review the SQL generated and
  3. Click on Apply to proceed with the schema (i.e. database) creation

Setting up DSNs in ODBC Administrator

  1. In the ODBC Administrator, select the MySQL ODBC Unicode driver to create a new data source

  1. Enter your server connection information – make sure to set the Character Set setting in the DSN to utf8mb4

  1. Click on OK to save the DSN and close the dialog

 

See Also

Environment Setup Notes