GIS Connection Strings

This window is to provide Lucity with connection strings to connect to ArcGIS geodatabases. Connection strings have two purposes. They allow Lucity to connect to a geodatabase and update the attributes of feature class records that are linked to Lucity. They also help the Lucity GIS tools in ArcMap to identify which feature classes are linked to Lucity.

To access the connection strings window in the Lucity Administration tool go to GIS > Connection Strings. The following window will appear.

Connection

Name	The user defined name of the connection string. The first one MUST be called DEFAULT. This connection string should point to geodatabase that contains the feature classes linked to Lucity.
Database Type	The Type of Geodatabase, SDE, File or Personal.
Database	SDE - This must contain the name of the SQL Server geodatabase. The database listed in this field is not the sde repository database. Instead, it is the geodatabase that contains the infrastructure data that you want to integrate with the desktop. For Oracle geodatabases this must be blank. Personal or File - the path to the geodatabase, including the geodatabase. (Example - R:/GIS/Lucity/LucityGIS.gdb)
Server	SDE - The name of the server that holds the SDE database. Personal or File - leave blank
Instance	SDE - The name of the instance for the SDE database. This supports either spatial or direct connections. Spatial Connect: This field should contain the port where ArcSDE is installed. By default this is typically 5151. Do not include the /tcp identifier; enter only the port number. Direct Connect: Enter the name of the direct connect driver and the name of the server instance. SQL Server example: "sde:sqlserver:GIS_SERVER\DATA" Oracle example: "sde:Oracle11g:GIS_SERVER\DATA" Personal or File - leave blank
Version	SDE - This information is always required; it designates the name of the ArcSDE version that Lucity will use when connecting to the geodatabase. For Oracle, the Version is case sensitive. Personal or File - leave blank
Authentication Type	SDE - How Lucity will connect to the database. DB = Database Authentication. The UserName and Password fields must be filled out. OSA = Operating System Authentication - Uses the credentials from the user currently logged in to windows. Personal or File - leave blank
UserName	SDE - The database login that Lucity will use to connect to the geodatabase. This user must have permission to ALL feature classes linked to Lucity. Only enter if the Authentication Type is set to DB. Personal or File - leave blank
Password	SDE - The password that Lucity will use to connect to the geodatabase. Only enter if the Authentication Type is set to DB. Personal or File - leave blank
Edit Map Service URL	Stores The URL for a default map service that will be used to push updates from Lucity to the Geodatabase and the Geodatabase to Lucity. For more information go here. This map service will be used to pass updates for all feature classes unless they have an Alternate Feature Service specified on their Edit Map Service Tab.
Map Service User	User ID for accessing the Edit Map Service if it is a secured service.
Map Service Password	Enter the password for the Map Service User.
Last Modified By	The last user to modify the connection string.
Last Modified Date	The last date the connection string was modified.
Last Modified Time	The last time the connection string was modified.
Update GDB?	Check this box if the selected geodatabase should be updated with edits made in the Lucity desktop, web, and mobile interfaces.
Replica GDB?	Check this box if the selected geodatabase is a replica.
Add Connection String button	Adds a new connection string.
Delete Button	Deletes the currently selected connection string.

Note: An exclamation point in the left-hand margin indicates a bad connection.

In This Section

Collecting SDE Connection String Information