SDEWORKSPACE

Used in

CONFIG  REQUEST  

Servers

Image  Query  Feature  Extract  Geocode  Metadata (Publish)  

Parent elements

WORKSPACES 

Syntax

<SDEWORKSPACEAttribute 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


Notes


Attribute Descriptions for SDEWORKSPACE

AttributeUsage
databaseArcSDE database.
encryptedWhen set to "true", the password for the ArcSDE instance is encrypted. If "false", the password is not encrypted.
geoindexdirDirectory where geocoding index is built. On Windows, the default directory is the "temp" directory. On UNIX, the default is /tmp.
instancePort 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>".
localcodepageSet to "true" for all Metadata Services.
nameWorkspace name. Must be unique among all data sources.
passwordPassword to access the ArcSDE server. For Oracle ArcSDE direct connect, the password must be appended with "@<net service name>".
serverArcSDE server.
userUser name to access the ArcSDE server.
Back to top 

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>

Back to top