Skip to main content

Power BI

New

SAP Business Warehouse connector include SAP router string

Vote (69) Share
Jim's profile image

Jim on 29 Jan 2018 13:33:47

My organisation only allows connectivity to the SAP BW system (or any SAP system) using the SAP router string. It would be beneficial to allow this type of connectivity rather than just providing the application server.

Comments (12)
Jim's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:13:23

RE: SAP Business Warehouse connector include SAP router string

'Hi,

I did some research and it should be easy to add:
- Power BI does use the standard .NET connector from SAP (see https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector#installation-of-implementation-20-sap-connector)
- The documentation for this thing is at http://logosworld.com/docs/SAP/Connector/SAP%20Connector%20for%20Microsoft%20.NET%20%20NCo_30_ProgrammingGuide.pdf
- Page 41 of the documentation shows that this is just another attribute to the connection string

regards

Jim's profile image Profile Picture

1028457f 08bc-405c-8b97-d67400496320 on 06 Jul 2020 00:08:21

RE: SAP Business Warehouse connector include SAP router string

For many companies the missing SAP router string makes PowerBI a dead end

Jim's profile image Profile Picture

da50b72c a4cc-4f29-99d0-3993548436d5 on 06 Jul 2020 00:07:09

RE: SAP Business Warehouse connector include SAP router string

Waiting for it - love the front-end but if I can't access the data it's useless

Jim's profile image Profile Picture

7eaa19c3 a0cc-477b-aa8e-3df3658bc938 on 06 Jul 2020 00:00:06

RE: SAP Business Warehouse connector include SAP router string

Since 2016 and still today October 3rd 2019, it is impossible to connect Microsoft Power BI to SAP when SAP uses router string - like other software concurrents in 2014 !

Jim's profile image Profile Picture

afd9f607 de69-4700-8b01-f10e78d3f04d on 05 Jul 2020 23:46:51

RE: SAP Business Warehouse connector include SAP router string

This is a serious problem. This explicitly means that every organisation using SAP Router will not be able to connect their data with Power BI.

Jim's profile image Profile Picture

82dcf156 225a-41ab-a256-fbf6c217b21c on 05 Jul 2020 23:36:36

RE: SAP Business Warehouse connector include SAP router string

Hello,


Only to insist in the situation.

It's needed to provide a solution for not to decide another tool to acces SAP BW Data.

SAP Basis Admin in the cliente only allows conexions as /H/SAProuteAddres/S/portSAPRouteAddres/H/SapServerAddres .
I'm with Power Bi desktop 32 bits and SapConnector 3.0 following the instructions
https://docs.microsoft.com/es-es/power-bi/desktop-sap-bw-connector

Jim's profile image Profile Picture

5f6ff2c2 6ce1-4149-bdd5-67246af2a556 on 05 Jul 2020 23:32:55

RE: SAP Business Warehouse connector include SAP router string

Hello, please provide a solution, otherwise power bi is of no use to us.

Jim's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:31:40

RE: SAP Business Warehouse connector include SAP router string

this is an issue for many organizations. I hope Microsoft can provide an update soon.

Jim's profile image Profile Picture

2bf75b9d 5fe2-4ab0-8828-12bd3cfd4f8b on 05 Jul 2020 23:27:49

RE: SAP Business Warehouse connector include SAP router string

need connector to SAP.

Jim's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:25:00

RE: SAP Business Warehouse connector include SAP router string

this is a very important topic and quite a showstopper for large enterprise which only use only SAP router's to connect to any SAP BW,ERP or HANA systems. I hope Microsoft can provide us a quick update on this topic.