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