OpenSpirit Data Connection

Shared Configuration

dataconnection.png      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.

note.gif      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.

 

Configuration

OpenSpirit Data Connection Configuration Fields

Field Global Var? Optional? Description
Name No No User assigned name given to data connection
Description No Yes User assigned description (optional)
OpenSpirit Connection No N/A

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 Yes No OpenSpirit data source type (e.g. GeoFrame, OpenWorks R5000, Kingdom, PPDM, Petra, etc.)
Data Source Yes No Specific data source for selected store type  
Project Yes No Specific project within data source (for those data store types that support projects)
Coordinate Reference System No Yes 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 Yes The unit to use on the vertical axis when making a compound (e.g. 3d) CRS.  
Unit Catalog No Yes The Unit Catalog to select a unit system from (e.g. POSC, GeoFrame, OpenWorks etc.).
Unit System No Yes 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 Yes 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 Yes Yes 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