How ERP Semantic Mining works with Zero Copy Connector for ERP and remote tables

  • Release version: Australia
  • Updated March 12, 2026
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of How ERP Semantic Mining works with Zero Copy Connector for ERP and remote tables

    ERP Semantic Mining, supported up to the Zurich release, helps identify candidates for replatforming data from your ERP system of record to the ServiceNow AI Platform. It suggests actionable next steps, including updating remote tables and extraction tables to access ERP data efficiently. Starting with the Zurich release, ERP Semantic Mining is being prepared for deprecation on new instances but remains supported for existing users.

    Show full answer Show less

    The Zero Copy Connector for ERP enables direct connection to your ERP system and facilitates organized access to its data, primarily through remote tables and extraction tables, which serve as data sources for building applications, flows, and workspaces on the ServiceNow AI Platform.

    Key Features

    • ERP Semantic Mining: Identifies and recommends candidates for migrating ERP data to the ServiceNow AI Platform, aiding in replatforming efforts.
    • Zero Copy Connector for ERP: Provides seamless connection to ERP systems and manages data access without data duplication.
    • Remote Tables: Define the schema for external ERP data and retrieve records via scripts using REST or SOAP services. They allow viewing and manipulating external data in real-time within ServiceNow without importing or storing it, as the data is held transiently in memory in a read-only mode.
    • Extraction Tables: Designed for handling large volumes of ERP data by regularly saving data into local transform tables on the ServiceNow AI Platform. These transform tables process data for use in replatformed applications.

    Practical Use for ServiceNow Customers

    By combining remote tables and extraction tables, you can efficiently access and work with ERP data from legacy systems within the ServiceNow AI Platform. Remote tables enable quick, read-only access to external data sources without storage overhead, while extraction tables support bulk data retrieval and local processing for app development.

    After identifying replatforming candidates with ERP Semantic Mining, you should use the Zero Copy Connector exclusively to access and update these remote and extraction tables. This approach streamlines data integration, reduces duplication, and supports building ServiceNow applications, flows, and workspaces based on ERP data.

    Zero Copy Connector for ERP enables you to connect to your ERP (Enterprise Resource Planning) system of record, and to organize its data.

    Important:
    Starting with the Zurich release, ERP Semantic Mining is being prepared for future deprecation. It will be hidden and no longer activated on new instances but will continue to be supported.

    ERP Semantic Mining enables you to find good candidates for replatforming from the system of record to the ServiceNow AI Platform.

    ERP Semantic Mining suggests candidates and possible next steps, such as updating remote tables and extraction tables to access ERP data. Remote tables send data to the ServiceNow instance as an attachment, which is then analyzed using AI/ML to identify similar candidates to replatform.

    After you have identified candidates to replatform and taken the recommended action in ERP Semantic Mining, you must only use Zero Copy Connector for ERP to access the remote tables and extraction tables. These tables are data sources for building apps, flows, and workspaces.

    Using remote tables and extraction tables with Zero Copy Connector for ERP and ERP Semantic Mining

    You can use a combination of remote tables and extraction tables to retrieve data from your legacy ERP system.
    • Remote tables get their records from running an associated script against an external data source.
    • Extraction tables retrieve large amounts of data using a scheduled query, and use transform tables to process data for use on the ServiceNow AI Platform.

    Remote tables describe the schema for the data that you want to retrieve from an external source, such as the system of record. Use remote tables to connect the ServiceNow AI Platform to third-party sources, or to another instance, so that you can retrieve external data and optionally cache it in the memory. You can view external data in lists or forms and process it with standard Glide scripts. You can also group, sort, aggregate, and filter the data just like you would for standard internal tables.

    By using a remote table, you can retrieve the data from external sources or from another instance with REST or SOAP services. The external data lives in the memory in read-only mode, which makes the data temporary, or transient, within the ServiceNow AI Platform. You can then view and manipulate the external data without importing or storing it. For more information, see Remote tables.

    Use an extraction table to work with large amounts of ERP data. ERP extraction tables regularly save data to a local transform table on the ServiceNow AI Platform, which you can then process and use as the data foundation of a replatformed app.