This article describes how to work with the Tealium DataAccess AudienceDB and EventDB.
How it works
AudienceDB and EventDB services are used to store structured audience and event data in a Postgres-like database (Amazon Redshift). From Amazon Redshift, you can then query and analyze the data directly using your preferred SQL client or Business Intelligence (BI) tool.
AudienceDB and EventDB must be activated for your account. For additional information, contact your account manager.
Tables, views and normalized views
When a service is activated, a database is created in Amazon Redshift to store your data. The columns in the tables are named according to the attribute type and the internal attribute ID. For example, if you have a badge attribute with an internal ID of “30”, the table will contain a column named
badge_30. Views and normalized views of data are created to make it easier to write queries. The normalized view is similar to the view but with the attribute ID omitted from the field name.
Standard tables have columns named after the attribute type and the attribute ID.
Table names appended with
_viewhave user-friendly column names with attribute IDs.
visitor - badge - fan (30)
- Normalized views
Table names appended with
_view_normalizedhave user-friendly column names without the attribute IDs.
visitor - badge - fan
The views also simplify the process of running queries with aggregations such as
Visit and visitor attributes are stored in database table columns according to their attribute type and name. Each table is keyed using a
visitor_id. Database views are created for each table to make it easier to write queries.
The following tables are available for visit and visitor data:
- Visit/Session Data:
- Visitor Data:
In addition, the following tables exist for special attribute types:
- Set of Strings:
For detailed information, see the AudienceDB data guide.
For tables containing event data, event data includes event attributes for all events in the event feed. Table columns are named according to the attribute type and name, with only some attributes referencing internal ID’s. Standard Universal Data Object (UDO) variables are named with a
udo_ prefix and most column names match their corresponding attribute names, for example:
Event data coming from the Tealium collect tag also includes information about which tags executed on the page and page performance metrics.
For additional information, see Live Events and Feeds.
The following tables are available for event data:
- Event Feed Data:
Writing SQL queries
The following articles provide best practices and examples of useful queries:
- Connecting to EventDB and AudienceDB with SQL Workbench/J
- Best Practices for Writing Queries for EventDB and AudienceDB
- Helpful SQL Queries for EventDB and AudienceDB
Enable data storage
Data storage is controlled at the attribute level. Event attributes and visit/visitor attributes have a checkbox that determines if it will be stored in the database. Simply edit the attribute and toggle the checkbox on or off to include or omit the attribute from the database.
For additional information, see Using Attributes.
All audiences are stored in AudienceDB.
- Event feeds
Event feeds must be configured for the data to be stored in EventDB.
EventDB also collects preloaded attributes. Although preloaded attributes cannot be edited from the Attributes screen, you can adjust the preloaded attributes that are stored in EventDB using the DataAccess Console.
It is recommended to only enable EventDB for the specific event feeds that you need since the amount of data can become quite large depending on your volume. For additional information, see Live Events and Feeds.
Adjust preloaded EventDB attributes
To adjust which preloaded attributes are stored in EventDB:
Go to DataAccess > EventDB.
Click Show EventDB Attributes.
Select or deselect attributes to add or remove them from EventDB.
All all attributes are checked by default.
DOM attributes, such as URL, domain, referrer, and user agent are always sent and cannot be excluded.
Save and Publish your changes.
Adjust AudienceDB attributes
To adjust which visitor attributes are stored in AudienceDB:
- Go to DataAccess > AudienceDB.
- Click Show AudienceDB Attributes.
- Select or deselect attributes to add or remove them from AudienceDB.
- Click Save.
- Save and Publish your changes.
You must use a third-party tool with Postgres support to connect to your database. These tools require authentication credentials to connect, which are provided in the DataAccess Console.
Database Credentials are now generated for each user. Previously, credentials were generated for an account and profile and were shared by all users. If someone regenerated global credentials, all user connections were terminated, and all users had to reconnect.
For user-specific credentials, the generated credentials are based on the account, profile, and the user’s email address. Users can regenerate their own credentials without terminating other connections. You can remove access for a specific user without terminating other connections. To deactivate a specific user’s credentials, contact Tealium Support.
Previously generated global credentials can still be used, but cannot be regenerated.
Get database authentication credentials
Use the following steps to get the database authentication credentials:
- In the sidebar, click DataAccess > EventDB or DataAccess > AudienceDB.
- Click Get DB Connection Details.
- Click Regenerate DB Credentials. You need to regenerate credentials even if this is your first time getting credentials.
- Click Yes to confirm that you want to delete your existing credentials and generate new ones.
The DB Connection Details screen displays the following fields:
The username for the database connection, which is a combination of your account, profile names, and your email address. For example,
The password for the database connection.
The name of the database, usually the name of your account.
The host name of the database server, specific to your data storage region.
The port number for the connection.
- Save the connection details for future use, then click Close.
Thank you for your feedback!
This page was last updated: January 7, 2023