8 Application Data Service Connectors
A Connector is a data integration entity that defines the pipeline for data transfer from a source system (e.g., DFCS) to the target application (PBSMCS).
Key properties of a connector:
- Connector Code and Name: Each connector has a unique code and descriptive name for easy identification.
- Defined Source and Target Entities: A connector specifies the source entities and the corresponding target entity.
- Business Terms Mapping: It includes direct and derived mappings of business terms between source and target.
- Direct Mapping: The most frequently used mapping type is a direct mapping, where a PBSM business term corresponds exactly or closely to a matching term in DFCS.
- Expression Mapping: Also known as "Derived" mappings in the data files, expression mappings involve applying a specific formula or logic to translate a source business term into its target equivalent. These are used when direct or LOV mappings cannot fulfill the requirement.
PBSMCS ADS Connectors are grouped into 8 logical categories, each representing a distinct domain of data. PBSMCS will subscribe and orchestrate data movement jobs for these categories. Overall there are 35 connectors.
- Customer
- Dimensions
- Exchange Rate
- Instruments
- Instruments Supplementary
- Instruments Transaction Summary
- Market Rates
- Management Ledger
In the below tables we define some important parameters in terms of
connector mappings for the above-mentioned categories.
Table 8-1 Parameters for Connector Mapping
| Parameters | Connector Mapping |
|---|---|
| # of fields | Total count of mapped business terms mapped |
| # of key fields | Count of business terms mapped as Primary Keys |
| # of Direct Mapping | Count of business terms mapped as Direct |
| # of Expression Mapping | Count of business terms mapped as an Expression |
| # of variable mapping | Count of business terms mapped as parameters to be passed during execution |