Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How to Add Database Connection String Variable in Managed Workspace
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • -OpenPlant Modeler v8i
          • +Component - OpenPlant Modeler
          • +Drawing Generation- OpenPlant Modeler
          • +Errors, Logs, Messages, Crashes - OpenPlant Modeler
          • +Import/Export- OpenPlant Modeler
          • +Installation - OpenPlant Modeler
          • OpenPlant HVAC-OpenPlant Modeler
          • OpenPlant Modeler [FAQ]
          • +OpenPlant Specification Generator
          • +ProjectWise - OpenPlant Modeler
          • -Properties - OpenPlant Modeler
            • -Fundamentals of External Database Query in OpenPlant Modeler
              • How to Add Database Connection String Variable in Managed Workspace
              • Populate Service Code in Pipeline Based on Service Description
            • How to Add Component's Facing Property in Element Information dialog
            • How to Add Inch Sign with Nominal Diameter in Pipeline Tag
            • How to Add New/Existing Property to Nozzle Manager Dialog in OpenPlant Modeler
            • How to Add/Remove Properties in Flyover Hints
            • How to Associate the Specification Based on Service
            • How To Change Attributes of Pipe Based on Component State Using Named Expression
            • How to Change the Units of Measurement for ECProperty in OPM
            • How To Create and Populate Service Description Property on Piping Component Element Information
            • How to Exclude Plant Area Property From Consistency Checker
            • How to get Joint Type Information on Gaskets
            • How to Identify Inconsistency of Component Data with Consistency Checker
            • How to Map Spec Field with OpenPlant Modeler Property
            • How to Modify Supports in Bulk in OpenPlant Modeler
            • How to Move Properties Between Categories
            • How to Populate Header Nominal Diameter for Tap Connection in OpenPlant Modeler
            • How to Prefix 'DN' with Pipe Size in OPM
            • How to Set Default Value on EC Property
            • How to Show Nominal Diameter in Three-Digit Format for Support Tag Name
            • How to Update Bolts and Gaskets in OpenPlant Modeler
            • How to Update Pipeline Tag Name or Component Property After any Changes in Schema
            • To Modify Equipment Tag For FreeForm Nozzle in OpenPlant Modeler
            • To Modify Pipeline Tag Name in OpenPlant Modeler
            • To Obtain Arc Length for Pipe Bends in OpenPlant Modeler
          • +Release Notes - OpenPlant Modeler
          • +Schema - OpenPlant Modeler
          • +Settings/Attributes - OpenPlant Modeler
          • +Structural Modeling Components (SMC)- OpenPlant Modeler
          • +Tasks - OpenPlant Modeler
          • +Training - OpenPlant Modeler
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
        • How to get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
        • How to Package WorkSpace to be Shareable to Users for OpenPlant Projects
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!

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

    How to Add Database Connection String Variable in Managed Workspace

    Applies To
    Product(s): OpenPlant Modeler
    Version(s): 08.11.09.XXX (SS5) | 08.11.11.XX (SS6)
    Environment: Windows 7/8.1/10 (64 bit)
    Area: Properties
    Subarea: External Database Query
    Original Author: Harpreet Singh, Bentley Product Advantage Group

    Background

    When working with standalone mode, user has to define variable in PCF file for connection string and path of database file but when you are working in managed environment, you need to define that variable in project CSB and database file should also be in the managed workspace. This article will explain how this variable can be defined in managed environment.

    This is how variable is defined in PCF file on local drive.

    Solution

    Users have to give ProjectWise path to locate the database file through separate variable therefore in same variable user can't have connection string as well as ProjectWise path. In order to do that, user has to use either default variable or create their own variable. In this example, we will use the existing variable (_USTN_PROJECTDATASET) to define the database file path in managed environment.

    Below is connection string variable defined in managed workspace

    This variable is resolved by ProjectWise as pw:\\%Server_Name%:DS_NAME\Documents\Workspaces\OPM_Workspace\Projects\Query_TestProject\Dataset\settings\ which is the folder highlighted below.

    Comments or Corrections?

    Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

    • OpenPlant Modeler
    • Connection String
    • OPM
    • DB Query
    • 08.11.11.xx
    • ProjectWise
    • Managed Workspace
    • Configuration Variable
    • Database
    • Share
    • History
    • More
    • Cancel
    • Harpreet Singh Created by Harpreet Singh
    • When: Tue, Nov 22 2016 7:47 AM
    • Harpreet Singh Last revision by Harpreet Singh
    • When: Tue, Nov 22 2016 7:50 AM
    • Revisions: 2
    • 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