Skip to Content
Author's profile photo Former Member

HANA & Twitter integration using Java

For last couple of days I was trying to integrate social media with HANA,there are several ways to do the same,We can use Business Object Data Services , ABAP,Java, Python  etc…

As I am starter in BODS I have looked at other options ,Java was easy for me as I am not core ABAP er , ABAPer’s can try that using TWIBAP library for Twitter, ,ABAP integration.

I took Java path, as I had brush with java during my days,just rewinded the concepts, believe me you don’t need to be strong in Java ,you just need conceptual idea and there on you can got lot of help on java, as it is wide spread.Below are the steps I followed.

1. Download the Twitter4j  library from  below link.

2.Register an Application at Twitter Developers.

3.Create your oAuth Tokens.

4.Download Examples from below

in the below path you can find different examples you can use Stream API for better rate limits

for some things first you need to authenticate your App  created in step2 using oAuth.

in th streaming API .java files you need to add your code to send tweets to HANA directly using JDBC connection.I used to get the followers tweets into HANA using JDBC

There you are you can get your tweets in HANA.



Santosh Varada

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Santosh,

      excellent blog, we need more of this pushing the boundaries of mixing the latest business technologies with social media

      mix it all together and let's see what innovations come out !

      all the best,


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Andy

      Thanks for your comments, we are actually aiming at sentiment analyis using SAP HANA and BODS, BI 4.0 and there we can produce the result on IPAD or [any mobile device], the same can be achieved using several languages such as



      TWITTER or FACEBOOK->BODS->HANA->BI4.0->Mobile

      in all the scenarios BODS is used for text data processing.If you can add some ideas it would be more helpful


      Santosh Varada