Integration with EAI, EII and ETL Tools
App Servers 2003 Market 2004 Market BizIntel Open Source BI Compliance SOX DBMS 2003 Market 2004 Market Integration ETL, EAI and EII Modeling CWD4ALL Presentations Tech Trends		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 Single Signon with SAML 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 BI Research Data Integration: Using ETL, EAI, and EII Tools to Create an Integrated Enterprise The Data Warehousing Institute © 2006, North Summit Media. All rights reserved.