How to use Oracle Wallet to connect from databricks

RKNutalapati — Fri, 15 Dec 2023 17:53:27 GMT

How to onnect Databricks to Oracle DAS / Autonomous Database using a cloud wallet, What are the typical steps and best practices to follow. Appreciate an example code snippet for connecting to the above data source

Re: How to use Oracle Wallet to connect from databricks

heeiow — Mon, 29 Jan 2024 21:32:11 GMT

Any update?

Re: How to use Oracle Wallet to connect from databricks

RKNutalapati — Tue, 30 Jan 2024 02:10:30 GMT

Followed below steps to build the connection.

Unzip Oracle Wallet objects and copy them to a secure location accessible by your Databricks workspace.
Collaborate with your Network team and Oracle Autonomous Instance Admins to open firewalls between your workspace to connect and retreive data..
Install Python oracledb library. (2. Installing python-oracledb — python-oracledb 2.0.1 documentation)
Code Snippet

import oracledb con = oracledb.connect(user='<YOUR USER_NAME>', password='<YOUR PASSWORD>', dsn='<Network Service Name>', #Refer tnsnames.ora config_dir='<WALLET FOLDER PATH>', wallet_location="<WALLET FOLDER PATH>" wallet_password="<PASSWORD>" ) # Create a cursor cursor = con.cursor() # Execute a query query = 'SELECT * FROM <Schema>.<TableName>' cursor.execute(query) # Fetch results results = cursor.fetchall() for row in results: print(row) # Close cursor and connection cursor.close() con.close()

Other references:

https://blogs.oracle.com/opal/post/easy-way-to-connect-python-applications-to-oracle-autonomous-databases

https://medium.com/@laurent.leturgez/how-to-bring-your-oracle-autonomous-database-data-into-the-lakehouse-427d01183300

Re: How to use Oracle Wallet to connect from databricks

heeiow — Tue, 30 Jan 2024 02:29:56 GMT

Did you try any way using spark?

For example:

spark.read \
.format("jdbc") \
.option("url", url_file) \

topic Re: How to use Oracle Wallet to connect from databricks in Data Engineering

How to use Oracle Wallet to connect from databricks

Re: How to use Oracle Wallet to connect from databricks

Re: How to use Oracle Wallet to connect from databricks

Re: How to use Oracle Wallet to connect from databricks