Oracle - Getting started in Peliqan - Peliqan documentation

In order to connect to an Oracle database in Peliqan, e.g. the database of a JDE instance (JD Edwards ERP), use a custom pipeline script. Example:

import oracledb

host = "my_host"
port = 1234
service_name = "mydb_name"
user = "my_user"
password = pq.get_secret("My Oracle DB password")

dsn = f"{host}:{port}/{service_name}"
conn = oracledb.connect(user=user, password=password, dsn=dsn, mode=oracledb.DEFAULT_AUTH)

# List all tables
query = """
SELECT owner, table_name
FROM all_tables
ORDER BY table_name;
"""

query = query.strip().strip(";")

cur = conn.cursor()
cur.execute(query)
data = cur.fetchall()
st.table(data)

cur.close()
conn.close()