ETL and Data Integration Methodology

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