SDEWORKSPACE

Used in

Servers

Image Query Feature Extract Geocode Metadata (Publish)

Parent elements

Syntax

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

Description

Defines an ArcSDE data source.

Restrictions

Must refer to an existing ArcSDE data source.
Not valid with ArcMap Server.

Notes

For more information on Direct Connect and installation instructions for use with ArcIMS, see the Appendix titled 'Making a Direct Connection' in the ArcSDE Configuration and Tuning Guide for your RDBMS.
In order to connect to ArcSDE, you must enter a series of connection variables. For more information on values to use instance, database, and password, see ArcSDE connection syntax in the ArcGIS Desktop Help. This topic contains information for all the supported databases.
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-Java Edition.
If layers do not appear in a map, double-check that the workspace information is correct including the username and password.

Attribute Descriptions for SDEWORKSPACE

Attribute	Usage
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 9, the accepted values with direct connect are "sde:oracle" (Oracle 8i), "sde:oracle9i" (Oracle 9i), "sde:sqlserver", "sde:db2", and "sde:Informix".
localcodepage	Set to "true" for all Metadata Services.
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 "@<net service name>".
server	ArcSDE server.
user	User name to access the ArcSDE server.

Examples for SDEWORKSPACE

Example 1: When in CONFIG and REQUEST.

<?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" />
      <FILTERCOORDSYS id="4326" />
      <FEATURECOORDSYS id="4326"/>
      </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 with Oracle.

<?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="-90" miny="-180" maxx="90" maxy="180"/>
        <MAPUNITS units="decimal_degrees" />
        <FILTERCOORDSYS id="4326" />
        <FEATURECOORDSYS id="4326"/>
      </PROPERTIES>
      <WORKSPACES>
        <SDEWORKSPACE name="sde_ws-1" server="zephyr" instance="port:5100" database="" user="sdeuser" password="XLMRP" />
      </WORKSPACES>
      <LAYER type="image" name="SDEUSER.TEST.RASTER" id="image" visible="true">
        <DATASET workspace="sde_ws-1" name="SDEUSER.TEST.RASTER" />
      </LAYER>
    </MAP>
  </CONFIG>
</ARCXML>

Example 3: When using ArcSDE raster data with SQL Server, DB2, or Informix.

<?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="-90" miny="-180" maxx="90" maxy="180"/>
        <MAPUNITS units="decimal_degrees" />
        <FILTERCOORDSYS id="4326" />
        <FEATURECOORDSYS id="4326"/>
      </PROPERTIES>
      <WORKSPACES>
        <SDEWORKSPACE name="sde_ws-1" server="zephyr" instance="port:5100" database="sdedatabase" user="sdeuser" password="XLMRP" />
      </WORKSPACES>
      <LAYER type="image" name="SDEDATABASE.SDEUSER.TEST.RASTER" id="image" visible="true">
        <DATASET workspace="sde_ws-1" name="SDEDATABASE.SDEUSER.TEST.RASTER" />
      </LAYER>
    </MAP>
  </CONFIG>
</ARCXML>

Example 4: Using ArcSDE direct connect with Oracle.

<?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" />
      <FILTERCOORDSYS id="4326" />
      <FEATURECOORDSYS id="4326"/>
      </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>

Example 5: Using ArcSDE direct connect with SQL Server.

<?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="SansSerif" size="12" style="regular" />
      <SCREEN dpi="96" />
    </ENVIRONMENT>
    <MAP>
      <PROPERTIES>
      <ENVELOPE minx="-157.80419899999993" miny="21.317248999999947" maxx="-69.72971299999995" maxy="58.38859200000002" name="Initial_Extent" />
      <MAPUNITS units="decimal_degrees" />
      </PROPERTIES>
      <WORKSPACES>
      <SDEWORKSPACE name="sde_ws-0" server="myserver" instance="sde:sqlserver:mymachinename" database="vtest" user="myusername" encrypted="false" password="mypassword" />
      </WORKSPACES>
      <LAYER type="featureclass" name="State Capitals" visible="true" id="0">
      <DATASET name="VTEST.VTEST.CAPITALS" type="point" workspace="sde_ws-0" />
      <SIMPLERENDERER>
        <SIMPLEMARKERSYMBOL width="6" />
      </SIMPLERENDERER>
      </LAYER>
    </MAP>
  </CONFIG>
</ARCXML>

Example 6: Using ArcSDE direct connect with SQL Express for Workgroups.