Home Up Database Integration Grails Compliance Terrorism AppServers XML and SQL


Fast, reliable data access for ODBC, JDBC, ADO.NET and XML
WSSC 2008: An event dedicated to SOA and Web Services Security
Got SOX compliance?
Movielink Logo 88x31
Business Intelligence with R&R ReportWorks
IBM eserver xSeries 306m 8849 - P4 3.4 GHz
iTunes Logo 88x31-1


Integration with EAI, EII and ETL Tools

App Servers
2003 Market
2004 Market

Open Source BI


2003 Market
2004 Market





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.

Sponsor Links
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.