How to connect to Amazon Redshift from Denodo

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 04 Jun 2020
Tags: Amazon Redshift Cloud JDBC data sources

Download document

You can translate the document:

Goal

This document describes how to access Amazon Redshift from the Denodo Platform.

Content

Amazon Redshift is a fast, fully managed, petabyte-scale Data Warehouse solution that makes it simple and cost-effective to efficiently analyze data using business intelligence tools.

Starting from version 6.0, Denodo includes a connector for Amazon Redshift. Therefore, Denodo is going to use the supported JDBC adapter “Amazon Redshift” for accessing Amazon Redshift as a data source.

Connecting to Amazon Redshift 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_amazonredshift
  • Database adapter: Amazon Redshift
  • Database URI: use a connection string in the form of: jdbc:redshift://<server>:<port>/<schema>

For example: jdbc:redshift://host:5439/tpcds

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

Once the details 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. In order to do that click on "Create Base View" option.

The Tool will then display a tree with the schemas of the database. Here, we can see the tree for the default Postgres schema. 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”.

After this step, you will be asked to confirm to import schemas tables and can start working with Amazon Redshift as a database.

References

Virtual DataPort Administration Guide: JDBC Sources

Virtual DataPort Administration Guide: Supported JDBC Data Sources

Amazon Redshift

Questions

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

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training