OpenSpiritDataConnection (Shared Configuration)
An OpenSpirit Data Connection is a shared resource. It defines a connection to a project or data source that is accessed via an OpenSpirit data connector. It may then be used by an OpenSpirit Query, Insert, Update, Delete, or SQL Direct activity. In addition to defining the data source or project the OpenSpirit Data Connection also optionally allows you to define the desired coordinate and unit system that data will be returned in from a Query activity. In order to create an OpenSpirit Data Connection you must have one or more configured data sources in the OpenSpirit runtime installation.
The fields on the configuration panel will be read-only until a connection to OpenSpirit has been made. Clicking on the button next to the "OpenSpirit Connection" label will connect to OpenSpirit. A connection to OpenSpirit only needs to be made once after Designer is started. If a saved process definition is opened and a connection to OpenSpirit has not been made, the information will be displayed in a read-only form.
OpenSpirit Data Connection Configuration
This section has the following fields
Field | Literal Value/Module Property? | Description |
---|---|---|
OpenSpirit Connection | No | Clicking on this button makes a connection to OpenSpirit. If there is no connection, the icon will appear red. If there is a connection, the icon will appear green. A connection only needs to be made once after Designer is started. The remaining fields will be read-only until a connection is made to OpenSpirit. |
Data Source Type | No | OpenSpirit data source type (e.g. GeoFrame, OpenWorks R5000, Kingdom, PPDM, Petra, etc.) |
Data Source | No | Specific data source for selected store type. |
Project | No | Specific project within data source (for those data store types that support projects). |
Coordinate Reference System | No | Coordinate system to request data in for any Query activity that uses this data connection. If specified then any queried geometry columns will be returned in this CRS. If not specified then geometry is returned in the data source's CRS. Note: when a CRS is specified a datum shift is also specified so datum shifts may be performed if required. A CRS is selected using the Coordinate System Selector. |
Coordinate System Vertical Unit | No | The unit to use on the vertical axis when making a compound (i.e. 3d) CRS. |
Unit Catalog | No | The Unit Catalog to select a unit system from (e.g. POSC, GeoFrame, OpenWorks etc.). |
Unit System | No | The unit system (e.g. Metric, Imperial, US Field, etc.) to use in the Query activity to assert the preferred units for columns that are quantities with a specified measure (e.g., TotalDepth is a length vertical). If no system is specified then data is returned in the units as stored in the data source. |
Server Timeout | No | The data connector time out period in minutes. The data connector will shut itself down after the last client connection has been closed. It will then start up again if later required to do so. |
OpenSpirit User Account | No | The OpenSpirit user account to use to determine the host and account preferences to use when running the OpenSpirit data connector process. If no user account is specified then the account that is running Designer will be used at design time and the account that is running Hawk in deployment settings will be used to run the data connector. In order to assert which user account to use the account running Designer or Hawk must have been granted OpenSpirit admin rights. This is done via the OpenSpirit User Manager. |
Connection Properties | No | Properties used when creating an OpenSpirit connection. Connection properties may be overridden by properties specified in the query context of individual query activities. |