How ERP-CM works with ERP Data Hub and remote tables

  • Release version: Xanadu
  • Updated August 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 ERP-CM works with ERP Data Hub and remote tables

    ERP Data Hub enables ServiceNow customers to connect to their ERP systems of record and organize ERP data efficiently. It provides access to standard fields via remote tables and ERP extraction tables. ERP Customization Mining (ERP-CM) complements this by identifying strong candidates for migrating ERP customizations to the ServiceNow AI Platform. ERP-CM also recommends next steps, such as updating remote and extraction tables to access ERP data effectively.

    Show full answer Show less

    How ERP-CM and ERP Data Hub Work Together

    ERP-CM uses AI/ML to analyze ERP data sent as attachments from remote tables to identify candidates suitable for replatforming. After identifying these candidates and following ERP-CM’s recommendations, customers rely on ERP Data Hub to access and manage remote and extraction tables. These tables then serve as foundational data sources for building ServiceNow apps, flows, and workspaces.

    Using Remote Tables and Extraction Tables

    • Remote Tables: Define the schema of external ERP data and retrieve records by running scripts against external sources or other ServiceNow instances using REST or SOAP. Data accessed via remote tables is transient, read-only, and stored in memory, allowing users to view, sort, filter, and process external ERP data without importing or storing it permanently.
    • Extraction Tables: Designed for handling large volumes of ERP data, extraction tables regularly pull data from the ERP system and save it into local transform tables on the ServiceNow AI Platform. This local data can be processed further and used as the basis for replatformed applications.

    Practical Benefits for ServiceNow Customers

    • Seamless integration with ERP systems to access and organize ERP data without complex data imports.
    • AI-driven insights from ERP-CM to identify and prioritize ERP customizations for migration to ServiceNow.
    • Flexible data retrieval options: use remote tables for lightweight, transient access or extraction tables for bulk data processing.
    • Use ERP Data Hub as a centralized platform to manage ERP data sources, enabling the creation of apps, workflows, and workspaces built on trusted ERP data.

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

    Using ERP Data Hub, 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 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 ERP Data Hub 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 Data Hub 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.