Add-OdbcDsn timeout with Amazon Redshift (x64) Driver

Question

Hello every body,
I would like to add a ODBC DSN to my driver "Amazon Redshift (x64)" programmatically using wdac cmdlet (I try with Powershell).
The "Amazon Redshift (x64)" is installed correctly.
I can successfully add an odbc dsn using the UI (ODBC Data Source Desktop App), I can test the connection which works perfectly.
But I am not able to add the same odbc dsn with powershell. See below my command :
Add-OdbcDsn -DriverName "Amazon Redshift (x64)" -DsnType "System" -Platform "64-bit" -Name "myName"  -SetPropertyValue @("Server=redshiftserver.eu-west-1.redshift.amazonaws.com", "Database=dev", "Port=5439", "Trusted_Connection=Yes")

For the first command, I always need to cancel the command because I don't have any response.
Add-OdbcDsn -DriverName "Amazon Redshift (x64)" -DsnType "System" -Platform "64-bit" -Name "myName"  -SetPropertyValue @("Server=redshiftserver.eu-west-1.redshift.amazonaws.com", "Database=dev", "Port=5439", "Trusted_Connection=Yes", "UID=user", "PWD=pwd" )

If I add UID and PWD ( see above the 2nd command) I receive an error message saying "These keys should not be stored in the registry for
security reason."

How can I add an ODBC Dsn to the driver "Amazon Redshift (x64)" with the wdac cmdlet ?

Thank you all for your time,

Answer 1

Hi @GatienPoirrier-1346,

This question is not related to Azure Active Directory, and WDAC and AWS questions are not supported on this forum. If you'd like to ask a Powershell question, you can reach out to the experts on the Answers community. https://answers.microsoft.com/en-us

If you are looking for AWS support, you can reach out on their support forums. https://forums.aws.amazon.com/index.jspa