Page tree
Skip to end of metadata
Go to start of metadata

After you create a Data Warehouse user and configure the Data Warehouse IP Allowlist, you can connect to your Data Warehouse from your preferred business intelligence (BI) tool. Most BI tools use either a JDBC or an ODBC connection and ask for information you receive in an email after you create the Data Warehouse user account. You can use that information to test the connection and verify the behavior you expect before you move forwardScratch schema is setup automatically and available to use within the Data Warehouse. 


This Article Explains

This article explains how to connect Data Warehouse to your BI tool using either a JDBC or ODBC connection. For developer-level technical specifications, please refer to Interaction Studio's developer documentation.

Sections in this Article

Use Data Warehouse with a JDBC Connection

If you plan to use Data Warehouse with a BI tool that supports a JDBC connection, use the following sample, replacing the bolded sections with your own information:

Example JDBC Connection String

jdbc:redshift://client-xxx.examplecluster.abc123xyz789.region-xyz.amazonaws.com:5439/xxx

Use this string with your JDBC-connected BI tool, like Tableau, to test the connection.


Use Data Warehouse with an ODBC Connection

If you plan to use Data Warehouse with a BI tool that supports an ODBC connection, use the following sample, replacing the bolded sections with your own information:

Example ODBC Connection String

Driver={Amazon Redshift (x64)}; Server=xxx.examplecluster.abc123xyz789.region-xyz.amazonaws.com; Database=xxx; UID=xxx; PWD=insert_your_master_user_password_here; Port=5439

Use the string you receive by email with your ODBC connected BI tool to test the connection.