3.4.2.1 Create Custom Connector

This section explains how to create a new custom connector in DFCS to extend or modify the existing connector functionality.
  1. Go to the Application Connectors page.
  2. Download the Connector Extension Template (.xlsx) from an existing Application Connectors.
    1. Select any existing published connectors from the list of seeded/ custom connectors.
    2. Click on the three dots menu → Download.

    Note:

    The connector extension template Excel is used only for creating extensions to existing connectors. It is not to be used for creating new ADS connectors.
  3. Open the downloaded file and enter the required connector details.

    Note:

    Replace the Base Connector Name with the seeded connector name in the downloaded template before saving.
  4. Click Create New Connector. The system opens the Create Connector wizard.

    The Create Connector page appears with a wizard navigation panel showing six steps:

    1. Create Connector
    2. Key Business Terms
    3. Direct Mapping
    4. Variable Mapping
    5. Expression
    6. Review
  5. Click Select a custom connector data file (xlsx) to browse and upload your connector definition file.
    • Alternatively, drag and drop the Excel file into the upload area.
    • Ensure the uploaded file adheres to the Connector Extension Template (.xlsx) structure.
    • The maximum file size allowed is 1 MB.

    Note:

    If the connector is validated successfully with warnings, it means the upload is accepted but certain mappings or configurations may need attention. It is recommended to review and address these warnings (for example: missing optional mappings, unused terms, or missing default values) before publishing to ensure data consistency.
  6. Click Key Business Terms to view the target business terms to corresponding source business terms. Key business term mappings cannot be edited or modified in this tab because they reflect the base connector’s original key business term mappings.
  7. Click Direct Mapping.
    • View one-to-one mappings between target business terms and source entities. Note that only the Review option is available and cannot create or modify mappings.
    • Use the search option to locate target or source terms quickly.
    • For rows with a LOV Mapping (List of Values), click View to open the LOV details.

      The dialog displays columns such as Behavior Type, Behavior Type Name, and Application Service Behavior Type Code.

  8. Click Variable Mapping to view system variables to target terms or assign default values. This ensures that runtime variables or file metadata are correctly passed into connector mappings. Users can only view or review mappings in this tab. Assigning or editing mappings is not permitted here.
  9. Click Expression to define formulas or conditional expressions.

    Note:

    The system displays both Seeded (predefined by the application) and Custom Derived (user-created) Business Terms in this section. Each BT may have an associated Expression, which defines how its value is derived.
  10. Verify expressions for syntax and reference correctness (entity/column IDs must match the source entity).
  11. ClickReview to verify all connector details.
  12. Once you have confirmed that the information is correct, click Continue to proceed.
  13. After making necessary edits and reviewing mappings, the connector’s status updates to Validated.
  14. To finalize, click the three-dot menu (⋮) beside the connector entry and select Publish Connector to make it available for use. You can also click Download to export the connector definition.
  15. To exit without saving, click Cancel.