Skip to Content

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.

http://twitter4j.org/en/index.html

2.Register an Application at Twitter Developers.

https://dev.twitter.com/

3.Create your oAuth Tokens.

4.Download Examples from below

https://github.com/yusuke/twitter4j/tree/master/twitter4j-examples

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

https://github.com/yusuke/twitter4j/tree/master/twitter4j-examples/src/main/java/twitter4j/examples

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 userStream.java to get the followers tweets into HANA using JDBC

There you are you can get your tweets in HANA.

TWEETS_IN_HANA.jpg

Thanks

Santosh Varada

To report this post you need to login first.

2 Comments

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

  1. 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,

    Andy.

    (0) 
    1. varada santosh 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->ABAP->BODS->HANA->BI4.0->Mobile

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

      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

      Thanks

      Santosh Varada

      (0) 

Leave a Reply