Work with ETL (extract, transform, and load) processes in ERP Data Hub to extract large amounts of ERP (Enterprise Resource Planning) data from the ERP system. Extracted data is stored in Glide tables in the ServiceNow AI Platform.

Before you begin

Role required: sn_erp_integration.erp_user

About this task

ERP extraction tables extract and save data to a transform table on the ServiceNow AI Platform. The transform table is a temporary table that holds data during the data integration or transformation process. Transform tables are an intermediary step before data is further processed, cleaned, or loaded into the target destination.

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 (ERP extraction tables navigation icon) in the side panel.
    Figure 1. Extraction tables in ERP Data Hub
    ERP extraction tables list
  3. View the list of ERP extraction tables and note of the tables that you can use to build your ERP model.
  4. (Optional) View the details for an extraction table by selecting the table name.

What to do next

After the extraction process is run, use import sets to map imported data into ServiceNow AI Platform tables. For more information, see Import sets.