Corporate performance management applications, from budgeting & planning applications to the data warehouse, all contain historical data, often collected from a variety of disparate sources. While a data warehouse combines this data, cleanses it for accuracy and consistency and organizes it for ease and efficiency of querying, budgeting & planning applications both send and receive data from the source.

Our consultants have expertise with many Extract, Transform & Load (ETL) and Enterprise Application Integration (EAI) tools that we use to integrate data from disparate sources and deliver coordinated performance management across your organization. Publish/Subscribe, advanced data merging, aggregation and transformation capabilities of these tools helps us integrate data from different sources, and transform it into information using best-practices dimensional design.

Metadata describes the integration rules and allows faster integration with OLAP & Reporting suites. While commercial software can be very important to your team's success, a large
percentage of today's environments still employ custom coding to transform and move data into the warehouse or budget and planning application. Custom coding is a cost effective means for initial deployment, and since database vendors continue to package light-weight data extraction software with their offerings, it promises to remain viable alternative.

Besides custom coding, we have extensive consulting experience with various ETL & EAI products including:

• Business Objects Data Integrator
  
• Cognos DecisionStream
  
• Hyperion Data Integration Services
  
• IBM WebSphere DataStage TX
  
• Informatica PowerMart
  
• Lawson Analytic Architect
  
• Microsoft SQL Server Data Transformation Services
  
• Microsoft SQL Server Integration Services
  
• Oracle Warehouse Builder (OWB)
  
• SeeBeyond eGate Integrator