Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data replication in HANA database

Hi Gurus,

I need your sugessions in solutioning (I am new to HANA).

Environment:

ECC6 EHP6

HANA Ver. 1.00.74

SLT Ver. DMIS 2011 SP5

BOBJ 4.1 SP4

Client has HANA installed as a stand alone database means (ECC is not on HANA and they dont have BW)

I need to replicate ECC data in HANA and create models to support reporting.

Question1: What is the best approach to replicate data in HANA (SLT, DS etc?)

Question2: Another requirement is write data back to HANA database. Users would like to enter new data (numeric data/key figure/measure) from a report to HANA. How can we achive this?

Thanks.

Former Member
Former Member replied

Hi,


Another approach would be writing directly back to HANA leveraging SAP HANA XS.


- Create XS application to read from a form/CSV via JDBC or ODBC interface.

- You can create a small .NET application leveraging ADO.NET feature (available as of SPS08) which can directly talk to HANA and update HANA tables

Both the approaches works very well and faster approach compared to BOBJ reports.

Regards,

Sadanand

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question