This guide describes how to download and install SQL Workbench/J and connect to the database associated with your DataAccess account.
In this article:
SQL Workbench/J is a free query tool that is simple to use and can connect to many database management systems (DBMS), such as PostgreSQL (which Redshift is based on), or MySQL. Using SQL Workbench/J is a quick and easy way to connect to your database, view your database schema, and analyze your data.
Use the following steps to download SQL Workbench and the Amazon Redshift JDBC driver:
For additional information, see connecting using SQL Workbench for Windows.
The driver for Amazon Redshift JDBC must be installed in SQL Workbench before you can connect to the database.
Use the following steps to install the Amazon Redshift JDBC driver:
Use the following steps to create a connection profile by providing SQL Workbench with the connection credentials to your Tealium database:
Your Account or Deployment Manager should have previously provided you with your password. If not, you can click Regenerate DB Credentials to receive new credentials. This will not delete any existing data, but will break existing connections you might have.
The path may change in the future based on enhancements. If you believe this is an issue, reach out to your Account or Deployment Manager for connection assistance.
The following sections provide information about common errors and troubleshooting tips.
visitor_tables and views that contain only basic visitor-level data and Audiences. No attribute data will be included.