Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to connect to an external Oracle database in CDSW python

Highlighted

How to connect to an external Oracle database in CDSW python

New Contributor

Hello,

Recently we have been given CDSW to use. We alraedy had some tables in a separate Oracle database. We would like to establish a connection in CDSW python and access/update those data in the Oracle table. I have installed cx_Oracle package, but getting following error while establishing connection:

DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help


I am using following syntax to connect 

 

con = cx_Oracle.connect('userid/password@host/schema')

 

Please help, it is urgently required. 

Don't have an account?
Coming from Hortonworks? Activate your account here