ArcSDE Data Source Properties
Esri Spatial Database Engine (SDE) is a legacy client/server application that enables spatial data to be stored, managed and retrieved from database management systems like Oracle, Microsoft SQL Server, Sybase, IBM DB2 and Informix.
To access data from ArcSDE server, SkylineGlobe Server requires access to specific x64 ArcSDE components (dynamic link library files): sde.dll, pe.dll and sg.dll, of versions 10.2, 10.0, 9.3 or 9.2. For versions 9.2 and 9.3, msvcr71.dll is also required. These files are installed with various Esri components, including ArcGIS Desktop and ArcSDE SDK, as well as the free viewers, ArcGIS Explorer Desktop and ArcReader.
Note: SGS support for ArcSDE only includes feature layers.
To allow SkylineGlobe Server to access these files, do any of the following:
§ Make sure an ARCGISHOME or AGSDESKTOPJAVA environment variable is defined on your system and includes a reference to a folder under which a bin folder exists with the above mentioned files.
§ Make sure a PATH environment variable is defined on your system and includes a reference to a folder under which a bin folder exists with the above mentioned files.
§ Copy the DLL’s to the SGS bin folder that is placed under the SGS installation (by default C:\inetpub\wwwroot\SG).
The following parameters are relevant for an ArcSDE data source:
|
Field |
Description |
|
Name |
Name of the data source. |
|
Description |
Free text description of the data source. |
|
Data Source Type |
Data source type. |
|
View Access |
The default view permission level for all layers from this data source, i.e., the users that have been granted view access (None, Only Me, My Group, Everyone, or Selected List). A different permission level can be set for any individual layer from the Layers page. See “Editing Layer Properties” in the “Working with Layers” chapter for information. Users with valid view access for a layer can list, view and load the layer (opened from TerraExplorer Desktop, TerraExplorer for Web, WFS/WMS clients, etc.). If you want to grant access to selected groups, users, or sites see “Granting Edit or View Access” in this chapter for information. |
|
Owner |
Select the name of the user who will be owner of all layers from this data source. Only an owner or administrator can modify layer properties. |
|
Server |
Server name (mandatory) |
|
Port |
Port number. |
|
Instance |
Instance name. |
|
Database |
Database name (optional). |
|
User |
User name required to connect to the data source. |
|
Password |
Password required to connect to the data source. |
|
Auto-Scan |
If you want SGS to scan the data source periodically for changes, select the check box, and enter the required time interval between scans. When a data source is auto-scanned, the following updates are made to SGS: § All new layers are automatically added. § All layers deleted from data source are automatically removed. § All previously published layers that were modified are updated in SGS. |