Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Include remote desktop details in a connection string

Hi,

Is it possible to define RDP user & password details in a connection string in the script?

if not, is there any other way to bypass the manual logging in?

Thanks!

5 Replies
Highlighted
MVP
MVP

I have a problem understanding why Remote Desktop would be used from a load script. Could you please explain your scenario in more detail?

Highlighted
MVP
MVP

RDP is the protocol that is used by Microsoft Remote Desktop or MSTSC (Microsoft Terminal Services Client). The parameters for the latter programs can be set in an .rdp file. A connection string could not be used to specify parameters to these programs as they are not any kind of connectors or databases for Qlik to use.

Here is the documentation on parameters and .rdp files:

RDP Settings for Remote Desktop Services in Windows Server 2008 R2 | Microsoft Docs

Configuring Windows Remote Desktop from the command line

https://www.donkz.nl/overview-rdp-file-settings/

Highlighted
Specialist
Specialist

Hi Petter,

The request I have is to refer the same desktop app to various RDPs  in order to connect to the relevant database.

I thought that it would be nice to have the RDPs details defined as parameters for the load script.

I guess referring to connection string is misleading..

So based on the links you sent, I guess a BAT file would need to be executed from the script for each RDP.

Is this feasible?

Thanks!

Highlighted
MVP
MVP

You should be able to have drives from the RDP session accessible but I don't see how you can connect to a database directly from your load script to a database even if you have RDP sessions established.

You should try to get a database login on each of the databases with the same login/username/identity as you would have for the RDP sessions and use a regular database connection from your load script. Then the login credentials could be saved and handled in the connection string.

Highlighted
Specialist
Specialist

Thank you very much, Petter!

Will give it a try... 🙂