Q-Track™

It provides intuitive, accurate and meaningful information on flow of data by visualizing flow of production, processing and use of data starting from operating system to data warehouse and informational unit business process systems.

System Architecture
15p_QTrack
Features
Data Visualization
Draw invisible problems in data
  • Find out unreasonable connection structure in flow of production of data
  • Find out duplicated production processes of data
  • Grasp information on jobs and tables affected by failure in processing data
ETL Analyze
Analyze various ETL environments accurately and meaningfully
  • Provide data flow that integrated production and change of data, ETL tool and data processing script
  • Map tables ranging from operating system to informational unit business process systems
  • Map columns between tables
Data Lineage
Provide basis for communication between stakeholders
  • Provide information on related jobs and administrators based on changes in data
  • Provide basis for clear communication between administrators by offering accurate information on the course of generating and processing data
  • Provide basis for division of role among related units and administrators by grasping data flow when data are generated and errors occur in change
Function
Information on Control-M job schedule
· Extract mapping information between tables from information on schedule between domains and jobs
Information extracted from source data
· Extract information on layout of legacy tables in source system· Manage meta information on ETL used for extracting from source system
ETL information (TeraStream)
· Extract information on column mapping, Sort Scrip Language and USQL through meta information of ETL
· Sort Script Language and USQL call Cosort Script or SP, and they are processed through relevant parser
Program information
· Grasp through SP-embedded or SQL-embedded Shell, and processed through parser· Loading Program, Unload and Local Store(SQL)