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.