In this article, we will see how to integrate SAP data into Datazen.

Datazen Software is a mobile business intelligence and data visualization service and has been acquired by Microsoft in April 2015 to accelerate its Power BI strategy.

If you have Microsoft SQL Server 2008 or later Enterprise Edition and Software Assurance you are entitled to download the Datazen Server software at no additional cost.

As an SAP Connector I will use Xtract Universal to extract sales data from SAP BW using a query.
In Xtract Universal I will use the OData destination since Datazen supports OData datasources.


Step 1: Create the extraction in Xtract Universal

In Xtract Universal create an extraction based on a BW query and set the Destination to OData.

datazen-xu-1
Then click the Run button and copy the URL.

datazen-xu-2

Step 2: Create the Datasource on the Datazen Server

Log in to the Control Panel of the Datazen Server. Under Datasources create a new Data Connection.
Set a name and the Data Provider to OData Web Service. Then click Next.

datazen-server-02-new-dataconnection-01

In the second step set the access rights and click Finish.

Now click on New Dataview.
Set a name and paste the URL of the extraction into the field OData view URL and click Next.

datazen-server-03-new-dataview-01
Now you will see a preview of the data.

datazen-server-04-new-dataview-02
The SAP data are now available as an OData Datasource in Datazen.

datazen-server-05-dataview-overview

Step 3: Create your Dashboard with Datazen Publisher
Open your Datazen Publisher on a Windows 8 OS and set the Connection to the Datazen Server.

datazen-publisher-01-connection

In a dashboard click on Data View -> Add Data -> Datazen Server and select your dataview.

datazen-publisher-02-connection

datazen-publisher-03-connection

datazen-publisher-04-dataview
Now your SAP OData datasource is available and can be used in your dashboard.

datazen-publisher-05-preview

Now you can publish your dashboard to the Datazen server.

datazen-publisher-06-published-dashboards

datazen-publisher-07-published-dashboards-ie

Give it a try

With a few steps outlined in this blog, you can integrate SAP data in your Datazen Dashboards. It’s easy to get started, Theobald Software’s Xtract Universal is available for free for a trial period. For further info, check out:
http://theobald-software.com/en/xtract-universal-productinfo.html

Written by Khoder Elzein

Khoder is responsible for presales and always has an attentive ear for our customers, prospectives and partners. When travelling in Germany or abroad, he provides customer support at PoCs, workshops and on training courses. He also looks after the further development of our software solutions. Khoder has been working in IT since the turn of the millennium; he has been a member of team Theobald since 2009. When it comes to private interests, family, nature and reading feature at the top of his list – along with innovative fusion cuisine, as you may infer from his favourite dish of Swabian cheese noodles with tabouleh.