Restricted access

September 10, 2009

ETL Deployment: Ensuring Right Expectations

Filed under: Data Integration, ETL — Olga Belokurskaya @ 8:26 am

Business intelligence can’t be imagined without data integration and extraction. Choosing and implementing the right technology is a key to successful business intelligence deployment. However, many organizations in pursuit of the best of the best of the best extract, transform, and load (ETL) product overlook the fact that ETL technology should primarily fit organization’s business needs.

Another mistake organizations often make is expecting that ETL implementation will help finishing the project quicker. But they do not take into account the time needed to find and implement the technology, to train personnel to use the tool and be productive with it. According to TDWI, this period may take up to six month.

Expecting for immediate savings is not the right approach either. In fact, the investment in high-end technology acquisition is, normally, equal to the total labor cost for an average data warehouse built with hand-coded ETL. Adding to this the development and annual support cost for a high-end ETL tool, we receive three-four years to get the point of make-out.

Considering all those factors will ensure that the stakeholders’ expectations of a project are appropriate and ROI analysis is right.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment