Looking for Command/PowerShell script to update the user id and password of QMC data connection.

jrathgebercs — Tue, 11 Mar 2025 10:38:46 GMT

Hi All,

We don't have permission to enter manual service user password.

Do we have any Command/PowerShell script to update the user id and password of QMC data connection.?

Could you please help on this to resolve this issue.

Thank you.!!

Re: Do we have any Command/PowerShell script to update the user id and password of QMC data connection.?

jrathgebercs — Mon, 10 Mar 2025 07:07:51 GMT

Hi All,

I am able to update the manual QMC data connection password using below script.

echo off SET PGPASSWORD=Qlik@123 echo Qlik password %PGPASSWORD% cd /D "D:\Program Files\Qlik\Sense\Repository\PostgreSQL\14\bin\" psql -h localhost -p 4432 -U postgres -d QSR UPDATE public."DataConnections" SET "PasswordString"='%PGPASSWORD%' WHERE "Name"='Mydataconenciton ';

But when I am trying to pass the password variable that is not working. Could you please suggest how can id pass the variable in update command last line in my script.

Thank you.!!!

Re: Do we have any Command/PowerShell script to update the user id and password of QMC data connection.?

jrathgebercs — Mon, 10 Mar 2025 08:41:57 GMT

Hi All,

I am facing one issue after update data connection using script.

Thank you.!!

Re: Do we have any Command/PowerShell script to update the user id and password of QMC data connection.?

jrathgebercs — Tue, 11 Mar 2025 08:29:52 GMT

Hi All,

Still I am looking solution for this. I got script from Qlik community URL (https://community.qlik.com/t5/Deployment-Management/Update-Password-in-DataConnections-automatically/td-p/104503) and trying to use but getting some error. Could you please suggest me where we need to change in this script.

# Prompt for password $Password = Read-Host -Prompt 'Input the new password' # Store the Base64 Encoded package in the Host.cfg for connection $Data = Get-Content C:\ProgramData\Qlik\Sense\Host.cfg # Convert the base64 encoded install name for Sense to UTF data $FQDN = [System.Text.Encoding]::UTF8.GetString([System.Convert]::FromBase64String($($Data))) # Connect to Qlik Sense using an internal account (sa_api) Connect-Qlik -ComputerName https://$($FQDN):4242 -Username INTERNAL\sa_api # Expose all elements of the JSON response $rawoutput=$true # Get the DataConnection JSON for a particular data connection $RESTapp = Invoke-QlikGet -path "/qrs/dataconnection/full?filter=(name eq 'BMS2014')" # Filter out the ID value for later GET $RESTappID = $RESTapp.id # GET the DataConnection JSON $RESTappDC = Invoke-QlikGet -path /qrs/dataconnection/$RESTappID # Swap the password out in the JSON $RESTappDC | Add-Member Password $Password -Force # Convert to actual JSON $RESTappDC = $RESTappDC | ConvertTo-Json # PUT in the new password Invoke-QlikPut -path https://$($FQDN):4242/qrs/dataconnection/$RESTappID -body $RESTappDC

I am getting below error while executing above script.:

Connect-Qlik : The term 'Connect-Qlik' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Users\Myuser\Desktop\qlik_sense_pwd_change.ps1:8 char:1 + Connect-Qlik -ComputerName https://$($FQDN):4242 -Username INTERNAL\s ... + ~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Connect-Qlik:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-QlikGet : The term 'Invoke-QlikGet' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Users\Myuser\Desktop\qlik_sense_pwd_change.ps1:12 char:12 + $RESTapp = Invoke-QlikGet -path "/qrs/dataconnection/full?filter=(nam ... + ~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-QlikGet:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-QlikGet : The term 'Invoke-QlikGet' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Users\Myuser\Desktop\qlik_sense_pwd_change.ps1:16 char:14 + $RESTappDC = Invoke-QlikGet -path /qrs/dataconnection/$RESTappID + ~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-QlikGet:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-QlikPut : The term 'Invoke-QlikPut' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Users\Myuser\Desktop\qlik_sense_pwd_change.ps1:22 char:1 + Invoke-QlikPut -path https://$($FQDN):4242/qrs/dataconnection/$RESTap ... + ~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-QlikPut:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException

This is urgent. Please suggest .

Thank you.!!

topic Re: Do we have any Command/PowerShell script to update the user id and password of QMC data connection.? in Connectivity & Data Prep

Looking for Command/PowerShell script to update the user id and password of QMC data connection.

Re: Do we have any Command/PowerShell script to update the user id and password of QMC data connection.?

Re: Do we have any Command/PowerShell script to update the user id and password of QMC data connection.?

Re: Do we have any Command/PowerShell script to update the user id and password of QMC data connection.?