HANA data storage

[Former Member]

Hi,

We have a situation where we can't use SLT to load data from non sap DB into HANA. We are looking into SDA option which is real time reading the data. I heard in SP9, we have SDI which can be used to persist SDA data in HANA physical tables! Can you throw some light into it!

Thnx.

[lbreddemann]

You may want to check the documentation on the SAP HANA options Enterprise Information Management and Real-Time Replication :

SAP HANA Enterprise Information Management – SAP Help Portal Page

SAP HANA Real-Time Replication – SAP Help Portal Page

- Lars

[Former Member]

Thank you Lars.

I read few documents and watched few videos on SDI and below is my understanding:

1. SDI is another ETL tool.

2. It uses remote sources (SDA) to read data from different sources (Oracle, SQL, HADOOP, HANA.....).and a SQL procedure gets generated for each data load. Once the data is read using remote source, using SDI transformations data can be loaded into a physical table. In previous versions where SDI was not there, data can only be read virtually using SDA concept. SDI is smart enough to do initial load for the first time and delta's there after. So effective performance booster for remote data reads.

3. Different Transformations can be applied to the incoming data using SDI tool and store the data in a table.

4. With SDI, we dont really need SLT and BODS anymore. SDI combines real time capability of SLT and transformations capability of BODS into 1.

5. Can create JAVA Adapters for different source system connections.

Let me know if im wrong in any!

[lbreddemann]

To be clear up front here: I'm not the expert on these data integration technologies.

So, if you find your statements confirmed by checking the documentation, that's as much as I can do here

Just concerning point 4:

In my view, you can avoid using additional integration servers (SLT, BODS, ...) as long as the scenario really is the rather simple "get data from external sources into my single HANA instance".

The stand-alone versions of the tools are all capable to support way more complex scenarios and will have their rectification for requiring their own servers in those.

But with all the available data integration options for SAP HANA (with SPS10 there's even another one - RDSync - available ) a huge number of servers can be be retired or put to better use as those options are now integrated with SAP HANA.

- Lars

[Former Member]

Any help is appreciated!