What technologies and tools are used to construct and maintain a Data Warehouse

The answer to the above question is - the ones your staff are most familiar and comfortable with. However you should bear in mind all your options as in some cases the benefits of using technology you are unfamiliar with can far outweigh the costs associated with learning new technologies. 
Warehouses run on databases, so you first need to choose a database management system such as MS SQL Server, DB2 or Oracle and the appropriate platform on which to run the system. In our experience the most powerful combination is Oracle running on a UNIX platform however MS SQL Server running on Windows NT is more user friendly and more widely used.


Which option you choose is dependent on at least: 


  • What technologies are your IT staff familiar with? 
  • What is the availability of support services for a particular database / platform combination? 
  • Where on the cost / speed continuum do your needs lie? 


Once a platform and database management system has been chosen you then need to look at the tools for constructing the warehouse and those for delivering the knowledge contained in the warehouse to your staff.We have shown you our warehouse construction and knowledge delivery tools via the links above. To determine the most appropriate technologies and tools for your enterprise requires a thorough analysis of your needs and future direction. Should you need help in taking these first steps towards the creation of a warehouse, please contact us and we will assist you every step of the way. But why should you turn to IDS to assist you? 


"We are drowning in information and starving for knowledge" - John Naisbitt Megatrends

To follow...
  • MTN
  • Santam
  • Absa
  • Old Mutual
All Our Clients
Case Studies
  • Old Mutual
  • Santam
  • Absa
  • CSC
  • Uskotec
  • MTN
  • South African Airways
  • Vyinde
More Casse Studies
The 500 Year Delta

"The Information Age...is dead and gone, replaced by the information economy...The Information Age was about the building of databases. It was about the rise of…

Read More