JSAIS 2012-002 – Managing ETL Applications Compatibility During Upgrades


Extraction-Transformation-Loading (ETL) tools are software applications responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. ETL tool mainly supports integrating data for building the enterprise data warehouse. To meet different business requirement and in order to bring system up to date or to improve its characteristics for data integration, it’s necessary to upgrade these ETL tool as and when needed. In this article we discuss about the challenges involved in ETL applications compatibility evaluation during ETL tool upgrade and propose a step by step method to approach that. We also share the result about significant improvement achieved by this approach during couple of recent upgrade activity in our organization.

Keywords: ETL; Data Integration; Environment Upgrade; Compatibility; Data warehousing; Business Intelligence.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: