topic Re: Include remote desktop details in a connection string in Connectivity & Data Prep

Include remote desktop details in a connection string

dafnis14 — Sun, 14 Oct 2018 19:22:58 GMT

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!

Re: Include remote desktop details in a connection string

petter — Sun, 14 Oct 2018 22:33:01 GMT

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

Re: Include remote desktop details in a connection string

petter — Sun, 14 Oct 2018 22:49:20 GMT

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/

Re: Include remote desktop details in a connection string

dafnis14 — Mon, 15 Oct 2018 05:00:37 GMT

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!

Re: Include remote desktop details in a connection string

petter — Mon, 15 Oct 2018 05:35:11 GMT

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.

Re: Include remote desktop details in a connection string

dafnis14 — Mon, 15 Oct 2018 07:06:47 GMT

Thank you very much, Petter!

Will give it a try... 🙂