1 / 4

Data Integration and Transformation Architecture for Application Data Management

This document outlines the architecture and responsibilities of data import and export processes within applications. It details the roles of application owners in managing data extraction through direct database access, log file extractions, and real-time triggers. It also describes the cleansing and mapping of data into standardized formats for storage or application utilization. Additionally, it emphasizes the central IT's duty to ensure message delivery through a robust vendor messaging system (MOM), ensuring consistent data management no matter the conditions.

razi
Télécharger la présentation

Data Integration and Transformation Architecture for Application Data Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Transformer Importer Spec Interest DataMart Integration Architecture Repository Rules Extractor Transformer Store & Forward MOM

  2. The In’s & Out’s Extractor/Importer • Responsibility: • Application Owner • Function: • Get data into or out of an application. • Approach: • Periodic direct DB extraction • Log File extraction • Report/Screen capture • Real-time trigger

  3. The Scrub Down Transformer • Responsibility: • Application Owner • Function: • Cleanse & Map Data into repository or application format • Approach: • Validate Data • Map to Std Definitions • Format & Route Message

  4. Come Rain or Snow or Dead of Night ………. • Responsibility: • Central IT • Function: • Assure message delivery • Approach: • Vendor Messaging system MOM

More Related