The Tealeaf product suite requires several databases for configuration and data storage. The databases that you need depend on the Tealeaf components that you licensed.
These databases are maintained in one or more Microsoft™ SQL Server instances that are hosted by the customer. Tealeaf 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 Tealeaf databases. Tealeaf 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.
CX databases
- System Database - Required for the cxImpact Portal and Reporting capabilities. Contains all Tealeaf system information that is created through the configuration and use of Tealeaf.
- Reporting Database - Contains statistical information about traffic that is captured from monitored customer applications. This information is collected from the Tealeaf canisters, aggregated, and stored for use in reporting.
- Statistics Database - Contains performance information about the Tealeaf CX system itself. Used for monitoring the systems health and to aid in database troubleshooting.
cxReveal database
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
Sizing guidelines for Tealeaf 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 Tealeaf CX platform.
Database server
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.
Do not remove the public role from the SQL server roles list because TLADMIN and TLUSER accounts have this role assigned to them.
Database tools
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.