topic Re: How to write dataframe to Oracle from Databricks ? in Data Engineering

How to write dataframe to Oracle from Databricks ?

prasannar — Thu, 22 Dec 2022 06:08:36 GMT

Re: How to write dataframe to Oracle from Databricks ?

Rishabh-Pandey — Thu, 22 Dec 2022 06:40:08 GMT

sql = "select * from tablename"
 
user = ""
 
password = ""
 
server = ""
 
port = 
 
service_name = ''
 
jdbcUrl = f"jdbc:oracle:thin:@{server}:{port}:{service_name}"
 
jdbcDriver = "oracle.jdbc.driver.OracleDriver"
 
 
 
 
 
DF = spark.read.format("jdbc") \
 
 .option("url", jdbcUrl) \
 
 .option("query", sql) \
 
 .option("user", user) \
 
 .option("password", password) \
 
 .option("driver", jdbcDriver) \
 
 .load()
 
 
 
 
 
 
 
by this you can make a connection with your oracle database and read files from the database and same you can write the data to particular database .

Re: How to write dataframe to Oracle from Databricks ?

Ajay-Pandey — Thu, 22 Dec 2022 07:09:12 GMT

Hi @Prasanna Lakshmi you can use JDBC API to write the data.

Re: How to write dataframe to Oracle from Databricks ?

sher — Fri, 06 Jan 2023 05:52:29 GMT

Df.write.format('jdbc').options(
      url='jdbc:oracle:thin:@192.168.11.100:1521:ORCL',
      driver='oracle.jdbc.driver.OracleDriver',
      dbtable='testschema.test',
      user='testschema',
      password='password').mode('overwrite').save()

try this. refer link: https://dwgeek.com/load-spark-dataframe-to-oracle-table-example.html/