To Bring in Features from PostgreSQL/PostGIS

Note: Before connecting to a PostgreSQL database, make sure that the library files such as libpq.dll, libeay32.dll, and ssleay32.dll, are available on the system where AutoCAD Map 3D toolset is installed. Depending on the version of the installed PostgreSQL/PostGIS, you may need to copy libcrypto-1_1-x64.dll and libssl-1_1-x64.dll instead of libeay32.dll and ssleay32.dll. The location of the library files should be added to the PATH environment variable of your system.
  1. In Display Manager, click DataConnect To Data.
  2. In the Data Connect window, select Add PostgreSQL Connection in the Data Connections By Provider list.
  3. Under Connection Name, type a name for this connection.
  4. Enter the Service Name and click Login.

    The service name is set when you install the PostgreSQL server.

  5. In the User Credentials dialog box, specify the login credentials to use to log into this data store.
  6. In Data Connect, 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. AutoCAD Map 3D toolset connects to the specified server and instance and lists the available data stores.

  7. Click Connect.
  8. 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 choose 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.

  9. Verify that the coordinate systems are correct. You can change an incorrect coordinate system, if necessary.
  10. Click Add To Map.