Customer Success Stories

Korean Intellectual Property Office

Korean Intellectual
Property Office

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.