Qlik Community

Ask a Question

Connectivity & Data Prep

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

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
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
petter
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?

petter
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/

dafnis14
Specialist
Specialist
Author

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!

petter
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.

dafnis14
Specialist
Specialist
Author

Thank you very much, Petter!

Will give it a try... 🙂