The Experience Analytics product suite requires several databases for configuration and data storage. The databases that you need depend on the Experience Analytics components that you licensed.
These databases are maintained in one or more Microsoft™ SQL Server instances that are hosted by the customer. Experience Analytics requires two SQL Server logins to provide different applications the proper level of access to the databases.
You are responsible for the maintenance and backup of your Experience Analytics databases. Experience Analytics provides some tools and recommendations for how to back up the databases, including the creation of backup scripts according to recommended practices as part of the install process.
- System Database - Required for the cxImpact Portal and Reporting capabilities. Contains all Experience Analytics system information that is created through the configuration and use of Experience Analytics.
- Reporting Database - Contains statistical information about traffic that is captured from monitored customer applications. This information is collected from the Experience Analytics canisters, aggregated, and stored for use in reporting.
- Statistics Database - Contains performance information about the Experience Analytics CX system itself. Used for monitoring the systems health and to aid in database troubleshooting.
The cxReveal database is used to store session attributes and other session-related information as soon as the data is detected in the Windows™ pipeline.
Sizing guidelines for Experience Analytics databases are based on multiple interdependent factors. For detailed guidelines, contact Professional Services.
Ensure that the following requirements for are met for databases used with the Experience Analytics CX platform.
All Experience Analytics databases can be hosted in Microsoft SQL Server.
Required system user accounts
Each Experience Analytics database requires two database user accounts:
TLADMIN- administrator account that must be able to modify database schema. The applications using this account are not exposed to user access.
TLUSER- user account used by the Portal and other applications. Access is limited to reading and writing data from the databases.
For cxImpact, you can use the external Tealeaf Database Manager program (TDM) to manage installations, updates, and upgrades to your Experience Analytics databases.
This tool manages all of the backend SQL scripting and queries necessary to manage basic operations on the databases. The TDM can also generate scripts for later use.