In order to use the geodatabase integration with Lucity, the geodatabase connection parameters must be setup. Where the geodatabase connection info is setup depends on which version of ArcGIS is being used. To access the GIS Database connection information available go to System > Configuration > GIS > Database.
Arc 10x users
The following screen will appear allowing users to test the geodatabase connection for troubleshooting purposes.
Configuration of the geodatabase connection string is done using the Lucity Administration tool and is described here.
Arc 9.3 users
The following screen will appear allowing users to configure and test the geodatabase connection. Depending on which type of geodatabase is being connected different fields will be available to fill out.
To connect to a Personal or File Geodatabase, use the Database Location field to:
Select Path - Click the Select Path button to identify the path where the Personal Geodatabase (.mdb) is located
Select Folder - Click the Select Folder button to identify the folder that contains the File Geodatabase (.gdb)
Important: Lucity does not fully support Personal or File geodatabase configurations. The workstation application will be updated with edits from the geodatabase; however, the geodatabase will not be updated with edits made from the desktop.
Note: For SQL Server users using a personal geodatabase or a file geodatabase, the Database Location field is grayed out. In this case, changes to the database location must be performed through ClientMaintenance.exe (in the Admin tools). If moving from a personal/file geodatabase to an ArcSDE database, or vice versa, Client Maintenance must be used to change the database type (SQL Server, Oracle, Access) prior to populating this form.
There are two ways to connect to an ArcSDE geodatabase: Spatial Connection or Direct Connection.
A spatial connection updates the geodatabase by communicating with the ArcSDE service that is installed on the ArcSDE server.
A direct connection updates the geodatabase using locally installed ArcSDE libraries.
Spatial Connect Example
Direct Connect Example, SQL Server
Lucity can use either a spatial connect or a direct connection to update an enterprise ArcSDE geodatabase. Regardless of the method you use to connect, you must fill out the following data on the GIS Database Configuration dialog:
Server: This must contain the name of the machine where ArcSDE is installed. This should be entered regardless of which type of connection you plan to use.
Instance: The only thing that will differ between an ArcSDE spatial connection and a direct connection is the information stored in this field.
If you want to use a spatial connect from the desktop application, then this should contain the port where ArcSDE is installed. By default this is typically 5151. Do not include the /tcp identifier; enter only the number for the port.
If you want to use a direct connect from the desktop application, you will enter the name of the direct connect driver and the name of the SQL Server database. For SQL Server, this would be "sde:sqlserver:GIS_SERVER\DATA".
Database: This must contain the name of your SQL Server geodatabase.
For Oracle geodatabases, leave this field blank.
User/Password: This information is always required; it designates the name of the ArcSDE user that the desktop will use when updating the geodatabase.
Version: This information is always required; it designates the name of the ArcSDE version that the desktop will use when updating the geodatabase.
Note: For Oracle, the Version is case sensitive.
SQL Server Instance: The name of the SQL Server instance where the GIS Geodatabase resides. This information should always be populated for SQL Server clients regardless of which type of connection is used.
Note: While this is not the same as the Server, for some clients it could be the same value. It depends on what your SQL Server instance is named.
Click to make sure your changes are functional.
There are several things to keep in mind if you want to use direct connections instead of spatial connections:
This connection information is shared among all machines, so a direct connect configuration must be appropriate for all users. You cannot have some users connect from the desktop using spatial connects while others use direct connects.
ESRI has restrictions on when direct connections can be used based on the locally installed ArcGIS version and the version of the ArcSDE geodatabase. See here for more details.
Starting in version 7, users who do not have ArcGIS or ArcEngine (9.2+) installed locally on their system will no longer be able to make edits to attributes in the desktop that are shared with the geodatabase. Fields linked to the geodatabase will be disabled from workstations that do not have one of these applications installed unless "Disable Geodatabase Updates from Lucity" is selected. If you choose to install ArcGIS or ArcEngine on a user's machine post-installation, you will need to repair the Workstation application in order for these edits to be allowed. Consult the Repairing Lucity topic for additional details.
Note: Any changes made will not take effect until the user logs out of the system and logs back in. The following prompt will appear every time changes are made.
Connect to a Personal or File Geodatabase
to make sure your changes are functional.