Connecting to Redshift Using the ElastiCube Manager
Applicable to Sisense on Microsoft Windows
Note: This topic describes how to import data through the desktop ElastiCube Manager. It is recommended that you import data through the online Sisense Web Application. For information, click here.
IMPORTANT: On October 23, 2017, Amazon Redshift is replacing the SSL certificates on your cluster with AWS Certificate Manager (ACM) issued certificates. ACM is a trusted public certificate authority (CA) that is trusted by most current systems.In order to continue importing data into Sisense with the Sisense Redshift connector, you must apply the new ACM certificate. Amazon provides a Certificate Authority, which needs to be saved on a Windows machine.
To replace your certificate:
- Download the Redshift Certificate Authority Bundle.
- Place the certificates from the bundle in your root.crt file. On Microsoft Windows, the file is %APPDATA%\postgresql\root.crt
Sisense 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.
- Click Add Data in the top menu of Sisense.
- Under the Web Services category select Amazon Redshift.
- You will be prompted to enter the following information:
- Database server location: Enter the computer/server IP address that holds the database. This server address should include the port separated by a colon. By default, the port is 5439, for example: [IP Address]:5439.
- 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.
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 the 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 the support forums.