Connecting to an IBM Netezza database

Use the following procedure to connect to your IBM Netezza database:

Click on the New icon in the Project panel at the top left corner of the window.
Select IBM Netezza in the Platform drop-down list at the top of the dialog box.
Select the Standard option in the Mode drop-down list if you would like to connect to the IBM Netezza database in the standard mode.
- Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been used already).
- Provide the rest of connection information to the IBM Netezza database: Server Port and Username. You can manually enter these values or select them from drop-down lists.
- Enter the Password to fill in the information about IBM Netezza database connection.
- Press the Test button to verify that you can successfully connect to your IBM Netezza database.
Select the ConnectionString option in the Mode drop-down list if you want to connect to the IBM Netezza database using the connection string.
- Enter the Connection string manually or select it from the drop-down list (if it has already been used).
- Find the connection string template below. Use it as an example to create a connection string that allows to connect to your IBM Netezza database:
```
HOST=netezza_server;PORT=5480;DATABASE=SYSTEM;USERNAME=netezza_user;PASSWORD=pass;USEEXTENDEDTYPES=True;SECURITYLEVEL=0;TIMEOUT=300
```
- Press the Test button to verify that you can successfully connect to your IBM Netezza database.

You can report problems, ask questions or share ideas for improvements on our email [email protected].