Business Objects Universe Connector for Tableau
January 8, 2016
, , , , ,

Screen Shot 2016-07-25 at 15.57.37 Analysts in an enterprise environment usually have to deal with data from a multitude of sources. One of the most prevalent is SAP BusinessObjects and while it does provide enterprise level capabilities to IT it might not provide all the capabilities analysts require.  The analyst wishing to leverage the powerful visualization and storytelling capabilities of Tableau in these companies had to go through the tedious process of requesting extracts from the IT/BI department. This can now be mitigated with an SAP Business Objects – Tableau Connector. By using SAP’s own BusinessObjects SDK we can access BO Universes and pass the structure through a gateway into a format that Tableau can reuse. It allows everyone to design new workbooks based on new universe queries without the need of WebI reports or Query-as-a-WebService endpoints.

For free and open source. 

Connector's architecture

Connector’s architecture

The WDC connection essentially generates a user interface that is familiar from SAP BO so the learning phase should be instantaneous – from here the basis of any number of analyses can be generated and further refined in Tableau.

User interface of WDC

Our Web Data Connector’s User Interface is similar as in Business Objects

Minimum requirements

Minimum requirements for the components of the Palette Software’s SAP Business Objects – Tableau Connector:

  • SAP BusinessObjects Universe extraction module:
    • A Windows machine that has SAP BO XI 4.1 Client Tools and has the SemanticLayer SDK from the Developer options installed.
    • JDK 1.7 installed on the same machine (the SAP BO SDK is only compatible with this version
  • Tableau WDC translation proxy
    • A Unix/Linux or Windows with Node.js installed for the WDC translation proxy (can be the same as the SAP BO Universe translation machine) and internet access to download the necessary dependencies

Getting Started

These are steps from download to use it on server side:

1. Download and configure the extraction module:

2. Download and configure the Tableau WDC translation proxy:

3. Extract the required universes’ metadata and move them to the WDC proxy location. This process will extract the universe metadata like measures, dimensions and details from the repository and store it as a JSON file. For more help check out this help file.

Extract universe4. Start the WDC proxy and connect it to using Tableau Desktop’s Web Data Connector option. This will manage CORS proxying along with the business logic.

Our connector is up and running

Our connector is up and running

5. Select Dimensions and Measures in the interface familiar from BusinessObjects:

A familiar interface for all BO users

A familiar interface for all BO users

6. Create an extract and publish the Data Source to Tableau Server

Create extract from the data source (default)

Create extract from the data source (default)

Publish the data source to Tableau Server. It will stay refreshable from the Server as well

Publish the data source to Tableau Server. It will stay refreshable from the Server as well

The data source is ready to use

The data source is ready to use

7. Use the new Data Source to create reports and publish them to Tableau Server:

We can schedule the data source's extract to have the latest data from the Universe Query

We can schedule the data source’s extract to have the latest data from the Universe Query

Other connectors

I have an another, more lightweight connector for BusinessObjects Web Intelligence (WEBI) reports or QaaWS (query as a web service) queries. You can read more about that here.


Using legacy BI tools like IBM Cognos or SAP BusinessObjects from Tableau helps a lot. Eliminating the need to manage the semantic layer two different places not just make the server more manageable and secure but also reduces the cost of maintenance. If you have questions or wanna ask help for try this out in your environment just drop a mail or leave a comment!


Tamás Földi

Tamás Földi

Director of IT Development at Starschema
Decades of experience with data processing and state of the art programming. From nuclear bomb explosion simulation to distributed file systems. ethical hacking, real time stream processing practically I always had a great fun with those geeky ones and zeros.
Tamás Földi
  • Paul Sitch

    Hi, I’ve followed the steps to extract the metadata, install all of the pre-requisites, environment variables and configuring the xml. And when I try and run BOMetadataExtraction.bat, it produces the following in the command prompt before closing with an error that I can’t read in time.
    I’ve also taken a screenshot of the results of running mvn-v

    • These warning messages are normal. Can you try to run the command from a cmd.exe to see the actual error messages?

      • MrPaul

        Hi Tamas, thanks for getting back to me.
        I’ve run in cmd.exe and attach is a screenshot of the errors.

        • It says that you cannot download the plugin from the maven repository as the computer is not on the internet – or at least it requires proxy configuration

          can you make sure that this server can see the internet directly?

          • MrPaul

            I’ve found that it gets a bit further if I specify the version number in the POM.xml for maven-shade-plugin with version 3.1.0.
            It then attempts to download the following:
            maven-metadata.xml (one from codehaus and one from apache)
            It does seem to be downloading these as I can see them in the .m2 repository, but with each download is the warning ‘Failed to retrieve the plugin descriptor for or one of its dependencies could not be resolved: Failed to read artefact descriptor.
            After about an hour it then fails with the following messages:

  • Rafael

    Hi Tamás, is this still working? Do you have any commercial product to recommend?

    • Yes, we do have a commercial product. Can you drop me an email to tfoldi @ starschema dotcom

Related items

/ You may check this items as well

Scaling Tableau Image

Scaling out Tableau Extracts – Building a distributed, multi-node MPP Hyper Cluster

Analysts in an enterprise environment usually have...

Read more
Pasted image at 2018_01_09 04_59 PM

Python Experiments in Tableau 1. – Add live currency conversion to Tableau Dashboards using TabPy

Analysts in an enterprise environment usually have...

Read more
Tableau Docker

HOWTO: Tableau Server Linux in Docker Container

Analysts in an enterprise environment usually have...

Read more