Connection error for Manage In-DB for IBM Netezza

[trevorwightman]

I've been granted access to the Netezza Environment at my company and am now trying to access the data with it using Alteryx. I went to Options -> Advanced Option -> Manage In-DB Connections and made the below sections/entries. When I try to run a workflow I get the following error. Any idea how to successfully complete this connection?

Error: Connect In-DB (1): Error SQLDriverConnect: Server and/or port attributes are empty

 

[StellaBon · Accepted solution]

@trevorwightman You need to specify the server and port. Check with your supervisor or alteryx/IT administrator:

Example:

Driver={NetezzaSQL};servername=cs-spubox6.netezza.com;port=5480;

See: https://www.ibm.com/support/pages/values-odbc-connection-string 

Hope this helps,

StellaBon

[trevorwightman]

Thank you! I was able to connect with your help! :)

[StellaBon]

@trevorwightman Awesome!

[trevorwightman]

Hello again, another coworker is trying to connect to the database and receiving an error of LDAP Authentication. Any idea why he is getting this error?