The administration database server is used to store administration information and manage the persistence in Talend Administration Center. By default a MySQL database is used, but you can also use an embedded H2 database, MS SQL Server, or Oracle to store all cross-project data (users, projects, authorization, license, tasks, triggers, monitoring).
The administration database will be named
<talend_administrator>
in the rest of this document.
The <talend_administrator>
administration database will
contain all the data related to project information and administration including:
administration data, project declaration, user declaration and authorization, task list,
etc.
The tables in this database are automatically created when connecting for the first time to Talend Administration Center. The created tables include:
- a
Users
table - a
Projects
table - a
Rights
table
Available in:
Big Data Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
Additionally, to perform Data Quality operations, a HSQL, MySQL, or Oracle database is used to store report and analysis results. For more information about these databases, see Supported databases for profiling data.