IBM Db2 (AS/400) - Getting started in Peliqan

This article provides you an overview to connect IBM Db2 in Peliqan. Please contact support if you have any additional questions or remarks.

How to connect

Make sure to install the ibm_db Python pip module first in your Peliqan account. In Peliqan, go to Admin > Data apps > Custom pip modules. Search for ibm_db and click on “Apply & Restart”:

Installing ibm_db custom pip module in Peliqan

Next, implement a Data App (Python script) to read data from Db2 and e.g. write that data into tables in the data warehouse. Example:

import ibm_db

try:
    conn = ibm_db.connect(
        "DATABASE=SAMPLE;"
        "HOSTNAME=1.2.3.4;"
        "PORT=448;"
        "PROTOCOL=SOCKETS;"
        "UID=APLPELIQAN;"
        f"PWD={pq.get_secret('IBM Db2 Password')};",
    )

    st.success("Connected to IBM Dd2 successfully!")

    sql = "SELECT * FROM MYTABLE FETCH FIRST 10 ROWS ONLY"

    stmt = ibm_db.exec_immediate(conn, sql)

    rows = []

    result = ibm_db.fetch_assoc(stmt)
    while result:
        rows.append(result)
        result = ibm_db.fetch_assoc(stmt)

    st.write(rows)

    ibm_db.close(conn)

except Exception as e:
    st.error(f"Connection failed: {str(e)}")

​How to connect

How to connect