Suppose you want to access two SAP Datasphere spaces using the same SQL user, how do you create such a user? That’s what we will go through in this blog post. As an example, we have two spaces as the below screenshot shows. We will create a SQL user that can access both of these […]
Our customer had a requirement to combine data from SharePoint files with other data in an SAP Analytics Cloud (SAC) dashboard. Since there is no native SharePoint connector for SAP Datasphere, we created a connection using SAP BTP’s open connector, which we then utilize from Datasphere. 1. Register an app for SharePoint API Access in […]
Introduction Welcome to this blog where I will provide an overview of the following key aspects in relation to creating an ODBC connection between Datasphere and PowerBI. Create a Database user in Datasphere To connect SAP Datasphere with PowerBI, the first step involves creating a dedicated database user in Datasphere. This user will serve as […]
Introduction In this blog post, we’ll guide you step-by-step through the process of provisioning a SAP Datasphere Free-Tier instance. Whether you’re a data enthusiast, a business analyst, or an IT professional, by following these steps, you’ll have your free-tier instance up and running in no time. Prerequisites To create your SAP Datasphere service instance in […]
Accurate currency conversion ensures that financial statements reflect true value, enabling better decision-making and compliance with regulatory requirements. Without effective currency conversion, businesses may face issues such as financial discrepancies, inaccurate forecasting, and challenges in performance evaluation across different regions. “Twenty-four-hour global nature of currency markets, exchange rates are constantly shifting from day to day […]
Introduction In SAP Datasphere we can “enhance” a data set using different development artifacts like data flow, transformation flow or SQL view (Query/Table Function). In this blog article, I’ll share my point of view and decision process for development artefact selection. Datasphere Technical Limitations/Design Considerations Let’s first cover the most important factor; persistent data tables […]
Datasphere, a comprehensive data management platform, offers a suite of tools and features to help organizations safeguard their data assets and ensure compliance with security regulations. In this blog post, I will demonstrate how to implement data access controls in Datasphere to enhance security and protect your valuable data. Understanding Data Access Controls Data access […]
Overview: In today’s data-centric business landscape, organizations are seeking comprehensive solutions that enable them to harness the power of their data. SAP Datasphere, an advanced data management and analytics platform, emerges as a game-changer in helping enterprises leverage their data for informed decision-making. In this blog, we will explore the key benefits of SAP Datasphere […]
In this Blog, We’ll explore how to consume data from SAP Datasphere through ODBC (Open Database Connectivity) and Visualize the data in Qlik Sense which is one of the leading Data Visualization Tools. Why SAP Datasphere over others? SAP Datasphere allows seamless connectivity with a wide range of data sources, including on-premises and cloud-based systems. […]
We can leverage the HANA cloud as source in Datasphere. Also HANA cloud in which Datasphere is hosted can be accessed for HDI developments. Pre-requisite I have enabled the free datasphere subscription as of now. Datasphere instance is running in space “dev” under subaccount “free” in Business Technology Platform (BTP) If you have subscribed for […]
