Skip to content
Extracting and transforming data › Retrieving data › Use › Zero Copy Connector for ERP › Workflow Data Fabric
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Create a table transform map from an extraction table

In Zero Copy Connector for ERP (Enterprise Resource Planning), create a table transform map from an extraction table and map the source fields with target fields.

Before you begin

Role required: sn_erp_integration.erp_admin

Confirm that you have an extraction table associated with a model containing output parameters. For more information, see Add a new ERP extraction table in Zero Copy Connector for ERP and Choose output parameters for a model.

Note: The following procedure generates a new transform map and a new staging table. To modify an existing transform map or an existing staging table, navigate to the record and update manually. Transform maps are in System Import Sets > Administration > Transform Maps and staging tables are in System Definition > Tables.

Procedure

  1. Navigate to All > Zero Copy Connector for ERP > Zero Copy Connector for ERP Home.

  2. Open the ERP extraction tables page by selecting the extraction tables icon

Image omitted: erpc-extraction-table-icon.png
in the side panel.

  1. Select an extraction table to work with by selecting the Name.

    The table should have an ERP model that contains some output parameters.

  2. Select Generate mapping.

  3. In Select mapping table, specify the destination table for the data obtained from an external source.

Image omitted: erpc-transform-map-extraction-table1.png
Generate mapping overlay with select mapping table field highlighted.

  1. Create the mappings by selecting an output in the Available model outputs column and then selecting a column in Available columns.

    As you work, the mappings are saved in the Field Mapping section to create the import map staging table and the transform map. For general information, see Import sets key concepts and Create a transform map.

Image omitted: erpc-transform-map-extraction-table2.png
Generate mapping overlay with output fields and field mapping sections highlighted.
To change a mapping, you can drag the items within the **Selected model outputs** column or the **Selected columns** column. As you make changes, the **Field Mapping** section updates automatically.

  1. In the Field Mapping section, select the Coalesce option for each mapping.

    For more information, see Updating records using coalesce.

  2. Select Save.

    The import set staging table and a transform map that can be used by Zero Copy Connector for ERP to push the data into the destination table are generated. The extraction table record opens. A confirmation message is displayed stating that the staging table was generated and there’s a link to the transform map.

  3. Select the link at the top to open the transform map.

Image omitted: erpc-transform-map-extraction-table3.png
Extraction table record with transform map link highlighted.
In **Source table**, the staging table is listed with its auto-generated name. The **Field Maps** related list contains the fields you mapped.

  1. Return to the extraction table record (it might be open in a different browser tab).

  2. To view the transform map at any time, select the link in Table transform map link.

Parent Topic:ERP data extraction and transformation