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. The following tables summarize typical values for supported databases for instance, database, and password.

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

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.

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

<?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.