Integrating Data from Legacy Systems Using Object Linking and Embedding Technology
Development of a Reporting System for Heavy Metal Poisoning Results
- Affiliation of the authors: Cleveland Clinic Foundation (S-CL, KR, WHH) and Cleveland State University (AF), Cleveland, Ohio
- Correspondence and reprints: Shang-Che Lin, L22 Laboratory Information Services, Cleveland Clinic Foundation, 9500 Euclid Avenue, Cleveland, OH 44195; e-mail: <lins1{at}ccf.org>
- Received 8 December 1999
- Accepted 31 January 2000
Abstract
Integrating data that reside in different systems remains an often laborious process, requiring either manual steps or complicated programming. This paper describes a method for state-mandated reporting of childhood blood lead testing results that makes use of object linking and embedding technology and readily available software products to pull together information from different legacy systems. A terminal session emulator employs object linking and embedding automation to extract host data, and Visual Basic routines specify the user interface and database manipulation. This system has significantly increased the efficiency and accuracy with which blood lead testing reports are provided to the local state health department. The system provides a model for a relatively easy solution for laboratories and other groups that need a way to integrate standard data sets that are distributed across legacy systems.
