Question & Answer
Question
What information is required to create an ODBC connection string?
Answer
The following keyword/value pairs are required in the Netezza ODBC connection string:
| Keyword | Example Value | Comment |
| Driver | {NetezzaSQL} | |
| Servername | prodnps1 | |
| Port | 5480 | This is the default value. |
| Database | prodedw | |
| Username | user1 | |
| Password | mypassword |
Driver={NetezzaSQL};servername=cs-spubox6.netezza.com;port=5480;database=nps_info; username=admin;password=password;
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ404878
Was this topic helpful?
Document Information
More support for:
IBM PureData System
Software version:
1.0.0
Document number:
463443
Modified date:
17 October 2019
UID
swg21571224