Skip to main content

Data Catalog

Synchronize Data Tables and Views​

After connecting to a data source, users can view and manage synchronized tables in the "Data Catalog" module.

  • Only tables checked in the data source are displayed;
  • Supports viewing each table's table name, business description, field names, and field descriptions;
  • Displays the relationships between the table and other tables, including related tables, related fields, and relationship types (e.g., primary-foreign key);
  • Supports one-click triggering of "Intelligent Data Knowledge Supplement," where the system automatically generates business aliases and descriptions for tables and fields based on AI and Schema;
  • Supports the "Data Table Synchronization" feature to reload updated table structures.

Data Catalog Synchronization Notes​

  • Unsynchronized tables or views cannot be used

    • Only tables and views synchronized in the data catalog can be referenced or used to build business domains in SERVICEME's Data module.
    • If new data exists in the database but is not synchronized in the data catalog, the system will not recognize or use it.

  • Database structure updates require resynchronization

    • When table structures or field information in the external database change (e.g., new fields added, field type adjustments, table renaming, etc.),
    • Users need to perform the "Synchronize" operation in the data catalog to ensure the data structure remains consistent with the source system.
    • Otherwise, data within SERVICEME will continue to operate based on the old structure, potentially causing subsequent data mapping errors or missing fields.

  • Common causes and troubleshooting for synchronization failures

    • Data source connection failure: May be caused by data source password changes, database service interruptions, or network issues. Please retest the connection in "Data Source Management."
    • Insufficient table permissions: Some database accounts have read-only permissions or lack metadata access rights. Contact the database administrator to grant the necessary permissions.
    • Field or table names contain special characters: Some databases have field or table names with spaces, symbols, or reserved words. It is recommended to rename them in the database or exclude them before synchronization.
    • Schema mismatch: When database structures change frequently or multiple schemas are used, it is recommended to confirm the schema configuration is correct before synchronization.
tip
  • It is recommended that Data administrators regularly check the synchronization status of the data catalog, especially in scenarios with frequent database updates or significant changes in business table structures.
  • Maintaining the data catalog's latest status ensures that AI Agent, BI reports, and intelligent analysis modules continuously receive accurate and usable data support.