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 an ERP model.

Role required:

• To modify extraction tables: sn_erp_integration.erp_admin
• To read extraction tables: sn_erp_integration.erp_user

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 ERP 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 and select the field that you want to add to the extraction table using the search box.
   2. Select the button to move the field from the Available columns list to the Selected columns list.
   3. Drag to rearrange how fields appear in the table.
   4. After you finish adding all the fields, select OK to save your changes.
      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.