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.

General

The General section has the following fields.

Field Description
Name The name to be displayed as the label for the resource.
Description A short description of the resource.

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.