Answered

Connecting to Netezza - Open SQL Connection

Like (1) Share

Report

Posted on 25 Mar 2025 17:08:37 by MCubedMama

I am using the 'Open Sql connection' Action in PAD to connect to Netezza. When I initially set up the connection and Test the connection, I received a 'Test connection succeeded.' message. However, when I attempt to run the Open Sql Connection I get an error message saying, 'Can't connect to data source ERROR [08001] Invalid - user name' . Any advice on how I can use PAD to connect to Netezza successfully?

Categories:

Process Advisor

All responses (2)

Answers (1)

MCubedMama 64 on 28 Mar 2025 at 16:31:20

Like (0)

Report

Connecting to Netezza - Open SQL Connection

@VishnuReddy1997

I took your advice and manually defined the connection string, and I was able to successfully run the Open SQL Connection without error.

However, when I attempt to run the Execute SQL Statement action, I receive the following error message below. Any advice on how to address this?

Can't Connect to data source ERROR[28000] LDAP authentication failed for user XXXXX

ERROR [28000] LDAP authentication failed for user XXXX

Location: Subflow: Run SQL Query, Line: 45, Action name: Execute SQL statement
Verified answer

VishnuReddy1997 2,297 Super User 2025 Season 1 on 27 Mar 2025 at 05:36:27

Like (0)

Report
Connecting to Netezza - Open SQL Connection

Hi @Mcubedmama,

Please try these below 2 methods.

1. Verify Credentials Used in PAD

Ensure the username and password provided in the connection string exactly match the credentials you tested successfully.

If you’re using Windows Authentication, try using SQL Authentication instead.

2. Use a Fully Qualified Connection String

Instead of relying on PAD's GUI-based connection setup, manually define the connection string in the Open SQL Connection action.

Try the following format:

Driver={NetezzaSQL};Server=<your_server>;Database=<your_database>;UID=<your_username>;PWD=<your_password>;

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy