Design and implement a system for cloud warehouse of cloud services which are related to one or more particular fields such as Software as a Service (SaaS), Infrastructure as a Service (IaaS) and Platform as a Service (PaaS). A cloud warehouse is a database used for reporting, analysis and data synchronization. The data stored in the cloud warehouse are collected from the external/operational systems provided as cloud services. The data may pass through an operational data store (ODS) for additional operations before it is used in the cloud warehouse for reporting. The cloud warehouse maintains its function in three layers: collecting, integration, and access. Collecting is used to store raw data from external/operational systems. The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users.