1 Data Integration

Data Integration is a core service within OFSAA that enables robust and seamless data exchange between OFSAA applications and external systems. It abstracts the underlying Financial Services Data Foundation (FSDF) and exposes it through Application Data Interfaces (ADIs), simplifying the process of data ingestion, transformation, and extraction.

Data Source Templates: These templates help define external data sources that are to be integrated into OFSAA.
  • Standardized metadata definitions
  • Consistent mappings for seamless ingestion
  • Support for various input formats
Example: If integrating an external banking system, a Data Source Template ensures that customer account fields are properly mapped to the corresponding FSDF attributes.
  • Connectors: Connectors establish the technical connection between OFSAA and external sources such as:
    • Databases (e.g., Oracle, SQL Server)
    • Flat files (e.g., CSV, XML)
    • APIs (REST/SOAP)
    • They define:
      • Connection parameters (e.g., host, port, credentials)
      • Supported protocols and data formats
      • Pre-load behavior and mappings

        Example: A connector can be configured to pull investment data nightly from an external data warehouse via SFTP.

  • Data Operations: This module provides a graphical or script-based interface for creating end-to-end data workflows.
  • Core capabilities include:
    • Data transformation (e.g., cleansing, enrichment)
    • Process orchestration
    • Support for batch or real-time execution
    • Error handling and monitoring

      Example: A data operation may transform raw transaction feeds by aggregating balances and enriching them with customer metadata before loading into FSDF.

  • Data Extraction: This service allows users to extract data from the OFSAA data foundation for:
    • External reporting
    • Analytics tools integration (e.g., Power BI, Tableau)
    • Feeding regulatory systems

    Supported methods:

    • Scheduled extracts
    • API-based pulls
    • Custom scripts or jobs

    Example: Extracting the daily balance sheet summary to a flat file for upload into a central reporting system.