Six Vendors with Middleware Products for Data Warehousing - dummies

Six Vendors with Middleware Products for Data Warehousing

By Thomas C. Hammergren

There are several vendors that offer data warehousing middleware products you might want to take a look at. Here are seven that are worth considering.

Composite Software

Composite Software provides Enterprise Information Integration (EII) products and technology. By using Composite, you can access and combine data from disparate data sources, including packaged applications such as SAP, custom applications, data warehouses, and XML data stores, as well as other data sources.


IBM Information Integration provides a data integration platform that incorporates EII; Extract, Transform, and Load (ETL); change data capture; replication; and other data warehousing middleware functionality.


Informatica provides a platform for data integration. The specific offerings from Informatica include the PowerCenter, On Demand data loader, B2B Data Exchange, and Data Quality.


Ipedo XIP is a data virtualization platform that allows organizations to aggregate and present information from disparate sources into their business intelligence, enterprise reporting, corporate portal, or service-oriented architecture (SOA) applications. Ipedo XIP’s Virtual Views allow applications to provide users with the information they want on-demand in real-time.


Within the Microsoft SQL Server product offering, you can find an ETL component known as SQL Server Integration Services (SSIS). This ETL technology leverages Microsoft’s .NET and SQL Server platforms for execution and deployment.


Oracle Warehouse Builder (OWB) enables you to design ETL processes and implement data integration solutions for your data movement requirements. Using a common metadata repository, OWB combines data integration capabilities with enterprise data quality tools to deliver end-to-end data integration optimized for Oracle databases.

Additionally, the Oracle Business Intelligence (BI) foundation component provides a unified business model, along with an enterprise information model that unifies metadata across the Oracle BI tools and analytical applications.

This BI infrastructure integrates with a majority of the popular data sources, major business applications, and databases, including IBM DB/2, Teradata, Microsoft SQL Server; SAP Business Information Warehouse (BW), Microsoft Analysis Services; flat files; XML data; and unstructured data.