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

  • 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

Virtual DataPort Administration Guide: JDBC Sources

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here