SDEWORKSPACE

SDEWORKSPACE

Used in: CONFIG REQUEST
Parent elements: WORKSPACES

<SDEWORKSPACE	Attribute Description Table
*instance ="string"* *name ="string"* *password ="string"* *server ="string"* *user ="string"* database ="string" encrypted ="true \| false" [false] geoindexdir ="string" [Windows: c:\temp and UNIX: /tmp] > No child elements </SDEWORKSPACE >
Bold: Attribute or child element is required.

Description:

Defines an ArcSDE data source.

Restrictions:

Must refer to an existing ArcSDE data source.

Notes:

The SDEWORKSPACE can be used to set up an ArcSDE direct connect. For more information on direct connect and installation instructions for use with ArcIMS, see Appendix C of the ArcIMS 3.1 Installation Guide.

The following table summarizes whether the attributes server and database are required or optional when using ArcSDE or ArcSDE direct connect. It also shows an example of correct syntax for the attribute instance.

Database	Server	Instance	Database
Oracle with ArcSDE	Required	Port:5151	Optional
Oracle with direct connect	Optional	sde:oracle	Optional
SQL Server with ArcSDE	Required	Port:5151	Required
SQL Server with direct connect	Optional	sde:sqlserver	Required
Other Databases	Required	Port:5151	Optional

The next table summarizes whether the attribute user is required, the correct syntax for password, and whether the password can be encrypted.

Database	User	Password	Can Encrypt Password
Oracle with ArcSDE	Required	MyPassword	Yes
Oracle with direct connect	Required	MyPassword @net8servicename	No
SQL Server with ArcSDE	Required	MyPassword	Yes
SQL Server with direct connect	Required	MyPassword	No
Other Databases	Required	MyPassword	Yes

Passwords for ArcSDE datasets, by default, are not encrypted. In order to encrypt a password, you need to connect to the ArcSDE instance while in ArcIMS Author or ArcExplorer 3. Since you cannot connect to an ArcSDE direct connect layer using ArcIMS Author or ArcExplorer Java 3, the password cannot be encrypted for ArcSDE direct connect.
If layers do not appear in a map, double check that the workspace information is correct including the user name and password.

Attribute Descriptions for SDEWORKSPACE:

Attribute	Usage	Back to Top
database	ArcSDE database.
encrypted	When set to true, the password for the ArcSDE instance is encrypted. If false, the password is not encrypted.
geoindexdir	Directory where geocoding index is built. On Windows, the default directory is the "temp" directory. On UNIX, the default is /tmp.
instance	Port number for ArcSDE instance. For example, if the port for an ArcSDE dataset is 5151, then the instance is "port:5151". For ArcSDE direct connect, the correct value is "sde:<database_vendor>". For ArcIMS 3.1, the two accepted values with direct connect are "sde:oracle" and "sde:sqlserver".
name	Workspace name; must be unique among all data sources.
password	Password to access the ArcSDE server. For Oracle ArcSDE direct connect, the password must be appended with "@<net8 service name>" .
server	ArcSDE server.
user	User name to access the ArcSDE server.

Examples for SDEWORKSPACE:

Example 1: When in CONFIG and REQUEST.

Back to Top

<?xml version="1.0" encoding="UTF-8"?>
<ARCXML version="1.1">
  <CONFIG>
    <ENVIRONMENT>
      <LOCALE country="US" language="en" variant="" />
      <UIFONT color="0,0,0" name="Arial" size="12" style="regular" />
      <SCREEN dpi="96" />
    </ENVIRONMENT>
    <MAP>
      <PROPERTIES>
       <ENVELOPE minx="-178" miny="18" maxx="-66.9" maxy="71.4" name="Initial_Extent" />
       <MAPUNITS units="decimal_degrees" />
      </PROPERTIES>
      <WORKSPACES>
       <SDEWORKSPACE name="sde_ws-2" server="zephyr" instance="port:5150" database="" user="washoe" encrypted="true" password="LXEMUR" />
      </WORKSPACES>
      <LAYER type="featureclass" name="ZEPHYR.STREETS" visible="true" id="1">
       <DATASET name="ZEPHYR.STREETS" type="line" workspace="sde_ws-6" />
       <SIMPLERENDERER>
         <SIMPLELINESYMBOL type="solid" width="1" color="227,127,227" />
       </SIMPLERENDERER>
      </LAYER>
    </MAP>
  </CONFIG>
</ARCXML>

Example 2: When using ArcSDE raster data.

Back to Top

Example 3: Using ArcSDE direct connect.

Back to Top

<?xml version="1.0" encoding="UTF-8"?>
<ARCXML version="1.1">
  <CONFIG>
    <ENVIRONMENT>
      <LOCALE country="US" language="en" variant="" />
      <UIFONT color="0,0,0" name="Arial" size="12" style="regular" />
      <SCREEN dpi="96" />
    </ENVIRONMENT>
    <MAP>
      <PROPERTIES>
      <ENVELOPE minx="-180.0" miny="-90.0" maxx="180.0" maxy="83.62303200000002" name="Initial_Extent" />
      <MAPUNITS units="decimal_degrees" />
      </PROPERTIES>
      <WORKSPACES>
      <SDEWORKSPACE name="sde_ws-0" server="ARCSDENAME" instance="sde:oracle" database="" user="sde" encrypted="false" password="my_password@net8servicename" geoindexdir="C:\Temp\" />
      </WORKSPACES>
      <LAYER type="featureclass" name="country" visible="true" id="0">
      <DATASET name="SDE.COUNTRY" type="polygon" workspace="sde_ws-0" />
      <SIMPLERENDERER>
        <SIMPLEPOLYGONSYMBOL boundarytransparency="1.0" filltransparency="1.0" fillcolor="27,27,27" boundarycaptype="round" boundarycolor="0,0,0" />
      </SIMPLERENDERER>
      </LAYER>
    </MAP>
  </CONFIG>
</ARCXML>