SQL Databases
Overview of PostgreSQL databases used by Automate Platform
Admin
Database used by admin application. It stores information that is available through GUI like users, project configurations, flow diagram, NLU training phrases and knowledge base.
Analytics
Every message that is processed by Automate platform is stored in this database. It holds diagnostic information (timing and errors) on each bot turn as well as whole conversation transcript. Only analytics service connects directly to this database.
⚠️ Please be aware that with a big volume of conversation, this database may get big and therefore slow. However, this should not affect bot runtime latency as long as you are not calling system.lastConversations in the flow.
Monitoring bot performance ⏰
This database can be queried to monitor the performance of the platform. Please read the tutorial on performance monitoring and troubleshooting for more details.
Cron orchestrator
Cron orchestrator application stores in this database information about periodic jobs and the results of such jobs. These jobs are mostly internal for example deleting expired conversations to comply with retention policy however some jobs are configurable like exporting to warehouse
Dialog manager
This database holds information on current ongoing sessions, published flows and integrations.
⚠️ As it is solely used by the dialogs service the performance of this database is critical in terms of bot latency.
NLU facade
The NLU facade application is a facade for other NLU services through which the dialog service gathers results of detected intents and variables. In this database NLU settings are stored as well as dictionaries for autocorrect mechanism.
SSO
Database to hold information on authentication done by the sso service
Storage
Storage service keeps in this database information about saved recordings. By default it holds metadata information, but it can also keep whole binary files if it is configured to do so.
⚠️ If you are using PostgreSQL as a storage service, it might get bulky. Please refer to the service documentation for more details.
Thread coordinator
In this database, information about the owner application of conversations is stored. This data is managed by the thread coordinator service as is used when conversations are redirected to human agents .
Web chat
This database is used by the webchat service it holds information about webchat configurations and conversations which include both bot and agent sessions.
Chimeo
Database used by the SentiOne Listen&React applications which is a legacy & redundant integration, not present in newer deployments.
Voice Gateway
Charon
Configuration regarding voice gateway integrations that is set through Channels Connector in Admin UI. This schema is used by charon service that is responsible for SIP integration.
Crocotta
Crocotta service that is responsible for managing TTS services holds its configuration and events in this database schema.
Gall
Call recorder application called gall keeps information about the recordings and their status.
Qpido
Qpido is a dialer service used for phone outbound campaigns. This database schema hold information about contacts, campaigns and call attempts.
Updated about 9 hours ago