Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
werner_daehn
Active Contributor

This post is part of an entire series

Hana Smart Data Integration - Overview

One of the more basic use cases is to copy data from a source database into Hana. Either just once to try out Hana or doing an initial load and setup realtime replication for all changes in order to have Hana side by side with the source system, e.g. for reporting.

Using the Smart Data Integration technology that can be done, you have to create virtual tables, write the SQL or dataflow for the initial load - one per source table - and create the realtime subscriptions. Or in short, use the Hana WebIDE to create a hdbreptask object that does all of that for you.

But let's do something different instead of replicating a source database into Hana this time. Just for fun, a database would work as well of course. We want to replicate the Twitter!

For that we need an Adapter to connect to Twitter - no problem, shipped together with the Agent - and create a remote source with the Twitter login credentials. Everything else is straight forward:

Open the hdbreptask editor in the WebIDE by creating a new file of that ending

Select the remote source, the target schema and all remote tables - well in Twitter there are just two but in reality you can add hundreds of tables at once

Optionally specify filters

Execute the task

Summary

Actually, there is a nice video of all of this

31 Comments