Performance impact : Real-time data is read from HANA column store tables in Oracle 11g.

150 Views Last edit Oct 24, 2017 at 05:45 PM 8 rev

I have one scenario where i need to read data real-time in Oracle from SAP Hana tables and update oracle tables.

Using ODBC technique to read HANA data from oracle. There are huge difference in technology between these two. ODBC Data read from HANA to Oracle 11g will have huge performance impact due to deduplication and column store in HANA.