Connecting to Amazon Redshift
This article provides information on how to connect to Amazon Redshift.
Main article: Connect to data and view it on a dashboard
2. AWS account
Use your AWS account to set up Amazon Redshift and find its connection details.
Sign in to your AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.
Open the details for your cluster and find and copy the ODBC URL, which contains the connection string. For details, see Amazon Redshift's getting started guide on how to get your connection string.
3. Data connector settings
Once you have your connection string, you can set up a data connector in Dundas BI. Set Data Provider to Amazon Redshift.
Paste the Connection String, and enter the Password if not already included in the connection string.
Additional options such as Search Path for specifying schemas are available by clicking on the expandable sections below. You can also click Test connection to check your connection.