Skip to Content

For my review of the “native” connector look here:

http://scn.sap.com/community/developer-center/hana/blog/2012/10/29/tableau-on-hana-using-the-new-native-connector

Tableau on HANA

Over the last couple of weeks I’ve had several discussions on Tableau software. Not only amongst my BI colleagues, but also amongst my clients. I knew it was a frontend tool, but that was about it. I did not have an opinion on the user friendliness of Tableau nor on the way it connects to any SAP data sources. Luckily for me I have a knack to start fiddling around once I hear a number of people talking about a product. In my book, it must be worth investigating if there is a buzz.

Being a strong believer in the capabilities of HANA, I decided to combine the two and investigate the possibilities to use Tableau on top of HANA. I consulted the book of knowledge (Google) and entered “ tableau HANA”. To my surprise the following post shows up:

Got SAP BW? Get Tableau

Vishal Sikka (SAP’s CTO) demonstrated Tableau connecting to SAP Business Information Warehouse (SAP BW) running with HANA. That’s interesting. Why would Vishal promote a non-SAP product? Either he really likes the functionality or he wants to demonstrate the openness of the HANA solution to 3rd  party applications. Whatever the motif, as Vishal demoed “ BW running on HANA”, this gives me the perfect opportunity to investigate the possibilities (and possible limitations) off using the other option: HANA standalone (for example by using the Amazon HANA images).

It always starts with a download

I installed a trial version of “ Tableau Desktop” from the Tableau website and installed it. Flawless and simple, nothing to it. Next step is connecting it to HANA. As no native HANA connector is available at the moment (the folks over at Tableau will release this is in the next coming months as I understood), I decided to make a connection via ODBC as this had proven to be working beautifully in my Siri demo.

Creating a connection

After opening Tableau I pressed “connect to Data” and made a connection to HANA via ODBC:

Naamloos.png

Entered server and logon credentials (note the 32 bits driver (HDBODBC32) which is selected, be sure to install the 32 bits version of HANA Client and Studio):

Naamloos.png

After connecting I can select one or multiple tables. There is even the possibility to use SQL to make a sub-selection of a table (e.g. select only year 2011).

Naamloos.png

If you want to select a HANA view (like a calculation view) be sure to select the “_SYS_BIC” schema and not your default schema which holds your normal tables!:

Naamloos.png

Tableau automatically checks the compatibility of the ODBC driver for limitations. Connecting to the HANA driver It comes up with a bunch of warnings, which seem irrelevant for the most part.

Naamloos.png

I took take a chance here and ignored the warnings. I  wanted to see any limitations once I created some demo content on my “Sales” table.

After pressing ok, the next option is to create a “Tableau data extract”. That does not sound like a real time scenario, but fortunately Tableau still gives the option to connect  to a live data set. Exactly what I want, how will Tableau handle the big data volume (100 million+ records) I have in my table?

Naamloos.png

Press “Connect Live”. Good to go!:

Naamloos.png

Filtering is the key to success

The fun starts. I started off by just throwing in some dimensions and measures and let it all rip. Well, forget about trying that on 100.000.000+ records. The query will simply not give back any results. I did a test by putting my customers in the rows against a sales measure, it did not come back with any results (well actually it ran for some hours when I decided to kill it).

You will need to make smart selections when you want to use Tableau on HANA via ODBC. You cannot simply request all data in your HANA table and expect lighting fast response times. So I decided to use filters to create a smaller data set. This gives another limitation however…

If you want to filter values, you cannot do this by selecting values from a populated dropdown box in case you have a lot of different values for that particular dimension (think filter on month is not a problem, filter on 100.000 customers is a problem). It seems the query reads the full table again, which makes it impossible to come back with a list of values. The workaround for this is to switch off the auto refresh and setting a filter manually:

Naamloos.png

The good part is that after switching of the auto refresh, you can still do a live search for a value to set as a manual filter. In the below example I searched for customer Adobe which comes back in three different hits (note this is due to the way I stored my data):

Naamloos.png

Good part, It only takes seconds to do this going through my largedataset!

Creating some test reports


Tableau hosts a number of small tutorials, which explain the basics of filtering, connecting and formatting data. Go through them (takes about an hour) and you will be confident enough to create some reports.

Based on my limited set of dimensions and fields I threw together some reports in a couple of hours:

Naamloos.png

Sales data per customer and salesrep, plotted per month. By using the Analysis option I added totals on rows and columns. Graph is called a highlighted table, which emphasizes the larger values based on thresholds you can set or let the system determine by itself.

Naamloos.png

