External Data Integration and ERP Mapping

To allow the AI assistant to integrate deeply into enterprise workflows, the system provides powerful external integration (Connectors) tools. Through these settings, administrators can synchronize data between AI GO and existing corporate systems at the database or API level, providing the AI assistant with the latest business data contexts when delivering services.


1. External Integration Management (Data Connectors)

Data Connectors are the core tools to synchronize data at the database or API level between AI GO and existing corporate systems.

Data Source Settings (DataSource)

  • Entering Path: Click "External Integrations" under the "System and Maintenance" section in the left navigation bar.
  • Supported Systems (Provider): The system built-in presets for multiple mainstream ERPs and databases, including:
    • Generic RESTful API.
    • Digiwin A1 Cloud ERP, Digiwin T100.
    • SAP Business One (SAP B1).
    • Odoo ERP.
    • NetSuite.
    • Generic External Databases (PostgreSQL, MySQL, etc.).
  • Connection Test: Once a data source is created, click "Test Connection" to immediately verify API or database health and connectivity.

2. Field Mapping and AI Suggestions (ConnectorMapping)

After connecting to an external data source, you must map the fields of the external data tables to the internal data models of AI GO to ensure data can be correctly read, written, and recognized.

Preconfigured Mapping Templates

For common ERPs like Odoo or Digiwin, the system provides preconfigured "Presets Mapping Templates" (such as customer master data, product master data), allowing administrators to apply them quickly via the mapping wizard, eliminating tedious field-by-field configurations.

AI Field Mapping Suggestions

When connecting custom tables or non-standard ERPs, the system provides an "AI Suggestions" button. The AI automatically analyzes the semantic similarity of field names and data types between the external system and AI GO tables, providing the best mapping suggestions and lowering configuration barriers for IT staff.

Bidirectional Sync and Logs

  • Sync Direction: Administrators configure data flow direction. It supports "Sync from external to AI GO" (read-only pull) or "Sync from AI GO to external" (bidirectional sync).
  • Sync Logs: The system provides detailed logs. Administrators can query the scheduled time, number of modified records, success status, and error messages of each automatic synchronization in "Sync Logs", making it easy to track consistency and troubleshoot issues.