Skip to Content
avatar image
Former Member

Smart Data Integration - Oracle Log reader adapter ?

Hello Experts,

I m very keen to use smart data integration for Oracle db in Real time.

I know we have to use Oracle log reader adapter .

We have installed data provisioning agent on windows .And have registered the adapter.

But in guide i m getting confused.

Should Data provisioning Agent and Oracle db should be on same server ?

Does Log reader requires some different steps for configuartion with SAP HANA?

Please if somebody have an experience for it. Please do help.

Thanks

Yashi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 23, 2016 at 09:39 AM

    First you need to differentiate if you want to use the adapter for simple reading/loading (The Smart Data Access use case) or for realtime. If it is the first part only, then the location of the adapter does not match much as all it does is opening a connection to Oracle using the Oracle JDBC driver and translating SQL from the Hana syntax into Oracle syntax.

    For realtime it is a bit more work as you need to make sure the adapter has access to the transaction log information in the Oracle dictionary.

    Yes, you can install the Adapter on a different server, as long as it is of the same kind, Unix versus Windows.

    Explained in the PAM and in help.sap.com

    Installing Data Provisioning Agent and Oracle Server on Different Servers - SAP HANA Enterprise Information Management A…

    Add comment
    10|10000 characters needed characters exceeded