Bringing In Features from Oracle
Concept Procedure Quick Reference

To bring in features from Oracle

  1. Make sure that your feature source is set up correctly.
  2. In Display Manager, click DataConnect To Data.
  3. In the Data Connect window, select Add Oracle 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 Service Name, enter the service name for the Oracle data store. If you do not know this name, check with your System Administrator.
  6. Click Login.
  7. In the User Name & Password dialog box, enter your Oracle user name and password. If your organization uses Windows authentication to log in to Oracle, select Use Windows Authentication.

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

  8. Under Data Store, enter the data store name. If you do not know this name, check with your System Administrator.

    To select from a list of data stores, click the down arrow.

    NoteIf the data store is not in the list, it may not use a AutoCAD Map 3D schema. Select Show All Data Stores to add these to the list. AutoCAD Map 3D creates a mapping to use these data stores with AutoCAD Map 3D.
  9. Optionally, select a version of the data store.
  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 right-click any of them and select Select All or Select None.

  12. 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. You can style, theme, and edit the features.

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

To use AutoCAD Map 3D 2010 to access FDO data stores that were created in AutoCAD Map 3D 2007 and earlier

  1. Verify that you have the privileges required to execute the ALTER TABLE request.
  2. In the command line, enter the following:

    sqlplus <datastorename>/<yourpassword>@<tnsServiceName>