I was recently asked by a client’s marketing department to figure out how to bring Twitter data to their reporting environment. They are currently using a BW-on-HANA, so I immediately thought of HANA Smart Data Integration (SDI) as a possible candidate. In this blog I’ll cover the basics for the setup and show you that it’s actually quite easy to get up-and-running with SDI. In fact: I was pulling data from Twitter less than 3 hours after starting this SDI adventure 😊.
This is part 1 of the series. Herein, we’ll cover the SDI Setup.
(Check out part 2 to see how you can create dataflows within SDI)
|FYI: I’m going to assume that you have the necessary rights on your HANA box to perform all described steps. For more info on the needed privileges, check out section 2.1 of the official SAP HANA EIM Administration Guide.|
First, let’s take a look at the basic architecture behind SDI. There are 2 main parts:
The DP Server comes pre-installed with HANA, but you still need to ‘enable’ the service.
FYI: The DP Agent is not always needed.
There are quite a lot of sources covered by
the DP Server already. Here’s the list from
For our Twitter example we do need the DP Agent, so let’s look at the installation & setup:
|FYI: For testing purposes it’s perfectly fine to install the agent on your own laptop. As long as you leave your laptop on and connected to the same network as your HANA box, it will work. Later on, when you want to use SDI productively, you’ll have to setup a dedicated machine for the agent.|
You can get the agent from the SAP Software Center at https://launchpad.support.sap.com/#/softwarecenter
FYI: The 1st time you have to do it with Administrator privileges. Later on, you only need to open it as admin when you want to stop/start the service
The configuration exists of 3 steps:
That’s it! You’re completely done with the SDI setup. 😊
Check out part 2 to see how you can create dataflows within SDI…
As a consultant I’m responsible for the Analytics environment for an Innovative Company in Natural Chemistry and innovative in their IT. Recently I was forced to ponder on the post-Lumira question “ Now what ? ”.
Read more >
I recently finished a project for which I had to fetch public data of parking lots and load it to a multiprovider to use it in reporting. The data that I needed to fetch was from an open data API. After successfully finishing this project I thought I would share how I did this as an easy guide for others.Read more >
If there is one thing common in everyone’s career than it is that at some point everyone said: “Can’t this be automated or made simple?”. On a given moment at my customer I was asked to do a data-compare of two data providers with over 50 characteristics each and containing millions of records in SAP HANA. At first I started to run queries against the SAP HANA-tables to check the data but soon enough I thought…Read more >