HANA

system · January 24, 2012, 9:34am

would i be right in saying that DI will be the normal approach to loading HANA?

johnwxyz (BOB member since 2008-01-26)

system · January 24, 2012, 9:57am

Data Services, although, I will be surprised if they do not expand to include other ETL tools, providing they are performant.

Mak 1 (BOB member since 2005-01-06)

system · January 27, 2012, 9:26am

Difficult topic.
Can DataServices load Hana? Of course. We have done a lot in DS and with the Hana team to outperform everything.
Is DataServices used a lot with Hana? Absolutely. Usually for initial load as it is exceptionally fast loading data with DS into Hana.

But what is the other unique advantage of DS? Its rich transformations. But with Hana you have the tendency to keep the source data model and do all the transformations repetitively at query time. That might not be the best thing for a real BI Data Warehouse but for operational reports it might be good enough and has other advantages. So the transformation is a 1:1 copy only.

The other thing is, Hana talks about realtime a lot, so often realtime replication of source data into Hana is required, something DS does not support for 1000s of tables.

Werner Daehn (BOB member since 2004-12-17)

system · January 27, 2012, 9:31am

Hi Werner :),

Thanks for the write up, it must be very interesting working with it.
Can you confirm that other ETL tools can be used?
How about Ab Initio?

Best Regards,

Mark.

Mak 1 (BOB member since 2005-01-06)

system · January 27, 2012, 2:05pm

The driver is ODBC but it is not available for public for now.
But in order to get optimal performance you need to use a few special commands and syntax, e.g. when creating a table you specify
create column table
not
create table.

Things like that. Also we pushdown a lot for performance reasons, e.g. insert the data into a temp table and then let Hana do the update on the target.

My point is, it is more than a: Yes, via the ODBC driver you can connect to Hana.

Werner Daehn (BOB member since 2004-12-17)

system · January 27, 2012, 4:50pm

Wow HANA sounds quite impressive…How far have we proven HANA by the way!!!
I think it would be good if we have some topics in Werner’s Wiki

ganeshxp (BOB member since 2008-07-17)

system · January 27, 2012, 6:26pm

There are a couple of customers already using HANA in production

Andreas (BOB member since 2002-06-20)

system · February 19, 2012, 2:17pm

The other thing is, Hana talks about realtime a lot, so often realtime replication of source data into Hana is required, something DS does not support for 1000s of tables.

–any plan to improve DS in this area or will SAP just leave the loading of its new toy to its competitors?

johnwxyz (BOB member since 2008-01-26)

system · June 18, 2012, 2:48pm

Hi Werner,

Can you please point me good resource to exactly understand how I can connect to BW HANA instance via DS, 1. to pull/read 2. Load data from/to BW HANA?

I installed the HANA ODBC driver and able to connect to HANA database to read data from some tables. Is that the right approach?
Because EIM wiki mentioned approach where it refers to use “SAP Application” to set up DS DataSource for BW HANA.
Not sure what’s the right approach. When’s significance of each approach?

BTW: I am using DS 4.0 SP2 (14.0.2.376).

Thanks,
Abhay

amhatre (BOB member since 2012-02-07)