Cannot connect to SAP BW from Tableau

[Former Member]

Hi

I am trying to connect to SAP BW (version 7.4) system from Tableau (version 9.2) and I am unable to do so as it is asking to download the driver.

I have tried searching for the drivers in SAP Market Place and I could not find any.

Has anyone tried connecting SAP BW system to Tableau or has downloaded the driver, please help me you.

Thank you in advance.

Arun.

[Former Member · Accepted solution]

Hi All

ODBO 64 Bit divers are installed and I was able to connect to the SAP BW system from Tableau. Though it is mentioned that 'OLE DB for OLAP provider' is a part of SAP GUI installation, that itself is not enough.

We need to install this ODBO drivers separately to fix this issue and that is how I fixed it.

Thank you all for your assistance and comments.

Arun.

[Former Member]

Hi Arun,

I have Tableau Desktop 9.3 version , SAP GUI 7.4 and SAP BW 7.4 SP 07.

Can you please tell me which driver from the below image I need to install for Tableau and BW Connectivity .

I can not see any drivers for SAP BW 7.4 and SP 07.

The drivers available in sap market place are for SAP BW 7.3.

Kindly guide me to proceed with respect to correct driver required for SAP BW 7.4 SP 07 and Tableau 9.3 and SAP GUI 7.4.

Also please tell me Is it dependent on SAP GUI version also ?

Thanks & Regards,

Shruti Yendigeri

[Former Member]

Hi

You need to install BWODBO64SP00_0-20007320 for you to connect Tableau with SAP BW. This self extractor file should be enough.

Yes for us to connect with the SAP BW or ECC systems with other reporting tools, SAP GUI needs to be installed. And for your scenario SAP GUI 7.4 should be fine.

Lemme know if there are any questions.

- Arun

[Former Member]

Hi

Thanks for your help. Yes, I have tried and it worked out.

Thanks & Regards,

Shruti Yendigeri

[former_member182373]

Arun,

when you get the error message in Tableau "download and install drivers "   click on it,

goto "Business warehouse"  and click on  "connecting to SAP BW" .

This link-to the  tableau help - clearly states the required ODBO Files.

Thanks

Tony

[Former Member]

Hi Tony

Yes, I have gone through the link and I have already installed the drivers for OLE DB for OLAP Provider. The SAP GUI is working fine.

I guess there must be some issue with the drivers installed, lemme try uninstalling them and install again..

Arun

[Former Member]

Did you check the IP address in drivers of your local system for BW system?.

--Subbu

[Former Member]

What link the download drivers hyperlink ( in the error screen) is navigating to?Can you paste it here?

--- Subbu

[Former Member]

Drivers & Activation | Tableau Software

[Former Member]

Do you have admin rights to the local system? try running the application with run as administrator and check.Ping to bw server is working fine?

[Former Member]

Arun,

Is This issue is resolved?What was the fix?

--Subbu

[Former Member]

Hi Subbarao

Yes, I do have the administrator rights and I tried running the application 'as administrator'

The ping is working fine too.

Arun

[Former Member]

Hi Subbarao

Yes, I do have the administrator rights and I tried running the application 'as administrator'

The ping is working fine too.

Arun

[former_member182373]

Arun,

As Henry said,you will need  an S Account to get the files.

Thanks

Tony

[Former Member]

Hi Tony, Henry

I have the S Account, lemme search for the "SAP GUI FOR WINDOWS"

Arun

[Former Member]

Hi All

I have installed the SAP GUI 7.4, through which I am accessing the BW system. But when I try to connect Tableau with the  SAP BW sever the same error occurs.

Arun

[former_member182373]

To be more specific -you need the ODBO Driver from the marketplace.

I am using BW7.4 With Tableau 9.3 (64 bit) .it works ok.

Tony

[Former Member]

Hi Tony

From where did you got the ODBO driver. can you please post the link here, so that I can download the drivers for me to connect Tableau with SAP BW.

Arun

[Henry_Banks]

Hi,

If you want the full GUI then go to  https://support.sap.com/software/installations.html 

.. and search for "SAP GUI FOR WINDOWS"

Otherwise try Note 1496637  (get the note from http://support.sap.com/notes )

Both links are a gated service which requires an S-user .   please don't ask for us to attach the files here or send by email

thank you

regards

H

[former_member182373]

HI,

it seems that you need the OLE DB driver that's part of SAPGUI Install ,hence the Marketplace link.

Thanks

Tony

[denis_konovalov]

a. shouldn't you be asking this on tableu forums ?
     you're connecting non-sap app to SAP, its that vendor responcibility to provide materials to do that.

[Former Member]

Hi Denis

I did tried checking in Tableau Forums and the links given were to download the drivers from SAP Marketplace. I have searched for the drivers in the Marketplace, but could not find any.

Has anyone downloaded the drivers from SAP Marketplace before ?

Arun

[Henry_Banks]

https://wiki.scn.sap.com/wiki/display/EIM/Reading+SAP+BW

I agree with Denis

Unless you can be more specific about which drivers you need from SAP .. then sorry

By the way, I suspect it's the OpenHub service you need .  Some info in the link i provided 

Regards,
H