topic Re: Microsoft Dynamics CRM V2 - change connection from script in Connectivity & Data Prep

Microsoft Dynamics CRM V2 - change connection from script

Anonymous — Fri, 02 Apr 2021 09:10:24 GMT

Good morning everyone,

I'm looking to migrate our connections from Microsoft Dynamics CRM to Microsoft Dynamics CRM V2.

I've seen that in the new version, there is no parameter connectionstring in the generated URL.
Trying to add it (copying it from the old version of the connector), I got an error.

Is this parameter still supported? Or is there any way to change, from Qlik Sense/QlikView script, the environment on which we are running the query?
In my current situation, I need to perform the same query on different environments usin the same Web Connectors installation.

Any help is appreciated!

Riccardo

Re: Microsoft Dynamics CRM V2 - change connection from script

chrisbrain — Thu, 25 Mar 2021 10:50:02 GMT

@Anonymous Since moving this connector to use OAuth this isn't so easily supported.

One possible workaround is to create different QWC users and for each one authenticate with a specific instance.

Re: Microsoft Dynamics CRM V2 - change connection from script

Anonymous — Thu, 25 Mar 2021 11:17:02 GMT

I see, I missed that the new version uses a different authentication method.

Currently we're not using the authentication for QWCs (as they're accessible only from localhost), but you're totally right
Thank you for your tip @chrisbrain!