Working with ERP models, extraction tables, and remote tables

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.

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 ERP Canvas

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.
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.
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.

• 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.
• Building flows to read or update the ERP system
  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.
• Using ERP remote tables in ERP Canvas
  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
  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.