Data Warehouse Technologies & Tools

UTelco Systems uses the following technologies and tools in its Centre of Excellence (COE) to provide end-to-end Data Warehousing solutions in order to meet its customers' requirements:

Data Modelling Tools

  1. UTelco OneSolution Data Design Methodology
  2. CA Erwin Data Modelling Tool
  3. Power Designer Data Modelling Tool
  4. IBM Rational Rose

ETL Tools

  1. UTelco OneSolution Real-Time Data Quality Management (RT-DQM) Tool
  2. IBM DataStage
  3. Informatica
  4. Microsoft SQL Server Integration Services (SSIS)
  5. CR-X
  6. AB-Initio
  7. Business Objects – BDI
  8. Wherescape Red

RDBMS

  1. Vertica
  2. Greenplum
  3. IBM DB2 UDB EEE
  4. Netezza
  5. Teradata
  6. MS SQL Server
  7. Oracle

BI Reporting Tools

  1. MicroStrategy
  2. Business Objects
  3. Cognos
  4. Hyperion Solutions
  5. MS SQL Server Analysis Services (SSAS) & Reporting Services (SSRS)
  6. SAS
  7. Crystal Enterprise

Metadata Management

  1. UTelco OneSolution Metadata Management Methodology
  2. UTelco OneSolution Industry-specific Generic Enterprise Model (GEM)
  3. ASG Rochade-becubic
  4. Telelogic System Architect