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.
The following steps describe how to download SQL Workbench and the Amazon Redshift JDBC driver:
Amazon Redshift offers drivers for tools that are compatible with either the JDBC 4.2 API, JDBC 4.1 API, or JDBC 4.0 API. For information about the functionality supported by these drivers, go to the Amazon Redshift JDBC Driver Release Notes.
.jarfile to a safe location on your computer.
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.
The following steps describe how to install the Amazon Redshift JDBC driver:
The following steps describe how to create a connection profile by providing SQL Workbench with the connection credentials to your Tealium database:
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.