.To create a Connector for ingesting data into AFCS, follow these steps:
1. On the Data Ingestion page, click Connector.
The connectors which are defined are listed here.
2. Click Add.
The New Connectors Definition window is displayed.
3. To define a connector, you must have a source with EDD and a target, which is ADI.
4. Click Source to select the required EDD from the list defined in the default EDS of the ERP File Extracts.
5. Select the default EDS-ERP File Extracts File Type EDD and drag it to the canvas.
6. Click Target.
7. Click Search to search for a particular ADI.
8. Select the required ADI. Drag it to the canvas and then link the input and output nodes.
9. Click the
input white circle.
The anchor symbol is displayed. Drag and drop the line to link it to the
required component.
10. At any given time, you can right-click the node to either delink or remove links/outline or delete a node.
11. To edit or
view the properties, on the Connector window,
click .
12. In Connector Details, enter the name and description for the connector.
NOTE:
· The metadata key will be available in the Connector Properties tab.
· In View or Edit mode, you can copy the Metadata Key of the Connector using the Copy icon.
13. In Pre Load Options, select the truncate option to be defined in the target.
§ To remove data from the table as per the truncate option specified, select Truncate.
Select No, if you do not wish to truncate the table before loading.
The service will display an option to perform Partial Truncate. This option is not enabled as of 22B and should not be chosen.
NOTE:
· For multi-target loads, the truncate type must be the same for all targets. However, truncate expression may vary.
§ Select Full Truncate to fully truncate. Here no expression is required. If you want to truncate the entire table, the Full Truncate option must be selected.
§ Select Selected Rows to truncate on the selected expressions. If you remove specific rows, the selected rows option must be selected. Specify the filter condition for the rows to be deleted. Specific rows are removed from the table before load.
— Click Edit to filter the selected rows.
— Select the required entity and click Validate. This validates the expression.
— Click Ok once the expressions are selected.
In the image, truncate details are selected for Account Address.