How to connect to Netezza database from Python?

Question

Using python, how to connect to netezza database.

Since PIP install is not working in my corporate network. I can't import pyodbc and jaydebeapi. Please suggest is there any way to connect netezza database and fetch data from table.

Pero · Accepted Answer · 2021-07-27 11:50:14Z

2

Install nzpy https://pypi.org/project/nzpy/
Install pandas https://pypi.org/project/pandas/

Use connection to Netezza to fill pandas' DataFrame using read_sql function

import nzpy
import pandas as pd

conn = nzpy.connect(user="admin", password="password", host='localhost', port=5480, database="db1", securityLevel=1, logLevel=0)
df = pd.read_sql('SELECT * FROM some_table', conn)

Voila.

answered Jul 27, 2021 at 11:50

Pero

1,45118 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

joebeeson · Accepted Answer · 2018-11-09 15:42:40Z

0

Unfortunately your hands are basically tied. If you don't have the means to "speak" to the database (JDBC/ODBC) then there's really nothing you can do.

Perhaps you could elaborate as to why your pip application isn't working and try to get that solved?

answered Nov 9, 2018 at 15:42

joebeeson

4,3861 gold badge25 silver badges29 bronze badges

Collectives™ on Stack Overflow

How to connect to Netezza database from Python?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related