To Bring In Features from ArcSDE

You can connect through ArcSDE to an underlying Oracle or SQL Server database.

For ArcSDE versions 9.1 to 10, please use service details. For versions 10.1 and 10.2, please use Direct Connect.

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

    Copy the files to the directory in which the ArcSDE provider is installed. Usually, the directory is C:\Program Files\AutoCAD Map 3D 2019\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 toolset.

    Copy the files to the directory in which the ArcSDE provider is installed. Usually, the directory is C:\Program Files\AutoCAD Map 3D 2019\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. In Display Manager , click DataConnect To Data.
  2. In the Data Connect window, select Add ArcSDE Connection in the Data Connections By Provider list.
  3. Under Connection Name, type a name for this connection.
  4. Under Server Name and Instance Name, enter the information for the ArcSDE database.
  5. Click Login.
  6. In the User Credentials dialog box, specify the login credentials to use to log into this data store.
    • If you use SQLServer as your underlying relational database management system and want to use your Windows Authentication credentials, select Windows Authentication and click Login.
    • To use your ArcSDE login credentials, enter your user name and password and click Login. (If you use SQL Server, ArcSDE will pass your credentials to SQL Server.)
  7. Click OK.
  8. In Data Connect, under Data Store, enter the database name.

    To select from a list of databases, click the down arrow. AutoCAD Map 3D toolset 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.

  9. Optionally, select a version of the database.
  10. Click Connect.
  11. 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 do either of the following:

    • Right-click the schema entry and select Select All or Select None.
    • Expand the schema entry and select the feature classes to add.

      If a feature class contains multiple geometry types, and you select the feature class itself, all geometries are added. To add a subset of geometries, hold your cursor over the feature class name to see the Show Geometry button. Click Show Geometry to see each geometry as a separate choice. Select the ones you want. Each selected geometry is added to map as a separate Display Manager layer.

  12. Verify that the coordinate systems are correct. You can change an incorrect coordinate system if necessary.
  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 To Filter Feature Layers.

To set up a direct connection to the underlying database

  1. Set up connections to the underlying databases.

    For an Oracle database:

    • Install the Oracle client software on the client machine where you run AutoCAD Map 3D toolset.
    • Open the Oracle port (for example, 1521) on the database machine firewall.
    • Use the Oracle Net Manager tool to set up a tnsnames entry for the target database (or update tnsnames.ora manually).
    • Test your connection to the target database using SQL Plus.

    For a SQL Server database:

    • Install the SQL Native client software on the client machine where you run AutoCAD Map 3D toolset.
    • Open the SQL Server port (for example, 1433) on the database machine firewall.
    • Set the target SQL Server database to support remote connect.
    • Test your connection to the target database using SQL Server Management Studio.
  2. Copy additional DLL files into the bin\fdo directory.

    Because the connection does not use the separate ArcSDE server process, the client needs additional ArcSDE libraries. These DLL files are available in the ArcSDE SDK.

    For an Oracle database, copy the following DLL files. For ArcSDE 9.3:

    • gsrvrora11g93.dll or gsrvrora10g93.dll, depending on whether the Oracle client is 10gr2 or 11g. (This depends on the Oracle client version and not the Oracle server version.)
    • sdeora11gsrvr93.dll or sdeora10gsrvr93.dll
    • xerces-c_2_7.dll
    • icuuc22.dll
    • icudt22l.dll

    For ArcSDE 10.1:

    • gsrvrora11g101.dll
    • sdeora11gsrvr101.dll
    • xerces-c_2_7.dll
    • icuuc44.dll
    • icudt44dll

    For a SQL Server database, copy the following DLL files. For ArcSDE 9.3:

    • gsrvrsql93.dll
    • sdesqlsrvr93.dll
    • xerces-c_2_7.dll
    • icuuc22.dll
    • icudt22l.dll

    For ArcSDE 10.1:

    • gsrvrora11g101.dll
    • sdesqlsrvr101.dll
    • xerces-c_3_1.dll
    • icuuc44.dll
    • icudt44.dll
  3. Adjust the connection parameters.

    For an Oracle database, set the following parameters:

    • Server name: Specify the server name or the IP address.
    • Instance name: Enter sde:oracle10g or sde:oracle11g, depending on the version of Oracle on the client.
    • User name: Specify the user name that is valid on the Oracle server.
    • Password: Enter <password>@<OracleSID> where OracleSID is the SID configured in the client in step 1.
    • Datastore: Enter the datastore name manually, for example, sde.
    • Version: Enter the version manually. It defaults to the root version if you do not specify the version.

    For a SQL Server database, set the following parameters:

    • Server name: Specify the server name or the IP address.
    • Instance name: If you use the default instance of MSSQLSERVER, enter sde:sqlserver:<servername>. Otherwise, enter sde:sqlserver:<servername>\<instance_name>.
    • User name/password: Specify the user name that is valid for the SQL Server database.
    • Datastore: Enter the datastore name manually, for example, sde.
    • Version: Enter the version manually. It defaults to the root version if you do not specify the version.

Related Concepts