SDEWORKSPACE

SDEWORKSPACE

Used in: CONFIG   REQUEST
Servers: Image   Query   Feature   Extract   Geocode   Metadata (Publish)
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] localcodepage ="true \| false" [false] > 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.
Not valid with ArcMap Server.

Notes:

For more information on Direct Connect and installation instructions for use with ArcIMS, see Making a Direct Connection, a PDF book available in the documentation folder located on your ArcSDE CD-ROM.

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 (Oracle 8i) sde:oracle9i (Oracle 9i)	Optional
SQL Server with ArcSDE	Required	Port:5151**	Required
SQL Server with direct connect	Optional	sde:sqlserver	Required
DB2	Required	Port:5151**	Optional
DB2 with direct connect	Optional	sde:db2	Optional
Informix	Required	Port:5151**	Optional
Informix with direct connect	Optional	sde:Informix	Optional

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

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 @netservicename	No
SQL Server, DB2, or Infomix with ArcSDE	Required	MyPassword	Yes
SQL Server, DB2, or Informix with direct connect	Required	MyPassword	No

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 9. Since you cannot connect to an ArcSDE direct connect layer using ArcIMS Author or ArcExplorer 9, 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 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 a Metadata Service if the character set of the database is set to a multi-byte language such as Japanese and Chinese or an 8-bit language such as Thai or Russian. This ensures that information sent from the Metadata Service to the database will be in the system default codepage. This attribute must be set to "true" before publishing non-English documents; otherwise, the documents must be republished. Note that in this scenario, you are limited to the language you are working in plus English. More details are available in the document Creating and Using 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.

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" />
      <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.

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="-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.

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="-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.

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" />
      <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>