connect to ECC database on prem FROM Data Intelligence Cloud

[alexmoccia100]

Good morning,

I would like to know if there is a way to connect to the Ecc on prem database (in this case an oracle database) without using a drive, i.e. an oracle adapter (due to the customer's company policy), but using some connector like:

"data connector data services sap", RFC or otherwise.

Can you help me?

[ansharm71]

Hi Alessandro,

One of the option can be to connect oracle DB from DI Cloud is using a python library i.e. CX_ORACLE.

Need to create custom python operator and import CX_ORACLE library . Also, it provides inbuilt function to fetch records from database.

Thanks,

Ankit