Add a new ERP extraction table in ERP Data Hub

Create an ERP (Enterprise Resource Planning) extraction table to capture large amounts of data from the system of record every day, and save the data to a transformation (staging) table. The data is then available on the ServiceNow AI Platform, and you can add the extracted data to an ERP model or remote table.

Before you begin

You must first configure the source table, target table, and table transform map before those tables can be added to an ERP extraction table. For more information on creating table transform maps, see Create a transform map.

Role required:

• To modify extraction tables: sn_erp_integration.erp_admin
• To read extraction tables: sn_erp_integration.erp_user

About this task

ERP Data Hub provides a number of standard extraction tables, which you can use as-is. If you must change a standard extraction table, copy the table and then update the copied version.

You can create multiple ERP extraction tables, and multiple extraction tables can use the same ERP model. For example, create separate extraction tables for sales contracts, sales inquires, and old sales orders.

Procedure

1. Navigate to All > ERP Data Hub > ERP Data Hub Home.
2. Open the ERP extraction tables page by selecting the ERP extraction tables icon () in the side panel.
3. Select the New button.

   Figure 1. Add an extraction table in ERP Data Hub

   

4. On the form, fill in the fields.
   For a description of the field values, see ERP Data Hub extraction table field descriptions.
5. Select Save.