Skip to Content
0

Is Microsoft Power BI authorized to be used by sap?

Dec 12, 2017 at 01:54 PM

92

avatar image

Hello Experts;

We're planning to use Microsoft Power BI to be integrated with SAP Business One (SQL Server Database) as Analytic Tool, you know that we'll get the required query and use it inside of MS Power BI, but we do want to know if what we’re planning to do is legal, does SAP authorize using this third-party tool with its technology - for its side, does integrate this tool with database affects (SAP and its SQL Database) performance to be slower or functioning improperly?

Thanks in advance.

Kenan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Jimmy Liang 3 days ago
0

Hi Kenan,

From the software vendor's perspective, the database should be dedicated to their own application. I don't recall exactly, but I think, on the End User License Agreement (EULA) when you login to the system, there are terms and conditions about the usage of the database. Basically, it's to protect the software vendor if the application is not working as it suppose to be due to modifications at the database level.

From the customer's perspective, on the other hand, we would need to retrieve data from the database for different scenarios, purposes or reasons. Power BI is a respectively new tool, I've seen people using Excel, SQL Reporting Services or other tools to run reports against the SQL database. Technically speaking, we are just reading data but not updating/deleting anything in the database.

Luis has suggested some good approaches to prevent users from modifying the database directly. Businesses may also do backup for the database daily just to prevent things happening unexpected.

In terms of performance, it depends on many factors, your hardware resources, number of users/connections, the report logic,data set size and etc. Power BI provides cloud storage and the cloud version. If your analysis work doesn't require real time data, you may try to schedule a data refresh and publish outside the business hours. So ERP users will continue to work on the system, and data analysts can work on the published data set.

Cheers,

Jimmy

Share
10 |10000 characters needed characters left characters exceeded
Luis Darui
5 days ago
0

I don't think it is ever required to have an SAP authorization. The only problem is: 3rd party programs will access your database directly and might cause issues to your system. You have to be certain that they will not modify or even cause performance issues on your system.

You also might want to restrict the access to external tools and users, so you probably want to create views over the tables you want to use. This will prevent direct access to the database and tables.

Share
10 |10000 characters needed characters left characters exceeded
KENAN JADDENY yesterday
0

Hi everyone!, kindly find below what I've got about this issue.

We’re using Microsoft Power BI (Business Intelligence) as a professional Analytic Tool, we connect it directly to the SQL Database through specific required queries we want, regarding we’re using SAP Business One with SQL Server not HANA (currently), but we do want to know if what we’re doing is LEGAL, does SAP authorize using this third-party tool with its technology??, does integrate this tool with database affects (SAP Business One – SQL Database) performance to be slower or functioning improperly?

First of all, is there any partnership between SAP and Microsoft?

Microsoft and SAP Join Forces to Give Customers a Trusted Path to Digital Transformation in the Cloud

From the beginning of the start, Microsoft and SAP has always worked together in amazing way, their cooperation appears in;

  • SAP Business One (SQL Server) > Microsoft SQL Server
  • SAP Business One (HANA Server) > Microsoft Azure. Here!
  • SAP Business Objects > Microsoft Excel, Microsoft Power Query, Microsoft Pivot Tables
  • SAP Business Objects > Microsoft Power BI. Here!
  • SAP Business ByDesign > Microsoft Power BI. Here!
  • SAP Business Warehouse System > Microsoft Power BI. Here!

For more information; SAP-Microsoft Partnership
and kindly find attached the Microsoft BI-SAP white paper.
also you may find attached the complete presentation from Microsoft side about connecting with SAP.

matter where your data lives or what form it’s in, you get a holistic view of the key metrics for your business.


Hope this was helpful.

many thanks!

Share
10 |10000 characters needed characters left characters exceeded
M. Sundararaja Perumal yesterday
0

Power BI works with Sql server. I have tried out till 2014 version

I believe there is revision in usage of CALS license from Sql -2016 version.

You can either use SSAS or write query to extract data into power bi.

If you’ve use query method, then it does have impact on sql performance. So I suggest you use sql query-import method and don’t use direct query method.

There is option to schedule data refresh from the Power BI Gateway for both on premis and cloud- using azure..

If you are going with on- premis, Use Power BI gateway(instead of personal power bi gateway) for data refresh scheduling.

Keep the query simple, create the logic’s and data slicing using the Dax functions as this will reduce the load on sql server.

Power BI has been releasing new feature every month. If you are familiar with R Script you can further customize visualizations.

Hope the above info helps you.

Share
10 |10000 characters needed characters left characters exceeded