Open Access. Powered by Scholars. Published by Universities.®

Computer Engineering Commons

Open Access. Powered by Scholars. Published by Universities.®

Data Storage Systems

PDF

Master's Theses (2009 -)

2015

Articles 1 - 1 of 1

Full-Text Articles in Computer Engineering

Converting Medical Service Provider Data Into A Unified Format For Processing, Brandon Krugman Jul 2015

Converting Medical Service Provider Data Into A Unified Format For Processing, Brandon Krugman

Master's Theses (2009 -)

Most organizations process flat files regularly. There are different options for processing files, including SQL Server Integration Services (SSIS), BizTalk, SQL import job, and other Extract, Transform, and Load (ETL) processes. All of these options have very strict requirements for file formats. If the format of the file changes, all of these options throw a catastrophic error, and implementing a fix to handle the new format is difficult. With each of the methods, the new format needs to be configured in the development environment, and the data flow must be modified to process all of the changes. Due to the …