Est ablishment of a Data Quality Monitoring system for the Korean Intellectual Property Office
Challenges
It is difficult to identify errors that have occurred at the source (channel, account, etc.) when incorrect information is output from the information community.
Decreased productivity due to the need to check all source programs to understand unit programs, SQL, table, and column access information developed for the information market configuration
Solutions
Set target system information (IP, user) and target program language information to analyze data flow.
Register the set target system program, SQL parser, and map each analysis target source information.
Benefits
Visual representation of the ETL data flow by connecting the entire relevant program rather than the unit program makes it easy to understand the data processing flow before and after the point at which the error occurred.
Can easily find the program/SQL bar that uses tables and columns.