ERP Data Hub extraction table field descriptions

  • Release version: Xanadu
  • Updated August 1, 2024
  • 1 minute to read

    • The Extraction table form in ERP Data Hub enables you to create and edit extraction tables in the ERP (Enterprise Resource Planning) model.

    Table 1. New ERP extraction table fields
    Field Description
    Name Name of the ERP extraction table.
    ERP model ERP model for the extraction table source, which must be configured for you to select.
    Table transform map Table that the extracted data is cached and stored in.

    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.

    The specified Glide table connects the source ERP extraction table and the target table for the extracted data.

    If you use a custom transform table, you must first create the table on the ServiceNow AI Platform, and the table must be in the application scope. For more information on creating table transform maps, see Create a transform map.
    ERP module Name of the ERP module linked to the ERP extraction table, which is controlled by the ERP model.
    Table transform map link Link to the Glide table that the extracted ERP data is cached and stored in.

    After you save the extraction table, when you select the link, the ServiceNow AI Platform table opens in a new browser tab.
    System ERP system that the ETL (extract, transform, and load) process extracts data from on the system of record. The system must already be configured.
    Short description Brief description of the ETL source.
    Long text Any additional text to describe the ERP extraction table.
    Comments Public comment that is visible to anyone working on the ERP extraction table.
    Work notes Private notes that only you can view.