HANA & Twitter integration using Java

[Former Member]

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.

Thanks

Santosh Varada