EventDB takes the data from your filtered streams and stores it into a Postgres-like database using Amazon Redshift. You can then analyze the data using business intelligence tools like Tableau or query the data directly with your preferred SQL client tool.
In this article:
Once EventDB is turned on, the prettified view of the schema contains the titles you apply to the filtered streams in AudienceStream, as follows:
You must contact your Account Manager to enable EventDB for the appropriate profile(s) in your account.
Once it is activated, it may take up to an hour for data to begin populating your database.
Use the following steps to send data to EventDB:
By default, your streams will contain all of the Event Attributes defined in your account. For streams collecting data from the Tealium Collect tag, additional Boolean attributes will be included for each tag that fires during an event. For example, if you have Google Analytics in your iQ account along with the Collect tag, your event streams will include a Boolean attribute named "Google Analytics" indicating whether or not it fired for each event.
Use the following steps to adjust which Event Attributes are saved to EventDB:
Attributes marked as Restricted Data are excluded by default but you may check the box to include them. DOM attributes (e.g. URL, domain, referrer, and user agent) are always sent and cannot be excluded.
To access to your EventDB data, a third-party tool with the ability to connect to a Postgres-style database is required.
With your credentials in hand, it's time to connect to the database. The following example uses the freeware program SQL Workbench/J (see Connecting to EventDB with SQL Workbench).
There is a raw data table view and a view that joins all the related tables and columns into one convenient location. Notice the difference in column names and that the schema naming convention is [account]__[profile]. The column names are in the same positions in each table, regardless of the view. The main difference is the readability of the entry.