Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenCities Map
  • Product Communities
  • Geospatial
  • OpenCities Map
  • Cancel
OpenCities Map
OpenCities Map Wiki - Automatically connect to a graphical source
    • Sign In
    • -OpenCities Map Wiki
      • -OpenCities Map
        • - End of Support for Bentley Map V8i (SELECTseries) products
        • +Release Information
        • +Installation Information
        • +Getting Started
        • +Administration
        • +General Topics
        • -Geospatial Administrator
          • - About Expand Variables
          • - Automatically execute commands upon file open [XFM project]
          • - Automatically connect to a graphical source
          • - Base Source Directory and Files Node
          • - Base Source Directory configuration
          • - Built in XFM properties
          • - Capture point feature coordinates with two examples
          • - Change property order using text editor
          • - Changing project and workset information
          • - Concatenate properties to populate new property using Property Watcher
          • - Create a geospatial schema
          • - Create a new schema recommended workflow
          • - Customize Command Manager with help from Excel
          • - Customize dialogs
          • - Customize Operations to show property based on criteria
          • - Date Time Property Show None to set dates to null
          • - Decimal Precision in Analyze XFM Feature Results
          • - Defining polygons with holes or islands
          • - Domain list initial values
          • - Domain list width (Calculate List Width)
          • - Domain list width (Form View width)
          • - Feature Collection and Collection Name Property
          • - Files node in User Workspace
          • - Fix Cannot access a disposed object error
          • - Generate workspace from command line
          • - Increment property values
          • - Multiline text for PBA
          • - Number  properties and setting decimal places for data entry
          • - Open schema via desktop shortcut
          • - Property Watcher on an empty value
          • - Property Watcher to compute values
          • - Property Watcher to read Col2 of a Domain List
          • - Property Watcher to set true or false
          • - Property Watcher to update a date property
          • - Property Watchers to drive domain lists
          • - Replace text during Shapefile importing
          • - Replace text in cells using PBA with two examples
          • - Rounding numbers
          • - Set Area and Perimeter to Read Only
          • - Shortcut arguments –ws , -wr, -wu
          • - Shortcut Target path
          • - Sort properties by Display Name
          • - Store Last Value to define property fields for new feature placement
          • - Tabbed dialogs
          • - Text and Text Node Justification
          • - Text Annotation Subfeature
          • - Text features from PBA
          • - Text size settings
          • - Update property when Split/Merge used
          • - UpdatedBy and UpdatedDate properties
          • - Using raster images as a graphical source
          • - Value Col Name vs Edit Col Name
          • - Workspace location V8i compared to CONNECT Edition
        • +Feature Definitions and Inference Rules
        • +Interoperability
        • +Spatial Databases
        • +Spatial Analysis
        • +3D Geospatial
        • +Geographic Coordinate Systems
        • +Troubleshooting
        • +Freeware - Utilities - Applications - Programs
        • +Advanced Map Finishing
      • OpenCities Map Ultimate for Finland CONNECT Edition x64 (SES)
      • OpenCities Map Ultimate for Finland CONNECT Edition - Suomi
      • Bentley Descartes
      • +Other Geospatial Products

     
     Questions about this article, topic, or product? Click here. 

    - Automatically connect to a graphical source

    It is possible to set up OpenCities Map so that every time a DGN is opened, a connection is established to a graphical source such as Oracle Spatial, SQL Server Spatial, PostGIS, OGC WFS, or Esri File Geodatabase

    To do this, first define the named graphical source in your project schema. 

    For example, the following illustrates a named connection to an Oracle database:Open

    Then select the Macros node of the User Workspace, and add the following configuration variable:  MS_GEOINITCMD

    Set the value of the variable to execute the following key-in:

    GDI CONNECT GRAPHICALSOURCE  name=graphicalSourceName user=userName password=password

     

    Save and export your changes.  The next time the workspace is run and a file is opened, a live connection to the graphical source will be automatically established.  This can be seen by navigating to the Connections tab of the Map Interoperability dialog as shown below.

     


    Notes:

    - Ensure there are no spaces before and after the = sign in the key-in.

    - The user and password are visible to others.

    - For SQL Server and Esri File Geodatabase, the user and password are not required.  Simply use:  GDI CONNECT GRAPHICALSOURCE

    • Oracle
    • Graphical Source
    • Spatial
    • PostGIS
    • Geospatial Administrator
    • SQL Server
    • Database
    • Share
    • History
    • More
    • Cancel
    • Anupama Joshi Created by Anupama Joshi
    • When: Thu, Jan 14 2016 4:37 AM
    • Nelson Hobdell Last revision by Bentley Colleague Nelson Hobdell
    • When: Tue, Sep 27 2022 6:18 PM
    • Revisions: 11
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies