This Article Full Text Full Text (PDF) Submit a response Alert me when this article is cited Alert me when eLetters are posted Alert me if a correction is posted Services Similar articles in this journal Similar articles in PubMed Alert me to new issues of the journal Download to citation manager Citing Articles Citing Articles via Google Scholar Google Scholar Articles by Lin, S.-C. Articles by Henricks, W. H. Search for Related Content PubMed PubMed Citation Articles by Lin, S.-C. Articles by Henricks, W. H.

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>.

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.