Skip to Content
Nov 21, 2018 at 10:09 AM

Realtime replication from Oracle to SAP HANA, Required roles workaround



We would like to replicate in realtime data from Oracle to SAP HANA.

We are using SDI and OracleLogAdapter in our DEV environment and it works fine.

Unfortunnately we can not use it on PROD because it requires too much critical privilege in Oracle Database like:

Alter Any Table and SELECT on SYS.Users (In this table, we can get Password for all users).

Is there any workaround or any others tools or any solutions to replicate data in real time from oracle to HANA ?

Best regards