Database

This guide will teach you everything you need to know about uContact's Databases so you can use them in your custom developments and create solutions that enhance the customer experience.

How do they work?

uContact offers controlled access to its internal databases to facilitate custom developments and advanced integrations. This functionality is intended for users with specific permissions who need to query or work with system data to extend the platform's capabilities.

What databases are available?

uContact has three main databases, each with a specific role within the platform's ecosystem:

ccdata

Contains the system's structural information. This includes all data related to the configuration and administration of uContact, such as users, connectors, campaigns, flows, and other elements created within the platform.

• Access is read-only.
• You can view all tables and the details of their columns.
• Write operations (insert, update, or delete) are not allowed.

ccrepo

Stores historical data generated during system usage. This includes interaction logs, metrics, campaign data, and other historical records.

• Access is read-only.
• You can view all tables and the details of their columns.
• Data cannot be modified, inserted, or deleted in this database.

cccustom

Designed exclusively for custom developments. This database allows you to extend uContact's functionality by creating your own data structures.

• You are allowed to create new tables, as well as insert, update, and delete records.
• It is ideal for external integrations, storing specific configurations, or implementing additional logic without affecting the main system databases.

What does access allow?

Database access in uContact is intended for users with advanced integration and customization needs.

Database access allows you to:

• Develop integrations with external systems (CRM, ERP, BI tools, etc.).
• Implement custom logic directly related to campaigns, reports, or workflows.
• Store additional information that enhances the customer service experience in uContact.

Oops, limited access!

To access this feature, you must be a Super User or have a profile with database access permissions.

Once you have the required permissions, you'll find the Database option in the Developer menu.

Working Environment

From this section, you can view the three available databases. By selecting one, you'll see the list of corresponding tables, and within each table, you can explore its column details and structure.

What can you do here?

• Run SQL queries to explore available data according to your assigned permissions.
• View column details, including data type, primary keys, relationships, and constraints.
• Create and manage custom structures such as tables, stored procedures, functions, or indexes (only available in cccustom).