Today at the SAP Influencer Summit, Vishal Sikka (SAP’s CTO) demonstrated Tableau connecting to SAP® Business Information Warehouse (SAP BW) running with HANA. Vishal showed Tableau connecting directly to a BW system to analyze a large data set seamlessly. He analyzed over 28M rows of data with near instantaneous response times.

SAP is working with Tableau Software to bring real-time visualization to business information. SAP HANA powers exploratory and investigative analysis with no pre-built queries and materialized views at accelerated speed for businesses to have a conversation with their data.

This is exciting as it will help SAP customers have an unconstrained conversation with their data.

Here’s a quick demo of Tableau connected to SAP BW running on HANA.

But even without Hana, you’ll be able to use Tableau on top of BW. You will get the same functionality as you do when connecting Tableau to OLAP sources. Just connect and go.

The Tableau and SAP partnership will bring this new connection to market in the new year. If you are interested in finding out more details, please contact your Tableau account manager for information about the timing and possibility of participating in the Tableau-SAP BW beta program when it begins.

SAP® Business Information Warehouse (SAP BW) is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries.

Comentários

Does this mean connecting to a BusinessObjects Universe is in the future? That would help current SAP BusinessObjects customers "leverage" their legacy investments in Universes.

I'm able to paste the SQL directly from business objects into the SQL server connection with custom sql statement with a few modifications and it works great.

Hi Jason - we have no immediate plans to support a BusinessObjects Universe.

are u connecting to the infocube or to a bex query here?

Strongly agree with the request for connection to BO Universes, would be a complete game changer!!

This is wonderful to see progress. Will desktop be enabled to the BW Bex queries or only directly to the Infocubes? Both would be beneficial (of course).

From what I understand of Tableau's approach, this will work for both Infocubes and BEx queries.

what about consuming directly HANA views ?

That is correct, we will be able to support both Infocubes and BEx queries. In the video posted on the blog I was connected to a BEx query.

With regards to connecting directly to HANA, our goal is to support that as well. The 3rd-party APIs for HANA are not available yet.

Actually, HANA does have an OLE DB for OLAP interface which supports the MDX query language. We already use Microsoft Excel to connect directly to SAP HANA. So, in theory, Tableau should be able to connect directly to SAP HANA and issue MDX queries.

Will this native connector to BW be using OLE DB for OLAP (ODBO) interface or SAP's native BICS? Thanks!

it will connect through the OLE DB for OLAP (ODBO) layer.

What will be the impact on the performance of the BW system when connected without HANA ?

Jay - the performance will be as good (or as bad) as your BW system. Hana definitely makes things much, much faster. You can always deploy the NetWeaver Business Warehouse Accelerator to improve the BW system performance.

Will there be as well a direct connector to SAP ECC ?

Please let us know on the update of timelines for the release of connectivity with SAP BW

It will be in the next monthly maintenance release (7.0.4) coming mid-May.

Does it support BW 3.5?

Yes. With client version 720 and higher.

how are hierarchies dealt with ... ???

The SAP BW connector is now available for everyone. Please download the Tableau 7.0.4 release to get access to the connection. You can get more details on it here - http://www.tableausoftware.com/solutions/sap

Does Tableau flatten the Hierarchies in SAP InfoCube? If it does will it have any performance impact on accessing the data?

No. we do not flatten the hierachies. They are fully exposed and usable in Tableau.