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 for data extraction and transformation from disparate sources and delivering performance management across your organization. Publish/Subscribe, advanced data merging, aggregation and data 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 data extraction 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
- SQL Server Data Transformation Services (DTS)
- SQL Server Integration Services (SSIS)
- Oracle Warehouse Builder (OWB)
- SeeBeyond eGate Integrator