Virtual access in SAP Datasphere to Google BigQuery
- Data warehousing, Google Analytics
- Google BigQuery, sap
- 3 min reading time
Rindrit Bislimi
Google BigQuery is on everyone's lips and is an effective tool for organizing all data. Many companies already collect large amounts of data and have been sitting on a real "data treasure" for quite some time. This treasure should be easy to mine: however, overly complicated data management environments often lead to misunderstandings and inefficiencies, with the consequence that in the end only a fraction of the data-driven opportunities are actually exploited. Finance only sees the financial data; Sales only sees the sales data; the individual departments do not get a complete picture of the business.
The Datasphere in general
SAP Datasphere (formerly Data Warehouse Cloud, DWC) is a tool that can be used to meet this challenge: Business departments are able to connect, model and visualize data from different sources themselves. At the same time, security and Governance on "enterprise-grade" level, so that the solution can also be used as a central data management tool by the IT department.
And all this without incurring massive implementation costs: SAP Datasphere is a cloud SaaS product, it does not need to be installed: SAP takes care of updates and maintenance. The cloud allows you elasticity to efficiently allocate your computing resources and save money when needed. As your computing or storage needs change, the cloud can be quickly scaled up or down, or even suspended.
In conjunction with the SAP Analytics Cloud (SAC), which has been established on the market for some time, SAP Datasphere forms the analytical core of the "SAP HANA Cloud Services" product range. With the product in the SaaS model (Software as a Service) is an SAP HANA-based end-to-end solution for data warehousing that combines data management processes with Advanced analytics.
What are the connection options?
One of the most useful features of Datasphere is hidden in the fact that a variety of different interfaces are available for integrating data. The openness to non-SAP data sources is among other things by the interfaces to Amazon Athena, AdverityGoogle BigQueryMicrosoft SQL Server and Oracle. Moreover, this list of integration options is not exhaustive and is constantly being expanded. Soon Amazon Redshift will also be connected here. will soon be connected here.
Important questions on the topic of "BigQuery
Under the name BigQuery Google offers a cloud-based data warehouse solution for companies working in the field of BigData for example in use as a data lake can be used. In conjunction with the SAP Datasphere for example, analytical evaluations can be carried out between data from the BigQuery and data from the ERP system can be created and evaluated. It is also ms possible, z. B. to link additional data from the department via a local Excel.
In line with the current paradigm shift of companies from centralized data warehouse systems, which redundantly hold data in the principle of the "single point of truth", to a decentralized scalable analytical platform, the SAP Datasphere offers the possibility of virtual access. Any harmonization and business logic of the data can thus be done "on-the-fly" at runtime of the analysis based on different source systems. The otherwise accruing expenses for the creation and support of data transfer processes as well as the increased storage requirements for data persistence can be avoided. data persistence are thus eliminated.
SAP Datasphere has a modern and attractive user interface with strong similarities to the design of SAC. In the area of data warehousing, SAP Datasphere offers a solution appropriate for the 21st century and closes the former gap in the backend area of the BI cloud family.
- No installation
- Easy to use via the browser → no own server facilities
- Skalible per click
- Transparent Costsstructure
- Efficiencyprofit → Self-service much easier for the department
- Transformation of the data
- Calculated key figures
- Reporting via the integrated SAC
The specialists of the s-peers could in the past successfully introduced the Datasphere for customers and have the have thus over well-founded know-how and experience in this area.
- As-is analysis and recommendation
- Consulting in architecture and construction of system architectures
- Implementation
- Introduction of best practice concepts and standards
- Quality assurance
Video demonstration (English)
Watch a live demo of using Google BigQuery in conjunction with SAP Datasphere and SAP Analytics Cloud here.
Would you like to delve deeper into this topic? Then we are pleased to offer you the Datasphere and their connection possibilities at Google BigQuery to present personally. Just get in touch with us!
Published by:
Rindrit Bislimi
SAP Analytics consultant
Rindrit Bislimi
How did you like the article?
How helpful was this post?
Click on a star to rate!
Average rating 5 / 5.
Number of ratings: 1
No votes so far! Be the first person to rate this post!