How ERP-CM works with ERP Canvas and remote tables

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 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 ECM works with ERP Integration and remote tables

    ERP Integration connects your ERP system of record to organize and access its data. ECM (ERP Customization Mining) identifies candidates for replatforming onto the ServiceNow AI Platform, suggesting updates to remote and extraction tables to facilitate ERP data access.

    Show full answer Show less

    Key Features

    • Remote Tables: Receive data from external sources via scripts, allowing you to integrate third-party systems and manipulate data without permanent storage.
    • Extraction Tables: Retrieve large data sets daily through scheduled queries, processing them in local transform tables for use in replatformed applications.
    • AI/ML Analysis: Analyzes data to identify suitable candidates for replatforming based on the information from remote and extraction tables.

    Key Outcomes

    By leveraging ECM and ERP Integration, you can effectively access and manage ERP data, facilitating the development of applications and workflows within the ServiceNow AI Platform. This integration streamlines processes and enhances data-driven decision-making without the need for extensive data imports.

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

    Using ERP Canvas, you can access standard fields for remote tables and ERP extraction tables, while ERP Customization Mining (ERP-CM) enables you to find good candidates for replatforming from the system of record onto 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 ERP Canvas 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 ERP Canvas 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 once a day 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.