Data Connections
Connection
| Id |
INTEGER |
Unique record identifier. |
| Guid |
TEXT |
System globally unique identifier. |
| Name |
TEXT |
Name of the connection/group. |
| Type |
INTEGER |
0 - Group, 1 - Connection (additional data in ConnectionEx). |
| Connection_Id |
INTEGER |
Link to parent Connection record. |
| Description |
TEXT |
A description of what this connection/group is for. |
ConnectionEX
| Id |
INTEGER |
Unique record identifier and foreign key to Connection record. |
| ConnectionType |
TEXT |
The DBMS type for this connection (“ADO”, “Oracle”, “MSSQL”, etc.) |
| SqlFormat |
TEXT |
Expected data format for all SQL operations. |
| Script |
TEXT |
The SQL script to execute when this connection is opened. |
| Note |
TEXT |
Optional note describing this connection. |
| CreatedBy |
TEXT |
User who created the connection. |
| CreatedDate |
DATETIME |
Date and time of creation. |
| ModifiedBy |
TEXT |
User who last modified the connection. |
| ModifiedDate |
DATETIME |
Date and time of modification. |
Connection_MapsNode
Clustered installations only. Associates a data connection with a specific MAPS server node.
| Connection_Id |
INTEGER |
Foreign key to ConnectionEx record. |
| MapsNode_Id |
TEXT |
Foreign key to MapsNode record. |
ConnectionPropertyName
The names of the properties stored in ConnectionPropertyValue
| ID |
INTEGER |
Unique record identifier. |
| Name |
TEXT |
Name of the property (Ex: ConnectString, LockType, CursorType, CursorLocation, VariableSubstitutions, etc.). |
ConnectionPropertyValue
Contains various properties associated with each data connection
| Connection_Id |
INTEGER |
Foreign key to Connection record. |
| Name_Id |
INTEGER |
Foreign key to ConnectionPropertyName record. |
| Value |
TEXT |
Value of the property. |
ConnectionQueue
| Id |
INTEGER |
Unique record identifier. |
| Connection_Id |
INTEGER |
Foreign key to ConnectionEx record. |
| DayOfWeek |
TEXT |
The day of week this queue rule applies to. If empty then it is the "other" record. |
| StartTime |
TIME |
Starting time. |
| EndTime |
TIME |
Ending time. |
| MaximumQueries |
INTEGER |
The maximum number of queries to execute in this time range: -1 (auto), 0 (none), 1 - 1024. |
ConnectionRestEndpoint
| Id |
INTEGER |
Unique record identifier. |
| Connection_Id |
INTEGER |
Foreign key to ConnectionEx record. |
| SchemaName |
TEXT |
The name of the schema. |
| URI |
TEXT |
The URI relative to the base URI in ConnectionEx. |
| Data |
TEXT |
The schema definition. |
| ActivityDate |
DATETIME |
The last time this record was updated. |
| XPath |
TEXT |
The object path to define tables in the schema definition. |
ConnectionRule
| Id |
INTEGER |
Unique record identifier. |
| Connection_Id |
INTEGER |
Foreign key to ConnectionEx record. |
| Rule |
INTEGER |
Method of connection used:
0 – Do not connect
1 – Use username/password in connection script
2 – Use the MAPS username/password
3 – Use the username/password in this record |
| UserName |
TEXT |
Data connection username (if RULE is 3). |
| Password |
TEXT |
Data connection password (if RULE is 3). |
| Script |
TEXT |
The SQL script to execute when this rule is used during log on. |
| Flags |
INTEGER |
Binary encoded flags that control what is allowed with the connection. |
ConnectionRulePropertyName
| Id |
INTEGER |
Unique record identifier. |
| Name |
TEXT |
Name of the property. |
ConnectionRulePropertyValue
| ConnectionRule_Id |
INTEGER |
Foreign key to ConnectionRule record. |
| Name_Id |
INTEGER |
Foreign key to ConnectionRulePropertyName record. |
| Value |
TEXT |
Value of the property. |
ConnectionRule_User
| ConnectionRule_Id |
INTEGER |
Foreign key to ConnectionRule record. |
| User_Id |
INTEGER |
Foreign key to User record. |
ConnectionRule_Group
| Group_Id |
INTEGER |
Foreign key to Group record. |
| ConnectionRule_Id |
INTEGER |
Foreign key to ConnectionRule record. |
Xqp
| Id |
INTEGER |
Unique record identifier. |
| Name |
TEXT |
Name of the XQP. |
| Guid |
TEXT |
The globally unique ID for this XQP. |
| Description |
TEXT |
Description of the XQP. |
| ModuleName |
TEXT |
Filename of the XQP with full or relative path. |
XqpData
| Xqp_Id |
INTEGER |
Foreign key to Xqp record. |
| Data |
BYTEA |
BLOB data for the Xqp files. |
| Hash |
TEXT |
Hash value of "data". |
WebDataConnectorData
Clustered installations only. Stores the data returned by a Cloud Connector to ensure that any changes are propagated to each server node.
| Id |
INTEGER |
Unique record identifier |
| Connection_Id |
INTEGER |
Foreign key to Connection record. |
| Data |
BINARY |
The data returned by the Cloud Connector. |
| Hash |
TEXT |
Hash value of the data. |