How to connect to Netezza from Python?

@hailie 

To connect to Netezza from Python, you can use the nzpy library, which is a Python driver for Netezza.

To get started, you'll need to install the nzpy library by running the following command:

1

pip install nzpy

Once you have nzpy installed, you can connect to Netezza from Python using the following code:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

import nzpy

conn = nzpy.connect(
    host='hostname',
    port='5480',
    dbname='database_name',
    user='username',
    password='password'
)

cur = conn.cursor()
cur.execute("SELECT * FROM table_name")

for row in cur:
    print(row)

cur.close()
conn.close()

In the code above, replace hostname, database_name, username, and password with your Netezza database credentials. You'll also need to replace 5480 with the port number for your Netezza database.

Once you've established a connection to the database using nzpy, you can use SQL queries to retrieve data from the database and perform other operations.

@hailie 

Please note that Netezza has been discontinued by IBM and is now part of the IBM Integrated Analytics System (IIAS). For connecting to IIAS, you can use the ibm_db library instead of nzpy. Here is an updated example:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

import ibm_db

# Replace the connection details with your own
conn_str = "HOSTNAME=localhost;DATABASE=database_name;PORT=5480;PROTOCOL=TCPIP;UID=username;PWD=password;"

conn = ibm_db.connect(conn_str, "", "")
if conn:
    print("Connection established successfully.")

    sql = "SELECT * FROM table_name"

    stmt = ibm_db.exec_immediate(conn, sql)
    
    while ibm_db.fetch_row(stmt):
        row_data = ibm_db.result(stmt, 0) # Replace 0 with the column index you want to fetch
        print(row_data)
    
    ibm_db.close(conn)
else:
    print("Failed to connect to the database.")

Make sure to replace localhost, database_name, 5480, username, and password with the appropriate values for your IIAS installation.

Additionally, you will need to install the ibm_db library by running pip install ibm_db.