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 Virtual DataPort Administration tool, create a new JDBC data source by selecting “File > New > Data source > JDBC”. 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 adapter: MySQL 5
- Database URI: use a connection string in the form of: jdbc:mysql://<server>:<port>/<schema>
For example: jdbc:mysql://host:3306/testdb
- Username: Enter the username to connect to Amazon Aurora.
- Password: Enter the appropriate password.
Once the informations are 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.
Virtual DataPort Administration Guide: JDBC Sources