The ElastiCube Manager enables easy and quick access to databases, tables and views contained within Amazon RedShift  databases. The steps below detail how to connect to this type of data source.

  1. Click Add Data in the top menu of the ElastiCube Manager.
  2. Under the Web Services category select Amazon Redshift.

Redshift

  1. You will be prompted to enter the following information:
  • Database server location: Enter the computer/server IP address that holds the database.
  • Either use your Windows Authentication if configured with the database, or alternatively enter the Username and Password to connect to the database.
  • Database: Enter the name of the database to which you want to connect.

Redshift2

  1. Click Connect to Database.

All tables and views associated with the database will appear in a new window.

To view a preview of data contained in a particular table, highlight the table or view in the list and in click the preview pane below. To preview the table, select he Preview checkbox.

Enable the checkbox next to each table or view you would like to use.

Existing relationships between tables can be automatically replicated in the ElastiCube by selecting the Automatically create relationships from database checkbox. Likewise fields with similar names can be linked by selecting the Automatically create relationships for fields with the same name checkbox.

Note: If you encounter problems connecting to Amazon RedShift, please see this article in our support forums.

  1. Once all relevant tables are selected click Add.