Skip to content

How to Set Up and Test Using Aurora

Environment

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, combining the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. Learn more about Amazon 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: MySQL 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 DataFlex Studio and other DataFlex tools are 64-bit.

Connect to Aurora Through Workbench

  1. Open Workbench.

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

  1. Add connection information:
  2. Make sure to use the writer address (Amazon RDS information from the AWS site) 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:
  4. Charset: utf8mb4
  5. Collation: utf8mb4_general_ci

  1. Click on "Apply."
  2. Review the SQL generated.
  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:
  2. Make sure to set the Character Set setting in the DSN to utf8mb4.

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

See Also