How ERP-CM works with Zero Copy Connector for ERP and remote tables

  • Release version: Yokohama
  • Updated January 30, 2025
  • 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-CM works with Zero Copy Connector for ERP and remote tables

    The Zero Copy Connector for ERP allows ServiceNow customers to connect their ERP systems of record and organize ERP data efficiently. It provides access to standard fields in remote and ERP extraction tables. ERP Semantic Mining (ERP-CM) complements this by identifying candidates suitable for replatforming onto the ServiceNow AI Platform and suggesting next steps, such as updating tables to improve ERP data access.

    Show full answer Show less

    Key Features

    • Zero Copy Connector for ERP: Enables direct access to ERP data via remote and extraction tables without importing or storing data permanently in ServiceNow.
    • Remote Tables: Define the schema and retrieve data from external ERP sources or other ServiceNow instances using REST or SOAP services. Data is held temporarily in memory in a read-only state, allowing users to view and manipulate external data with standard Glide scripts and list operations (sorting, filtering, grouping, aggregating).
    • Extraction Tables: Designed for handling large volumes of ERP data by regularly extracting and saving data to local transform tables within ServiceNow. This enables processing and usage of ERP data as a foundation for replatformed applications.
    • ERP Semantic Mining (ERP-CM): Uses AI/ML to analyze remote table data sent as attachments, helping identify replatforming candidates and recommending actions to optimize ERP data integration.

    Practical Use for ServiceNow Customers

    By leveraging the combination of Zero Copy Connector for ERP and ERP-CM, customers can seamlessly access ERP data without full data import, maintain up-to-date large data sets via extraction tables, and use AI-driven insights to modernize ERP processes on the ServiceNow AI Platform. Remote and extraction tables serve as data sources for building applications, workflows, and workspaces, enabling more agile and intelligent ERP data utilization.

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

    Using Zero Copy Connector for ERP, you can access standard fields for remote tables and ERP extraction tables, while ERP Semantic Mining (ERP-CM) enables you to find good candidates for replatforming from the system of record to the ServiceNow AI Platform.

    ERP-CM 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've identified candidates to replatform and taken the recommended action in ERP-CM, you need to use only 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-CM

    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.