SAP Data Warehouse Cloud
Confident and intelligent decision-making
With SAP Data Warehouse Cloud (DWC), SAP is now offering a cloud solution that allows analytics applications to be created in a fast and agile manner.
You will be able to gain new insights at a glance. Build your own data model to suit your needs, thus keeping in control of all changes and costs. SAP has made a promising start with this solution; further functions now need to follow speedily.
What impresses us most are the user’s freedom of action and the flexibility. Effective integration with professional display options (via the SAP Analytics Cloud) and straight-forward access to existing data sources round the offer of.
The use of separate “Spaces” guarantees your independence. With “Spaces”, you can set up your prototype in minutes, keeping your own data model secure.. Using your data model, you will be able to illustrate your requirements clearly and in detail, providing a good starting point for expanding the central data model in BW/4HANA. For finalisation or integration in existing data models, it is easy to hand over the “Space” to the IT specialists.
The SAP Data Warehouse Cloud solution offers the visualisation functionalities familiar from the SAP Analytics Cloud. Among other things, it allows ad-hoc analyses to be visualised and linked to create so-called Stories, which makes it possible to show the user a pre-defined path through the analyses. There are plans to integrate the Application Builder for realising comprehensive analytical applications at some point in the future. During the transition phase, everybody can, of course, make use of the SAP Analytics Cloud. In the course of the continuous development of SAP Data Warehouse Cloud, one can expect to see virtually all the SAP Analytical Cloud features being made available in the SAP Data Warehouse Cloud solution.
Extraction and modeling
Unlike SAP Analytics Cloud, which focuses on reporting, SAP Data Warehouse Cloud includes tools for creating more complex data transformations and models.
To this end, the data from the source systems are first replicated and transformed via views created through visualization or via SQL before being integrated into ER models and published in the Business Catalog for further use.
Source system connection
The connection to on-premise systems is realised using a Data Provisioning Agent that needs to be installed within the internal corporate network; this makes it much easier to set up the connection as it does not usually require any changes to be made to the firewall. Once the connection has been established, all tables of the source system are immediately available for further use. The whitelisting of IP addresses enhances security further as it ensures that only authorised agents can access the relevant Data Warehouse Cloud tenant.