Open Source BI
ETL, EAI and EII
By Ken North
A research report published by The Data Warehousing Institute (TDWI) explores several approaches to integration, reports adoption levels and forecasts adoption trends for the next two years. The author of "Data Integration: Using ETL, EAI, and EII Tools to Create an Integrated Enterprise" is Colin White, founder of BI Research and a respected IT expert.
Research for the report included interviews with expert and a survey about integration trends that received data from 672 respondents. 35% per cent of the respondents were from companies with less than $100 million in annual revenue, 28% were from companies with revenues between $100 million and $1 billion, and 37% were from companies with more than $1 billion in annual revenue. 7%5 of the survey respondents were from the US or Europe.
Fast, reliable data access for ODBC, JDBC, ADO.NET and XML
The report discusses four levels of integration in the enterprise:
- application integration
- business process integration
- data integration
- user interaction integration.
The 40-page report describes several approaches to data integration, including consolidation, propagation and federation. It also reviews data integration technologies such as enterprise content management (ECM), enterprise application integration (EAI), enterprise information integration (EII), enterprise data replication (EDR) and extract, transform and load (ETL).
For each approach to integration, the report includes current adoption levels and a forecast of adoption over the next two years. Survey responses indicated there will be double-digit growth over the next two years in the adoption of ECM, EAI, EII, ETL and EDR tools.
The research found that almost half of the survey respondents are using real-time solutions to integrate with data warehouses or operational data stores. Research for the report also included a survey of buying practices, such as adopting best-of-breed products or single vendor solutions. The report also included the data integration features considered most important by survey respondents.
The report is one of a series published by TDWI, a property of 101 Communications. Registration is required to download the report or view the associated webinar.
On the web
Data Integration: Using ETL, EAI, and EII Tools to Create an Integrated Enterprise
The Data Warehousing Institute
© 2006, North Summit Media. All rights reserved.