GIS Connection Strings

Name

States the user-defined name of the connection string. The first string MUST be called DEFAULT and should point to the geodatabase that contains the feature classes linked to Lucity.

Database Type

Indicates the type of geodatabase, SDE, File, Personal and ArcGISOnline, being connected to.

Database

SDE - Specifies the name of the SQL Server geodatabase. The database listed here 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 field must be left blank.

Personal or File - the path to the geodatabase, including the geodatabase. (Example - R:/GIS/Lucity/LucityGIS.gdb)

Server

SDE - Specifies the name of the server that stores the SDE database.

Personal or File - Leave blank.

Instance

SDE - Indicates the name of the instance for the SDE database.  Supports either spatial or direct connections.

• Spatial Connection: Enter the port where ArcSDE is installed. By default, this is typically 5151. Do not include the /tcp identifier; enter only the port number.
• Direct Connection: 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 - Designates the name of the ArcSDE version that Lucity will use when connecting to the geodatabase (required). For Oracle, the field is case sensitive.

Personal or File - Leave blank.

Authentication Type

SDE - Determines how Lucity will connect to the database.

• DB (Database Authentication) - Complete the UserName and Password fields.
• OSA (Operating System Authentication) - Uses the credentials from the user currently logged into Windows.

Personal or File - Leave blank.

UserName

SDE - Provides the database login that Lucity will use to connect to the geodatabase. The specified user must have permission to ALL feature classes linked to Lucity. Only enter a value if the Authentication Type is set to DB.

Personal or File - Leave blank.

Password

SDE - Provides the password that Lucity will use to connect to the geodatabase. Enter a value only if the Authentication Type is set to DB.

Personal or File - Leave blank.

Edit Map Service URL

Stores a URL for the connection string. This url is different depending on the Database Type.

SDE

• Stores the URL for a default map service that will be used to push Lucity updates to the geodatabase and vice versa. This map service will pass updates for all feature classes that do not have an Alternate Feature Service specified on their Edit Map Service tab.

More information on SDE Updates using ArcServer

ArcGISOnline

• Stores the URL that points to the ArcGISOnline directory that lists your ArcGIS Online services.
• Example: http://services.arcgis.com/<code>/ArcGIS/rest/services.

Map Service User

Indicates the User ID required to access the Edit Map service if it is a secured service.

Map Service Password

Specifies the password for the Map Service User.

Last Modified By

Specifies the last user to modify the connection string.

Last Modified Date

Indicates the last date the connection string was modified.

Last Modified Time

Indicates the last time the connection string was modified.

Update GDB?

Indicates that the selected geodatabase should be updated with edits made in the Lucity Desktop, Web, and Mobile interfaces.

Replica GDB?

Indicates that the selected geodatabase is a replica of your default geodatabase.

Add Connection String button

Adds a new connection string.

Delete Button

Deletes the selected connection string.