Add database rewrites - merkator-software/GaiaBuilder-manual GitHub Wiki

This tools adds database rewrite to the environment configurations to the current logged in Portal. Use this tool when your organization uses Microsoft SQL Server with OS Authentication and you want to generate a default database rewrite for all your mapservice projects.

This tool can only be run after you've run Add Environment Tool from GaiaBuilder Content Publishing Toolbox

1. Select the ArcGIS Enterprise or ArcGIS Online Portal and Sign in to this Portal with Administative Privilege
2. Open the Geoprocessing Pane
3. Open the GaiaBuilder Map Publishing Toolbox

4. Open the Add Database rewrites for SQLServer to the GaiaBuilder Environmentregistry
   • Enter (part of) the hostname of the SQL server instance under Source Server
   • Enter (part of) the database name under Source Database
   • Select an existing environment under the Environment Dropdown
   • Enter (part of) the hostname of the SQL server instance under Server
   • Enter (part of) the database name under Database
   • Click Add another if when you want to add rewrites to another environment.

5. Click Run to Configure the Environment
6. Repeat step 4 and 5 for each (upstream) ArcGIS Enterprise Environment

Use the ImportMapserviceJSONTool to apply the database rewrites to your mapservice configuration

The rewrites will be applied from the *.aprx.json file when publishing the mapservice from a mapx or lyrx with a connection string with OS authentication. The text entered at source server will be replaced with the text entered at server for the chosen environment and the text entered at source database will be replaced with the text entered at database for the chosen environment.