Adding ArcSDE data expand/collapse all
Related Topics

Adding shapefile data

Adding image data

Adding support for dynamic layers and queries

Adding an extract extension

Adding projection information

Adding SPATIALQUERY

Changing paths to UNC format

expand/collapse item About ArcSDE data

ArcSDE is a high-performance, object-based spatial data access engine. It is implemented in several commercial relational database management systems using open standards and true client/server architecture. ArcSDE makes it possible to store a large number of features in a continuous database. ArcIMS supports ArcSDE raster and vector data.

For raster data, ArcIMS supports the following:

For information on the versions of ArcSDE supported by ArcIMS, see the ArcIMS System Requirements on the ESRI support site.

Using direct connect

You can access ArcSDE using direct connect. You must install the client on each of your Spatial Server machines. For more information on the installation, refer to the Appendix titled 'Making a Direct Connection' in the ArcSDE Configuration and Tuning Guide for your RDBMS.

Before you install the client, you need to be aware of the following steps specific to ArcIMS:

ArcSDE connection variables

In order to connect to ArcSDE, you must enter a series of connection variables. The following tables summarize typical values for supported databases.

Database InstanceDatabase Password
Oracle with ArcSDE Port:5151 (Note 2) OptionalMyPassword
Oracle with direct connect sde:<client>
sde:oracle9i (Oracle 9i)
sde:oracle10g (Oracle 10g)
OptionalMyPassword
@netservicename
SQL Server with ArcSDE Port:5151 (Note 2) Database nameMyPassword
SQL Server with direct connect sde:sqlserver:<sql server instance name> Database nameMyPassword
SQL Express for Workgroups with direct connect sde:sqlserver:<machine name>\<sql server instance name> Database nameMyPassword (Note 1)
DB2 Port:5151 (Note 2) OptionalMyPassword
DB2 with direct connect sde:db2 DB alias nameMyPassword
Informix Port:5151 (Note 2) OptionalMyPassword
Informix with direct connect sde:Informix ODBC datasource nameMyPassword

Note 1: To use SQL Express for Workgroups with direct connect, you must use Windows authentication for the username and password. The username must include the domain, for example, "mydomain\myuseraccount". The same user account that is used for running the ArcIMS Monitor service should be used as the username and password for SDEWORKSPACE. In addition, the user account must have read access to the database at a minimum.

Note 2: If you are using a different port number than 5151 for ArcSDE, you should use that port number instead for the instance.

ArcSDE for Coverages

Coverages store geographic features and their data in a topological vector format that allows for complex geoprocessing and sophisticated spatial analysis. The primary feature types for coverages are nodes, arcs, and polygons. ArcSDE for Coverages is used to access ArcInfo coverages in ArcIMS. Connection variables for ArcSDE for Coverages are the same as for ArcSDE (without direct connect).

expand/collapse item How to add ArcSDE data

expand/collapse item Adding an ArcSDE connection

You can add ArcSDE, ArcSDE direct connect, and ArcSDE for Coverages data to your map. If you want to add an ArcSDE Connection but do not have complete information about an ArcSDE instance, contact your ArcSDE administrator.

  1. Click the Add Layers button Add Layers on the Author toolbar to open Catalog.
  2. Under Data Sources, double-click ArcSDE.
  3. Under ArcSDE, double-click Add ArcSDE Connection.

    The ArcSDE Connection dialog box appears.

  4. Type the name of the ArcSDE server to connect to in the Server text box.
  5. Type the instance for your RDBMS in the Instance text box.
  6. If necessary, type the name of a database in the Database text box.
  7. Type the ArcSDE User name and Password.
  8. Click Test Connection.

    If you see Connection Failed in the message box that appears, click OK and double-check your settings.

    If you see Connection Succeeded in the message box that appears, click OK and continue.

  9. Click OK to connect to your ArcSDE server.


Search code: @author_sde