HANA in a side car scenario

[former_member207019]

Dear All,

We have ECC on oracle and as a side car scenario we have HANA as a secondary DB. In this scenario if I create transaction in ECC system, once after committing the record to DB then only it would be replicated to HANA DB via SLT. This is my understanding.

Here I would like to know about the performance in creating the transactions and reading the transactions in HANA as a secondary DB scenario.

Is it going to increase the performance in increasing in creating data in ECC system as well.

Or else it will be increased performance on reading data from HANA DB alone in side car approach.

Regards,

Jo

[Former Member]

Hi Jo,

Not sure about what you are processing when you say transaction in ECC , but as per my understanding in side car scenario, while the transaction writes data in its actual DB ( say Oracle ) would be as normal as how it was before and the triggers immediately replicate to HANA DB but the read operation from HANA DB will be faster than your Oracle DB ( especially the historical records )

Thanks

Siva

[former_member207019]

I would like to understand one point here -

Let us say we are using XXXX transaction in ECC System, we have HANA DB as a secondary DB in our scenario. Is it have any performance improvement while creating transaction in ECC system.

Does it involve secondary DB HANA Engine in ECC system while creating transaction in ECC on Oracle(which is primary) and improve the transaction performance as well.

According to me, when we use HANA as a secondary DB, it improves only read performance but not write performance by leveraging HANA Calculation Engines.

Please correct me if I am wrong.