topic Re: Publishing App with different data source in Management & Governance

Publishing App with different data source

Spartan27215 — Fri, 03 Dec 2021 21:32:53 GMT

I am confused on how to connect to a different data source when an application is published. How is this accomplished without having to manually edit the data connections in each of the different spaces?

Re: Publishing App with different data source

rubenmarin — Sat, 04 Dec 2021 11:28:37 GMT

Hi, probably there is a better way but you can use the app name to connect to a different sources, so if the app name starts with 'DEV_' it uses dev connection, the code may be something like:

LET vDocumentTitle = DocumentTitle(); IF Upper(Left(vDocumentTitle,4))='DEV_' then SET vConnection = 'DEVConnection'; Else SET vConnection = 'PROConnection'; End If LIB Connect to '$(vConnection)';

Re: Publishing App with different data source

Spartan27215 — Mon, 06 Dec 2021 13:22:05 GMT

Ok I see that. i did not know the syntax to use. I guess this means that I have to have all of my data sources "Predefined" and in the same space. I do not see in the SaaS version a way of creating SQL connectors on the fly and OLEDB Connect To only seems to apply to an on-prem version.

Re: Publishing App with different data source

rubenmarin — Mon, 06 Dec 2021 18:17:13 GMT

Hi, yes, for SQL connectors you have the data connections predefined and the script choose wich one to use based on the app name.