Alternative connection


It is possible to setup dataobject to use alternative connection string. It means that you can access data from different servers. You can set alternative connection in appdesigner under dataobject settings.

Alternative connection needs to be added to web.config

<add name="MMstage" connectionString="Data Source=;Initial Catalog=;User Id=;Password=" providerName="System.Data.SqlClient"/>

Make sure that configured user has proper permission to access data. 

You can use SQLserver function APP_NAME() in view to get JSON value of user Login running query and his current domain. Ex: {"Domain":"Omega","Login":"user@omega.no"}.

If Alternative connection string is not present in web.config it will use current connection.




Related articles

Placeholder "LocalizeWeb2016" failed