Using ERP models, extraction tables, and remote tables

Use Zero Copy Connector for ERP 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 Zero Copy Connector for ERP 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 Zero Copy Connector for ERP. For more information, see Building flows to read or update the ERP system.

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.

Table 1. Parts of Zero Copy Connector for ERP

Zero Copy Connector for ERP 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 Zero Copy Connector for ERP 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.
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 Zero Copy Connector for ERP.
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 Zero Copy Connector for ERP.

• Building and managing ERP models to work with ERP data
  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 Zero Copy Connector for ERP
  After you identify and extract ERP (Enterprise Resource Planning) data with Zero Copy Connector for ERP, you can use that data on the ServiceNow AI Platform as the data source for products and apps.
• Managing ERP development pipelines in Zero Copy Connector for ERP
  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
  After you configure an operation in Zero Copy Connector for ERP, 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 Zero Copy Connector for ERP to SAP using OData and HTTP
  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 Zero Copy Connector for ERP
  ERP (Enterprise Resource Planning) remote tables in Zero Copy Connector for ERP enable you to view and query data from the ERP system of record on the ServiceNow AI Platform.
• Extracting and transforming data in Zero Copy Connector for ERP
  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 Zero Copy Connector for ERP.