Knowledge Base

Applies to :
- Denodo 8.0
- ,
- Denodo 7.0
Last modified on:
02 Jan 2023
Download: Document

You can translate the document:

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 > 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:

For Aurora 1.x and Aurora 2.x select MySQL 5.
For Aurora 3.x select MySQL 8 and higher.

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 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”.