Zero Copy Connector for ERP extraction table field descriptions

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • The Extraction table form in Zero Copy Connector for ERP enables you to create and edit extraction tables in the ERP (Enterprise Resource Planning) model.

    For process details, see Add a new ERP extraction table in Zero Copy Connector for ERP.

    Table 1. New ERP extraction table fields
    Field Description
    Name Name of the ERP extraction table.
    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.
    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.
    ERP model ERP model for the extraction table source, which must be configured for you to select.
    ERP module Name of the ERP functional area in the system of record. For example, logistics, procurement, or sales.
    Target table link Link to the final table in which the extracted ERP data resides.
    Short description Brief description of the ETL source.
    Long text Any additional text to describe the ERP extraction table.