Answered

Connecting to Netezza - Open SQL Connection

(1) Share

Report

Posted on 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:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
MCubedMama 64 on at

Like (0)

Report

@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

Was this reply helpful? Yes No