--- 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 --- # Using ERP models, extraction tables, and remote tables # Using ERP models, extraction tables, and remote tables {#ariaid-title1} * Release version: Yokohama * * Updated January 30, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read Use ERP Canvas to work with ERP (Enterprise Resource Planning) models, remote tables, and extraction tables to integrate ERP data from the system of record onto the ServiceNow AI Platform. The workflow of ERP Canvas generally follows its main sections, each of which you access by selecting the section icon in the contextual side panel. Figure 1. Data models and ERP data You can also build flows in Workflow Studio to use retrieved ERP data for processes or tasks outside of ERP Canvas. For more information, see [Building flows to read or update the ERP system](https://servicenow-prod.fluidtopics.net/NdbNUiPnlKTbiurxTBkbMA "After you configure an operation in ERP Canvas, you can build a flow in Workflow Studio to specify details for querying the ERP (Enterprise Resource Planning) system. For example, build a flow that filters by Order ID."). Build an ERP model using remote tables and extraction tables to organize, load, and transform ERP data, as well as flows to query the ERP system.{#work-with-erp-systems-connections-and-remote-tables__table_fjx_zj2_5xb__entry__2} | ERP Canvas section | Description | |-|-| | ERP models | ERP models function as templates for sets of tables that give you access to ERP data. You can use the standard ERP Canvas models as-is, or clone them to make changes. Manage models to map input and output data for reading and updating the ERP system using wither table read operations or BAPIs (Business Application Programming Interface). For more information, see [Building and managing ERP models to work with ERP data](https://servicenow-prod.fluidtopics.net/HRzgoiy99IVfEvr_ce8MDA "ERP (Enterprise Resource Planning) models function as templates for sets of tables that give you access to ERP data. Use model management to create read and update operations that access the ERP system with specified inputs and outputs to map fields for use on the ServiceNow AI Platform."). | | Flows to query ERP data | Build a flow in Workflow Studio to specify details for querying the ERP system using the parameters specified in the model. | | Remote tables | Remote tables enable you to view and query data from the ERP system of record on the ServiceNow AI Platform. For more information, see [Using ERP remote tables in ERP Canvas](https://servicenow-prod.fluidtopics.net/9is_2pXsSPIVbTTybNNxwg "ERP (Enterprise Resource Planning) remote tables in ERP Canvas enable you to view and query data from the ERP system of record on the ServiceNow AI Platform."). | | ERP extraction tables | Extraction tables use an ETL process to extract large amounts of data from the ERP system at regular intervals and transform and save them to a Glide table. For more information, see [Extracting and transforming data in ERP Canvas](https://servicenow-prod.fluidtopics.net/vscoTE3absmkUqNVei048g "ERP (Enterprise Resource Planning) extraction tables enable you to create daily processes that extract large amounts of data. You can then include the extracted data in an ERP model in ERP Canvas."). | [Table 1. Parts of ERP Canvas] {#work-with-erp-systems-connections-and-remote-tables__table_fjx_zj2_5xb} * **[Building and managing ERP models to work with ERP data](https://servicenow-prod.fluidtopics.net/HRzgoiy99IVfEvr_ce8MDA)** ERP (Enterprise Resource Planning) models function as templates for sets of tables that give you access to ERP data. Use model management to create read and update operations that access the ERP system with specified inputs and outputs to map fields for use on the ServiceNow AI Platform. * **[Next steps after extracting data from your ERP system using ERP Canvas](https://servicenow-prod.fluidtopics.net/CqWeyRqtqZnYx2S7xEOaWA)** After you identify and extract ERP (Enterprise Resource Planning) data with ERP Canvas, you can use that data on the ServiceNow AI Platform as the data source for products and apps. * **[Managing ERP development pipelines in ERP Canvas](https://servicenow-prod.fluidtopics.net/f6zDumUXbxbzy06GFbwj0g)** Move your ERP (Enterprise Resource Planning) systems, ERP models, tables, operations, and flows from a development instance to a production environment when they're ready. * **[Building flows to read or update the ERP system](https://servicenow-prod.fluidtopics.net/NdbNUiPnlKTbiurxTBkbMA)** After you configure an operation in ERP Canvas, you can build a flow in Workflow Studio to specify details for querying the ERP (Enterprise Resource Planning) system. For example, build a flow that filters by Order ID. * **[Connect ERP Canvas to SAP using OData and HTTP](https://servicenow-prod.fluidtopics.net/uIRHJSTlNNYPJ0Kds1FUVg)** Extract data securely from ERP OData v2 APIs using ETL for use in remote tables and extraction tables. OData connects to SAP via HTTP. * **[Using ERP remote tables in ERP Canvas](https://servicenow-prod.fluidtopics.net/9is_2pXsSPIVbTTybNNxwg)** ERP (Enterprise Resource Planning) remote tables in ERP Canvas enable you to view and query data from the ERP system of record on the ServiceNow AI Platform. * **[Extracting and transforming data in ERP Canvas](https://servicenow-prod.fluidtopics.net/vscoTE3absmkUqNVei048g)** ERP (Enterprise Resource Planning) extraction tables enable you to create daily processes that extract large amounts of data. You can then include the extracted data in an ERP model in ERP Canvas.