Data replication in HANA database
I need your sugessions in solutioning (I am new to HANA).
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?
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.