ETL & Data Warehousing

We understand the performance issues of reporting from transactional systems, and have in-depth experience of structuring the data warehouse for optimum performance. We are knowledgeable on a wide range of ERP systems including JD Edwards, Oracle eBusiness Suite and SAP, accounts packages and source databases including Oracle and SQL Server.

Our consultants create data marts using Cognos Data Manager which lets you rapidly build and deploy a series of linked, subject area data marts that form an integrated business intelligence system. This ensures that all users have access to consistent data for more co-ordinated reporting and decision making across the enterprise.

In addition, we can also create report-ready operational data using Cognos Data Manager ETL (extraction, transformation, and load) software that lets you unite disparate data into an integrated bi foundation to deliver the reports and analysis that make operational data available for timely reporting.