Select fields for an extraction table in Zero Copy Connector for ERP

Add or remove fields for an extraction table in Zero Copy Connector for ERP. For example, you may want to remove fields with sensitive information, such as birthdays.

Before you begin

If you don't see the fields that you want to add to the extraction table, you must first add them to the model. For more information, see Choose output parameters for a model.

Role required: sn_erp_integration.erp_admin

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 in the side panel.
3. Select an extraction table to work with by selecting the Name.
4. Manage the columns to build the extraction table by selecting the arrow next to Generate mapping and then selecting Select fields.
   1. In Available columns, find the field to add and select the check box (if the list is long, use the search box to filter the list).
   2. In Selected columns, drag fields up and down to rearrange how they appear in the table.
   3. After you're finished, select OK.
      The fields on the extraction table are updated.
5. Confirm that the fields appear correctly as columns on the extraction table by selecting the Extraction table fields tab.