Smart Data Integration - Oracle Log reader adapter ?

[Former Member]

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

[werner_daehn]

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 Info...

[Former Member]

Hi Werner Daehn,

Could you please point me to some useful links/step by step implementation examples for using oracle log reader adapter. We are planning to read tables from on premise database and load it to hana db on HCP.

Many Thanks for your time and help.

Shankar

[werner_daehn]

You will face two separate topics.

First, install the DPAgent near your Oracle database and configure it to be accessible from HCP:

HCP

HCP trial:

Second is to deploy the Oracle adapter and make your database ready. Deployment of the OracleLogReaderAdapter is straight forward, the requirements for the database are described in help.sap.com Oracle Log Reader - Administration Guide for SAP HANA Smart Data Integration and SAP HANA Smart Data...

Typical traps are

a) forgot to copy the Oracle jdbc driver - it is not included in the adapter due to legal reasons

b) check the Product Availability Matrix if your Oracle database meets the requirements

[Former Member]

Thanks a lot for the quick and helpful response!

With Best Regards,

Naveen