1. Accounting Foundation Cloud Service Core Functions
  2. Managing Data
  3. Data Egress
  4. Ingesting Data into AFCS

12.3.3 Ingesting Data into AFCS

To create a connector for ingesting data into AFCS, complete the following steps:
  1. On the Sub Ledger Applications page, click the SLA for which you want to define a connector and click Data Ingestion.
    The connectors which are defined are listed here.
  2. From the LHS menu select Connectors if it is not already selected.
  3. Click Add.
    The New Connector window is displayed.
  4. To define a connector, you must have a source with EDD and a target, which is ADI.
  5. Click Source to view the list of EDDs defined in the default EDS of the ERP File Extracts.
  6. Select the default EDS-ERP File Extracts file type EDD and drag it on to the canvas.
  7. Click Target.
  8. Search for the ADI you are looking for.
  9. Select the required ADI and drag it on to the canvas and then link the input and output nodes.
  10. To link the nodes, right click on a component and click Link to and select the component you want to link it with. You can also use your mouse to link the nodes. Point your mouse on the white circle of the input node and with your left-mouse button pressed, move the cursor to the white circle on the output node and release the mouse button.
  11. At any given time, you can right-click a node to either link, delink, remove inlinks/outlinks, or delete a node.
  12. To edit or view the properties, on the Connector window, click the Next button on the top of the page.
  13. Under Connector Details, enter the name and description for the connector.
  14. Under Pre-Load Options, select the truncate option to be defined in the target.
    • Select one of the available truncate options if you want to remove data from the table. Select No, if you do not wish to truncate the table before loading.
    The Partial Truncate is not enabled in 22D 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. Example: To truncate the entire table. Here no expression is required.
    • Select Selected Rows to truncate based on a specified filter expression. Click the edit button next to Specify filter expression to define the expression. Example; If you want to remove some rows, use the Selected Rows option. Specify the filter condition for the rows to be deleted. Those 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 after the expressions are selected.
  15. Under Properties, enter the value in the Target Rejection Threshold field. You can define the value in number or percentage of error records. For more details, see the Using Target Rejection Threshold. section.
  16. Click Save or Save As Draft.