Select the best ETL tool to fit your organization
The fifth edition of the independent ETL tools survey, published in April 2008, has uncovered some interesting features and shortcomings of the most popular ETL tools in the marketplace. Passionned, an independent consultancy and research company based in Amersfoort, The Netherlands, compared ETL tools across eight different categories and more than 80 criteria considered essential for attaining high productivity and Business Intelligence systems that work.
Background - List of ETL tools - Criteria - Ranking - Contents - Order
Many customers from all over the world have already downloaded the report and got real benefits from using the information it contains. Eighteen of the major players (see logos below) in this area have contributed to the survey. Get immediate insight into which ETL tools have scored well on specific categories and criteria. By doing so you will ensure that your organization gets the best ETL tool for the best price.
| "The ETL Tools Survey has been immediately useful to me" Richard Silverstein, Strategic Planning Manager Sweet & Maxwell Group |
SAS releases new version of Data Integration Studio
SAS has recently released a new version of Data Integration Studio (V 4.2) which has significantly improved the debugging facilities. This brings SAS into the first place for the first time in the category Basic Functionality. Read more in the section 'ranking by category' or download the ETL 2008 Survey Report.
What You See Is What You Get (WYSIWYG)
All the ETL vendors say the same thing: “our biggest competitor is custom code and stored procedures”. There are still a large number of organizations building data warehouses without using an ETL tool, writing their own, mostly very complex, SQL statements, often difficult to maintain. This is not very smart if you realize that an ETL tool can increase productivity by a factor of three to five. Two of the most important features in this case are that these tools are completely meta data driven, and work with an easy to understand graphical user interface (GUI). Some ETL tools are not only meta data driven, but in addition, they have an embedded data driven approach. They can show you, at any time you choose, how the data will be transformed and loaded into the data warehouse, without actually loading it. At any time, the user can press the ‘WYSIWYG’ button, and the ETL tool shows immediately what the results of an ETL flow would be. Read more in the analyst ETL 2008 Survey Report which is now available for purchase.
Has there been a marriage between EAI and ETL tools?
What are the similarities between Enterprise Application Integration and Extraction Transformation and Loading tools? Some people (analysts) think these technologies will converge to form one product, Enterprise Information Management. They both move data, often use the same metadata, so why shouldn't they merge into one package? Read why this may be a problem.
On-demand data integration
Most data warehouses do not contain all the company data. There is a reason why! Not all data is relevant for decision-making or for analysing the critical success factors and improving the performance of the organization. Once you have the right information in place, you will want to take action. In this action phase you may need 'operational' data, which is often outside the data warehouse. Read the advantages that on-demand data integration can bring to your enterprise.
Order the ETL Tool 2008 Survey Report
Get all information to select the best ETL tool for the best price by ordering the ETL 2008 Survey Report. For just EURO 425 (approx US$ 532) you will get real insight into using ETL tools to build successful data warehouses and we will send you results of comparing 18 ETL tools across 80 criteria. Open the table of contents to see what's in the ETL Survey Report. The price is stated in Euros and excludes local taxes. Applicable taxes will be applied during the checkout process.
|
More information: |
C O N T R I B U T O R S - E T L V E N D O R S
M E D I A P A R T N E R S
A N A L Y S T - O R G A N I Z A T I O N
