Bringing In Features from ArcSDE
Concept Procedure Quick Reference
 
 
 

To set up your system for ArcSDE 9.2 (or if you use the 9.1 client and you access the ArcSDE 9.2 server)

  1. Install the following DLL files on the computer on which you run AutoCAD Map 3D.

    Copy the files to the directory in which the ArcSDE provider is installed. Usually, the directory is C:\Program Files\AutoCAD Map 3D 2010\FDO\bin

    pe.dll

    sde.dll

    sg.dll

  2. Add entries in your C:\Windows\system32\drivers\etc\services file.

    The entries look like this:

    esri_92ora 6161/tcp #ArcSDE 9.2 - Oracle

    esri_92sql 6161/tcp #ArcSDE 9.2 - SQLServer 2005

    esri_sde 5151/tcp #ArcSDE 9.1- Oracle

    esri_sde_ss 5152/tcp #ArcSDE 9.2 - SQLServer

  3. If you have trouble connecting, add a new line in your C:\Windows\system32\drivers\etc\hosts file.

    The line looks like this:

    192.168.0.100 arcsdehost

To set up your system for ArcSDE 9.1 (or if you use the 9.2 client and you access the ArcSDE 9.1 server)

  1. Install the following DLL files on the computer on which you run AutoCAD Map 3D.

    Copy the files to the directory in which the ArcSDE provider is installed. Usually, the directory is C:\Program Files\AutoCAD Map 3D 2010\FDO\bin

    pe91.dll

    sde91.dll

    sg91.dll

  2. Add entries in your C:\Windows\system32\drivers\etc\services file.

    The entries look like this:

    esri_92ora 6161/tcp #ArcSDE 9.2 - Oracle

    esri_92sql 6161/tcp #ArcSDE 9.2 - SQLServer 2005

    esri_sde 5151/tcp #ArcSDE 9.1- Oracle

    esri_sde_ss 5152/tcp #ArcSDE 9.2 - SQLServer

  3. If you have trouble connecting, add a new line in your C:\Windows\system32\drivers\etc\hosts file.

    The line looks like this:

    192.168.0.100 arcsdehost

To bring in features from ESRI ArcSDE

  1. Make sure your feature source is set up correctly. For a list of issues, refer to the Readme.
  2. In Display Manager, click DataConnect To Data.
  3. In the Data Connect window, select Add ArcSDE Connection in the Data Connections By Provider list.
  4. Under Connection Name, type a name for this connection.

    You can give the connection any name you like. This name appears in Map Explorer as the name of the feature source.

  5. Under Server Name and Instance Name, enter the information for the ArcSDE database. If you do not know the name, check with your System Administrator.
  6. Click Login.
  7. In the User Name & Password dialog box, enter your user name and password.

    Optionally, select Remember Password if you want AutoCAD Map 3D to log you in whenever you open this drawing.

  8. Click OK.
  9. In Data Connect, under Data Store, enter the database name. If you do not know this name, check with your System Administrator.

    To select from a list of databases, click the down arrow. AutoCAD Map 3D connects to the specified server and instance and lists the available databases. If you set up your hosts and services files as described, use these names. For example, specify arcsdehost\esri_sde_nv, and not the values.

  10. Optionally, select a version of the database.
  11. Click Connect.
  12. In the feature class list, select the feature classes to include in the map.

    If this feature source contains only a single feature class, that feature class is selected automatically. If it contains multiple feature classes, you can right-click any of them and select Select All or Select None.

  13. Click Add To Map.

    To bring in a subset of the data, click the down arrow and select Add To Map With Query. To filter data after you’ve added the data to your map, see Filtering Feature Layers.

Features from the selected feature classes appear in your map.

If you need additional properties related to this data, you can connect additional data to a feature source layer using a join.