An ETL tool is a tool that:
• Extracts data from various data sources (usually legacy)
• Transforms data
• from -> being optimized for transaction
to -> being optimized for reporting and analysis
• synchronizes the data coming from differ databases
• data cleanses to remove errors
• Loads data into a data warehouse
Why use an ETL tool?
• ETL tools save time and money when developing a data
warehouse by removing the need for “hand-coding”.
“Hand Coding” is still the most common way of integrating data
today.
• It requires hours and hours of development and expertise
to create a Business-Intelligence-System.
• It is very difficult for data base administrators to connect
between different brands of databases without using an external
tool.
In the event that databases are altered or new databases need to be integrated, a lot of “hand-coded” work needs to be completely redone.
Most ETL Tool used? Why?
• Informatica and Pentaho have very good products.
• Informatica has a far more extensive range of products, but compared to Pentaho is very expensive.
• Pentaho has proved that it can handle small to large scale systems.
• Pentaho is gaining fast momentum with businesses that would not have considered using open source products before.
Posts
0 comments:
Post a Comment