Luca Liu

Posted on Jan 15, 2024 • Edited on Aug 6 • Originally published at blog.luca-liu.com

Saving Dataframes into Oracle Database with Python

#python #database #pandas #dataengineering

Using Python to Save a Dataframe into Oracle Database

You can use the pandas library in combination with the sqlalchemy and cx_Oracle libraries to save a dataframe to an Oracle database in Python.

import pandas as pd
from sqlalchemy import create_engine
import cx_Oracle

# Create an SQLAlchemy engine using the connection
engine = create_engine('oracle://username:password@hostname:port/service_name')

# Save the dataframe to the Oracle database and lowercase your_table_name 
df.to_sql('your_table_name', con=engine, if_exists='replace', index=False)

Replace 'username', 'password', 'hostname', 'port', and 'service_name' with your actual Oracle database credentials, connection details.

Please replace your_table_name with the actual lowercase name of the table in your Oracle database. Otherwise, you may encounter InvalidRequestError: Could not reflect: requested table(s) not available in Engine.

When you run this script, it will establish a connection to the Oracle database, create a sample dataframe, and then save the dataframe to the specified table in the Oracle database.