--- sourceDocument: Yokohama Build or modify applications sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/application-development Release : - yokohama ft:locale : - en-US ft:publication_title : - Yokohama Build or modify applications ft:clusterId : - cadev bundleId : - cadev workflow : - Development, Data, and Analytics --- # How ERP-CM works with ERP Canvas and remote tables # How ERP-CM works with ERP Canvas and remote tables {#ariaid-title1} * Release version: Yokohama * * Updated January 30, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) 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 Canvas and remote tables ERP Canvas allows you to connect to your ERP system of record and organize its data within the ServiceNow AI Platform. It provides access to standard fields for remote tables and ERP extraction tables. ERP Customization Mining (ERP-CM) complements this by identifying good candidates for replatforming ERP data and processes onto the ServiceNow AI Platform. ERP-CM recommends actions such as updating remote and extraction tables to facilitate data access and migration. Show full answer Show less ## How ERP-CM and ERP Canvas Work Together * **ERP-CM**: Uses AI/ML to analyze data sent as attachments from remote tables, suggesting candidates for replatforming and guiding next steps. * **ERP Canvas**: After replatforming candidates are identified and actions taken, ERP Canvas is used to access remote tables and extraction tables---the primary data sources for building apps, flows, and workspaces on the platform. ## Remote Tables and Extraction Tables Both remote tables and extraction tables enable retrieval of ERP data in different ways: * **Remote Tables**: Define the schema for data retrieved from external sources or another ServiceNow instance using REST or SOAP services. Data is retrieved into memory in a read-only, transient state without importing or storing it permanently. This allows viewing and manipulating external ERP data like internal tables, including grouping, sorting, filtering, and scripting. * **Extraction Tables**: Designed for handling large volumes of ERP data by regularly saving data into local transform tables within the ServiceNow AI Platform. This data can then be processed and forms the foundation for replatformed applications. ## Practical Benefits for ServiceNow Customers * Seamlessly connect and organize ERP data within ServiceNow using ERP Canvas. * Leverage ERP-CM's AI-driven analysis to identify and prioritize ERP components for replatforming. * Use remote tables for real-time, temporary access to ERP data without permanent storage. * Use extraction tables to manage and transform large ERP datasets for building robust ServiceNow applications. * Streamline the migration of ERP data and processes onto the ServiceNow AI Platform, enabling modern app development and automation. 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 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 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 {#ecm-and-erp-integration__id_q1q_ykn_swb} 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.{#ecm-and-erp-integration__erpc-remote-extraction-difference-ul-remote} * 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.{#ecm-and-erp-integration__erpc-remote-extraction-difference-ul-extr} {#ecm-and-erp-integration__erpc-remote-extraction-difference-ul} 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](https://www.servicenow.com/docs/access?context=remote-tables&version=yokohama&pubname=yokohama-servicenow-platform&ft:locale=en-US). 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.