How to connect to Amazon Aurora from Denodo

Goal

This document describes how to connect to Amazon Aurora from Denodo. Amazon Aurora is a MySQL-compatible, relational database engine.

Connecting to Amazon Aurora from Denodo

• From the Web Design Studio, create a new JDBC data source by selecting “File > New > Data source” from the ‘Select data source’ window choose ‘Amazon Aurora MySQL’. This will open the wizard to create a connection to a data source with a JDBC driver.

• To create a connection, fill all the required fields:

• Name: ds_auroradb
• Database URI: use a connection string in the form of: jdbc:mariadb://<server>:<port>/<schema>

For example: jdbc:mariadb://host:3306/testdb

• Username: Enter the username to connect to Amazon Aurora.
• Password: Enter the appropriate password.

Once the information is filled, click on “Test Connection” and if the connection is successful, click on “Save”.

• Once the data source is created, create base views for that particular source. To do that, click on "Create base View" option.

The Tool will display a tree with the schemas of the database. Click on any schema to inspect its tables and their fields.  To search a view or a schema, type its name in the “search” box located at the top of the dialog. The list will only show the elements whose name contains the text you entered.  

• To incorporate some of the tables into the Denodo virtual schema, you have to check the box near the tables or views you want to import and then click “Create selected”.
  

• When the importing process is finished, the new views are displayed.

• Now, the base views are ready for the execution and to be combined with the rest of the sources.

References

JDBC Sources