A bullet graph showing actual and target per salesrep for customer Adobe. A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. Table is sorted descending (just a simple click) and I added a “quick filter” on sales, which generated a slider. Simple and neat.

The added value, which comes with Tableau, is that you can take the individual sheets and create a dashboard. Combining my two sheets will look something like this after adding it to a dashboard sheet:

Naamloos.png

Again, performance is great when doing all of this. I did  not witness any lagginess whatsoever.


Conclusion

I can imagine that not being able to query the full dataset at once can be a serious limitation for some. You would have to know on what to report on in advance. This is where it gets misty. Is Tableau a tool to create dashboards and consume them easily or is it a tool to do a full analysis which can deep dive into information, not knowing what to query next once you found the answer to your initial query? Trying it out for some hours I believe it is more off a Dashboard tool then a full data analysis tool. For this reason I believe it can still be off added value when using it on top off HANA. As mentioned, once you set a correct filter on your dataset, the performance is excellent. The data comes back in seconds.

As for HANA, I believe she behaved beautifully today. The ODBC connector showed to be flexible and stable enough to easily attach a 3rd party tool like Tableau to it. It did not give a single error during my tests.

I’m looking forward to the future and the new Tableau HANA plugin. Apparently it will be released somewhere the next couple of months. I’ll be sure to try it out once it is available and see if the limitations are ironed out!

Thank you for reading this and take care.

Ronald.

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. Vittali Nav

    Hi Ronald,

       Thanks for this blog, you are right. I was looking for easy frontend to consume the HANA views for my thesis. I started using Excel Pivot but felt boring.. This tool is really easy to setup and I was able to get started will good templates for graphs..

    Kudos..

    Regards,

    (0) 
  2. FRANCOIS AJENSTAT

    Hi Ronald – the SAP HANA connector for Tableau has been released as part of the 7.0.9 maintenance release. You’ll have a better connection experience, functionality and performance with HANA.

    http://www.tableausoftware.com/about/blog/2012/10/tableau-709-chinese-korean-congressional-districts-and-sap-hana-19722

    Would be great to get your thoughts and feedback on it and how Tableau can drive visual analysis on top of HANA to more people.

    (0) 
      1. FRANCOIS AJENSTAT

        Hi Ronald – first of all, the native connector is optimized and tested for SAP HANA. So, we send optimized SQL and ensure that we take advantage of the HANA platform. With the generic ODBC connection, it’s just that – generic. So, you won’t see the error messages on connection. You’ll get better performance because we’ll send better SQL. etc.

        And since this is a live connection, Tableau only get the resultsets that you want for interactive analysis. You wouldn’t want to download 100M+ records since that would result in a useful analysis but you can access any of those records and HANA will deliver it very fast.

        Let me know if you have any questions or run into in issues. Tableau + SAP HANA is a great combination for fast, interactive analysis.

        (1) 
        1. Zeenat Goyal

          Hello Francois,

          This post was an old one and it’s been after 4 years I am writing here, hoping to get a reply.
          I am completely new to Tableau and got a chance to work on it with SAP HANA, I was looking for some stuff but of no use, found your post here,
          Could you help with some best practices followed in tableau on top SAP HANA.
          Any help in this regard would be appreciable.

          Thanks,

          (0) 
  3. Madireddy Rahul Reddy

    Hi Ronald,

    Can you please let me know what are the drivers that you need inorder to connect to SAP HANA DB using Tableau desktop? I already have the HANA Client 64bit installed on my laptop but i still get the below error. i am currently trying to install the 32 bit driver to see if that works. Can you help me out with this?

    Untitled.png

    thanks,

    Rahul.

    (0) 
  4. Kumar Mayuresh

    Rahul

    Try installing 32 Bit HANA Client and configure 32 Bit ODBC and then try to connect, probably it should work.

    PS: You can have both 32 and 64 Bit HANA client installed on your system, 32 bit HANA client is recommended for 32 bit application which is being used on 64 bit Operating system. Best scenario would be if possible use maximum application in 64 Bit.

    Regards

    Kumar. 🙂

    (0) 
  5. Michael Smahol

    Does anyone know if SAML SSO between Tableau and HANA is currently supported or have any information not found on the Tableau Forums?   Currently we are using service accounts which access the data in HANA but we would like to get away from that and pass in a named user.   We are attempting to use SAML and I’m wondering if that just becomes another Identify Provider in HANA?

    Any assistance would be greatly appreciated,

    Mike

    (0) 
    1. Lars Breddemann

      As this is about a Tableau-Feature (SAP HANA doesn’t have to “allow” clients to use SAML SSO) this question would be better placed in a Tableau forum.

      – Lars

      (0) 

Leave a Reply