Name
ESRI ArcSDE Database (SDE)
Synopsis
ArcSDE is ESRI's spatial plug-in for SQL Server, Oracle, and DB2 databases. It is also known as Spatial Database Engine, but most commonly as simply SDE.
SDE support
SDE is supported directly by MapServer.
MapServer 4.4 supports SDE 9, 8, and SDE for coverages on Linux, Windows, and Solaris platforms.
Recent developments in MapServer (v4.4) have added support for SDE raster layers. Using raster layers is beyond the scope of this guide.
Connecting to SDE
Install the SDE client libraries from the SDE CDs.
Compile MapServer with SDE support.
Define the layer in the map file.
Map file example
Specify
CONNECTIONTYPE SDEDefine the
CONNECTIONas:hostname,instancename,databasename,username,passwordDefine the
DATAas:tablename,geometrycolumn
For example:
LAYER
NAME test
TYPE POLYGON
CONNECTION "sde.dms.ca,port:5151,sde,user,password"
CONNECTIONTYPE SDE
DATA "NTDB.WATER,SHAPE"
CLASS
...
END
ENDFor more about SDE and MapServer, see the MapServer documentation page at http://mapserver.gis.umn.edu/doc, or search the reference documentation.