Oracle

Introduced in v6.0

The Oracle backend is experimental and is subject to backwards incompatible changes.

Install

Install ibis and dependencies for the Oracle backend:

pipcondamamba

pip install 'ibis-framework[oracle]'

conda install -c conda-forge ibis-oracle

mamba install -c conda-forge ibis-oracle

Connect

ibis.oracle.connect

con = ibis.oracle.connect(
    user="username",
    password="password",
    host="hostname",
    port=1521,
    database="database",
)

ibis.oracle.connect is a thin wrapper around ibis.backends.oracle.Backend.do_connect.

Connection Parameters

do_connect(*, user, password, host='localhost', port=1521, database='FREE', **_)

Create an Ibis client using the passed connection parameters.

Parameters:

Name	Type	Description	Default
user	str	Username	required
password	str	Password	required
host	str	Hostname	'localhost'
port	int	Port	1521
database	str | None	Database to connect to	'FREE'

ibis.connect URL format

In addition to ibis.oracle.connect, you can also connect to Oracle by passing a properly formatted Oracle connection URL to ibis.connect

con = ibis.connect(f"oracle://{user}:{password}@{host}:{port}/{database}")

---

Last update: June 2, 2023