This document describes how to access Amazon Redshift from the Denodo Platform.
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
For example: jdbc:redshift://host:5439/tpcds
Once the details are filled, click on “Test Connection” and if the connection is successful, click on “Save”.
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.
After this step, you will be asked to confirm to import schemas tables and can start working with Amazon Redshift as a database.
Virtual DataPort Administration Guide: JDBC Sources
Virtual DataPort Administration Guide: Supported JDBC Data Sources