Connection Property Reference
Every configurable property declared by all 31 Infohub data source connectors.
Infohub ships 31 data source connectors. This page lists the configurable properties each one declares in this release.
Properties are grouped by the target they apply to:
- Connection — set once on the connection itself
- Measure — set per measure, on top of the connection
- EventTrigger — set on an event trigger that reads this source
- EventAttribute — set on an event attribute that reads this source
Properties are declared by the plugin, not by Infohub. Each connector declares its own property set, so a property that exists for one historian may not exist for another even where the concept is the same. When a property below is not visible in Flow Config, it is usually because another property's value hides it — several connectors show or hide fields depending on the mode you select.
Connectors at a glance#
| Connector | Properties declared |
|---|---|
| Apache Kafka | 14 |
| AWS Timestream | 17 |
| Canary Historian | 26 |
| Canary Historian V24 | 24 |
| eWon | 20 |
| Flow Historian Simulator | 18 |
| Ignition Historian | 23 |
| InfluxDB | 23 |
| Metering Online | 9 |
| Microsoft Excel | 3 |
| Microsoft SQL Database | 22 |
| MQTT | 13 |
| MySQL Database | 20 |
| Netilion | 20 |
| OPCHDA Historian | 20 |
| OPCUA | 9 |
| OPCUA Historian | 22 |
| Oracle Database | 21 |
| PostgreSQL Database | 20 |
| Siemens Mindsphere | 8 |
| Siemens Process Historian | 23 |
| Snowflake | 25 |
| Telegraf | 1 |
| Thin Manager | 7 |
| Timebase Historian | 11 |
| Web Service | 40 |
| Wonderware Historian | 26 |
| Wonderware Historian 2017 | 27 |
| Wonderware InTouch | 15 |
| Wonderware MES | 48 |
| Wonderware Online | 24 |
Apache Kafka#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Purge Age | Whole number | Connection | |
| Kafka Server | Text | Connection | |
| Kafka Port | Whole number | Connection | |
| Kafka GroupID | Text | Connection | |
| Security | Choice | Connection | |
| Username | Text | Connection | |
| Password | Text | Connection | Stored encrypted |
| Namespace Delimiter | Text | Connection | |
| Timestamp Placeholders | Text | Connection | |
| Event Start Placeholders | Text | Connection | |
| Event End Placeholders | Text | Connection | |
| Timestamp Format | Choice | Connection |
Connection
| Property | Type | Applies to |
|---|---|---|
| Security Mechanism | Choice | Connection |
| SslCaLocation | Text | Connection |
AWS Timestream#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Database | Text | DataSource | Connecting database name. |
| Access Key ID | Text | DataSource | Stored encrypted. Username to connect to the database. |
| Secret ID | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Timeout (seconds) | Whole number | DataSource | Timeout specified between connections. |
| Definition | Editor | DataSource | Simulator file definition. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| DateTime Precision | Choice | DataSource | The precicion to use for DateTime fields. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | Tag | Query string used to retrieve data from the Excel file. |
| Aggregation | Choice | Measure | Define the aggregation type. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventTrigger | Query string used to retrieve triggers from the SQL database. </summary |
| Query Period | Choice | EventTrigger |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventAttributeSegment | Query string used to retrieve attribute values from the Excel file. |
Enumeration Properties
| Property | Type | Applies to |
|---|---|---|
| Query | Text | Enumeration |
Canary Historian#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Server | Text | Connection | Connecting server name. |
| Historian Type | Choice | Connection | Local or Online Historian |
| Port | Whole number | Connection | Port of the historian to connect to webservice. |
| Username | Text | Connection | Username to connect to the database. |
| Password | Text | Connection | Stored encrypted. Password to connect to the database. |
| Maximum Concurrent Connections | Whole number | Connection | Maximum number of concurrent connections allowed for a connector. |
| Tag | Text | Connection | Tag Name property used to return Measure Values |
| Forward Overlap | Whole number | Measure | |
| Backward Overlap | Whole number | Measure |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Connection | Define the aggregation type. |
| Detect SF | Yes/No | Connection | |
| Scaling Factor | Number | Connection | Used to scale or multiple a given value. |
| Rollover | Number | Connection | Define the Rollover. |
| Deadband | Number | Connection | Define the Rollover Deadband. |
| State Comparator | Choice | Connection | Determine Time In State aggregation conditions. |
| State | Number | Connection | Determine Aggregation conditions. |
| Filter Tag | Text | Connection | Define the filter tag. |
| Filter Comparator | Choice | Measure | Define the filter comparator. |
| Filter Value | Number | Connection | Define the filter value. |
| Filter Default Result | Number | Connection | Define the default filter result. |
| Expression | Editor | Connection | Determine the custom calculation config aggregation. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | Connection | Determine trigger type. |
| For Period (s) | Number | Connection | |
| Condition | Choice | Connection | Define the interpolation type. Determine comparator type. |
| Condition Value | Number | Connection | Determine trigger value. |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Type | Choice | Connection | Determine attribute value type. |
Canary Historian V24#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Server | Text | Connection | Connecting server name. |
| Security Type | Choice | Connection | Local or Online Historian |
| Identity Api Token | Text | Connection | Username to connect to the database. |
| Maximum Concurrent Connections | Whole number | Connection | Maximum number of concurrent connections allowed for a connector. |
| Tag | Text | Connection | Tag Name property used to return Measure Values |
| Forward Overlap | Whole number | Measure | |
| Backward Overlap | Whole number | Measure |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Connection | Define the aggregation type. |
| Detect SF | Yes/No | Connection | |
| Scaling Factor | Number | Connection | Used to scale or multiple a given value. |
| Rollover | Number | Connection | Define the Rollover. |
| Deadband | Number | Connection | Define the Rollover Deadband. |
| State Comparator | Choice | Connection | Determine Time In State aggregation conditions. |
| State | Number | Connection | Determine Aggregation conditions. |
| Filter Tag | Text | Connection | Define the filter tag. |
| Filter Comparator | Choice | Measure | Define the filter comparator. |
| Filter Value | Number | Connection | Define the filter value. |
| Filter Default Result | Number | Connection | Define the default filter result. |
| Expression | Editor | Connection | Determine the custom calculation config aggregation. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | Connection | Determine trigger type. |
| For Period (s) | Number | Connection | |
| Condition | Choice | Connection | Define the interpolation type. Determine comparator type. |
| Condition Value | Number | Connection | Determine trigger value. |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Type | Choice | Connection | Determine attribute value type. |
eWon#
Connection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Account | Text | DataSource | |
| Username | Text | DataSource | |
| Password | Text | DataSource | Stored encrypted |
| Endpoint Key | Text | DataSource | Stored encrypted |
| Maximum Concurrent | Whole number | DataSource | |
| Backward Duration | Number | DataSource |
MeasureConnection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | |
| State | Number | Measure | |
| Scaling | Number | Measure |
Custom Calculation
| Property | Type | Applies to |
|---|---|---|
| Expression | Editor | Measure |
EventTriggerConnection
| Property | Type | Applies to |
|---|---|---|
| Trigger | Choice | EventTrigger |
| Condition | Choice | EventTrigger |
| Condition Value | Number | EventTrigger |
General
| Property | Type | Applies to |
|---|---|---|
| eWon ID | Whole number | Measure |
| eWon Name | Text | Measure |
| Tag ID | Whole number | Measure |
| Tagname | Text | Measure |
Flow Historian Simulator#
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Connection | Define the aggregation type. |
| Scaling Factor | Number | Connection | Used to scale or multiple a given value. |
| Rollover | Number | Connection | Define the Rollover. |
| Deadband | Number | Connection | Define the Rollover Deadband. |
| State Comparator | Choice | Connection | Determine Time In State aggregation conditions. |
| State | Number | Connection | Determine Aggregation conditions. |
| Filter Tag | Text | Connection | Define the filter tag. |
| Filter Comparator | Choice | Connection | Define the filter comparator. |
| Filter Value | Number | Connection | Define the filter value. |
| Filter Default Result | Number | Connection | Define the default filter result. |
| Expression | Editor | Connection |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | Connection | Determine trigger type. |
| For Period (s) | Number | Connection | |
| Condition | Choice | Connection | Determine comparator type. |
| Condition Value | Number | Connection | Determine trigger value. |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Type | Choice | Connection | Determine attribute value type. |
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Tag | Text | Connection | Tag Name property used to return Measure Values |
| Definition | Editor | Connection | Simulator file definition. |
Ignition Historian#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Database Type | Choice | DataSource | |
| Server | Text | DataSource | Connecting server name. |
| Database | Text | DataSource | Connecting database name. |
| Port | Whole number | DataSource | |
| TimescaleDB | Yes/No | DataSource | Indicates that the PostgreSQL database uses TimescaleDB, enabling driver-specific partition lookup. |
| Gateway Name | Text | DataSource | The Ignition gateway name (from sqlth_drv) used to identify the correct partition table when TimescaleDB is enabled. |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Timeout (seconds) | Whole number | DataSource | Timeout specified between connections. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| Tag | Text | Tag | Tag Name property used to return Measure Values |
| Path | Text | Tag | |
| Type | Text | Tag | Tag Name property used to return Measure Values |
| TagId | Text | Tag | Tag Name property used to return Measure Values |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | Define the aggregation type. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | EventTrigger | Determine trigger type. |
| Condition | Choice | EventTrigger | |
| Condition Value | Number | EventTrigger | |
| Expression | Editor | EventTrigger | Query string used to retrieve triggers from the SQL database. </summary Determine the custom calculation config trigger type. |
InfluxDB#
Connection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Host | Text | DataSource | |
| Organization | Text | DataSource | |
| Bucket | Text | DataSource | |
| Authentication | Choice | DataSource | |
| Username | Text | DataSource | |
| Password | Text | DataSource | Stored encrypted |
| Token | Text | DataSource | Stored encrypted |
General
| Property | Type | Applies to |
|---|---|---|
| Maximum Concurrent Connections | Whole number | DataSource |
| Measurement | Text | Tag |
| Flux Query | Text | Tag |
| Field Key | Editor | Tag |
| Tag Key | Editor | Tag |
| Tag Key Values | Editor | Tag |
Measure Properties
| Property | Type | Applies to |
|---|---|---|
| Flux Query Builder | Choice | Tag |
| Aggregation | Choice | Measure |
EventTriggerConnection
| Property | Type | Applies to |
|---|---|---|
| Trigger | Choice | EventTrigger |
| Condition | Choice | EventTrigger |
| Condition Value | Number | EventTrigger |
MeasureConnection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | |
| State | Number | Measure | |
| Scaling | Number | Measure |
Metering Online#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Username | Text | DataSource | The Username used to log onto Metering Online. |
| Key | Text | DataSource | Stored encrypted. The key supplied to the user by Metering Online. |
| SSL | Choice | DataSource | SSL Enabled or Disabled. |
| Meter Serial | Text | Measure | The serial number of the meter to retrieve data for. |
| Value To Return | Choice | Measure | The value of the reading to return. |
| Max Connections | Whole number | DataSource | Maximum number of concurrent connections allowed to a meter. |
| Open Timeout (sec) | Whole number | DataSource | |
| Send Timeout (sec) | Whole number | DataSource | |
| Receive Timeout (sec) | Whole number | DataSource |
Microsoft Excel#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Excel Workbook File | Text | DataSource | |
| Query | Text | Tag | |
| Query Type | Choice | DataSource | Standard or Wide Query |
Microsoft SQL Database#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | MeasureModifiedData | |
| Server | Text | DataSource | Connecting server name. |
| Database | Text | DataSource | Connecting database name. |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Encryption | Choice | DataSource | SQL connection encryption negotiated with the server (SSMS "Encryption"). |
| Trust Server Cert. | Yes/No | DataSource | Accept the server certificate without validating its chain (SSMS "Trust server certificate"). |
| Certificate Hostname | Text | DataSource | Host name expected in the server certificate when it differs from the server name. |
| Timeout (seconds) | Whole number | DataSource | Timeout specified between connections. |
| Definition | Editor | DataSource | Simulator file definition. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| DateTime Precision | Choice | DataSource | // // The type of data in the database. // The precicion to use for DateTime fields. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | Tag | Query string used to retrieve data from the Excel file. |
| Aggregation | Choice | Measure | Define the aggregation type. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventTrigger | Query string used to retrieve triggers from the SQL database. </summary |
| Query Period | Choice | EventTrigger |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventAttributeSegment | Query string used to retrieve attribute values from the Excel file. |
Enumeration Properties
| Property | Type | Applies to |
|---|---|---|
| Query | Text | Enumeration |
MQTT#
General
| Property | Type | Applies to |
|---|---|---|
| Purge Age | Whole number | Connection |
| MQTT Server | Text | Connection |
| MQTT Port | Whole number | Connection |
| TLS | Yes/No | Connection |
| SSL Protocol | Choice | Connection |
| Certificate Store | Choice | Connection |
| Certificate Name | Text | Connection |
| Ignore Sequence | Yes/No | Connection |
| JSON Payload | Yes/No | Connection |
| Namespace Delimiter | Text | Connection |
Connection
| Property | Type | Applies to |
|---|---|---|
| Quality of Service | Choice | Connection |
| Mqtt Version | Choice | Connection |
| Protocol | Choice | Connection |
MySQL Database#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | MeasureModifiedData | |
| Server | Text | DataSource | Connecting server name. |
| Port | Whole number | DataSource | Port number for the MySQL server. |
| Database | Text | DataSource | Connecting database name. |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Timeout (seconds) | Whole number | DataSource | Timeout specified between connections. |
| Definition | Editor | DataSource | Simulator file definition. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| DateTime Precision | Choice | DataSource | The precicion to use for DateTime fields. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | Tag | Query string used to retrieve data from the Excel file. |
| Aggregation | Choice | Measure | Define the aggregation type. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventTrigger | Query string used to retrieve triggers from the SQL database. </summary |
| Query Period | Choice | EventTrigger |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventAttributeSegment | Query string used to retrieve attribute values from the Excel file. |
Enumeration Properties
| Property | Type | Applies to |
|---|---|---|
| Query | Text | Enumeration |
Netilion#
Connection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Host | Text | DataSource | |
| Authentication | Choice | DataSource | |
| Username | Text | DataSource | |
| Password | Text | DataSource | Stored encrypted |
| Endpoint Key | Text | DataSource | Stored encrypted |
| Headers | Text | DataSource | |
| Cache | Yes/No | DataSource | |
| Maximum Concurrent | Whole number | DataSource |
General
| Property | Type | Applies to |
|---|---|---|
| Device ID | Text | Measure |
| Serial Number | Text | Measure |
MeasureConnection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | |
| State | Number | Measure | |
| Scaling | Number | Measure |
Custom Calculation
| Property | Type | Applies to |
|---|---|---|
| Expression | Editor | Measure |
EventTriggerConnection
| Property | Type | Applies to |
|---|---|---|
| Trigger | Choice | EventTrigger |
| Condition | Choice | EventTrigger |
| Condition Value | Number | EventTrigger |
OPCHDA Historian#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Convert to null | Choice | DataSource | |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| Tag | Text | Tag | Tag Name property used to return Measure Values. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | Define the aggregation type. |
| Scaling Factor | Number | Measure | Measure property used to scale a given value. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
| Filter Tag | Text | Measure | Filter tag property. |
| Filter Comparator | Choice | Measure | Filter comparator property. |
| Filter Value | Number | Measure | Filter value property. |
| Filter Default Result | Number | Measure | Define the default filter result. |
| Expression | Editor | Measure |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | EventTrigger | Determine trigger type. |
| Condition | Choice | EventTrigger | Determine comparator type. |
| Condition Value | Number | EventTrigger | Determine trigger value. |
| Expression | Editor | EventTrigger | Determine the custom calculation config trigger type. |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Type | Choice | EventAttributeSegment | Determine attribute value type. |
| Expression | Editor | EventAttributeSegment | Determine the custom calculation config attribute value type. |
OPCUA#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Purge Age | Whole number | Connection | |
| Port | Text | Connection | Port on which OPCUA connection is avaulable |
| Maximum Concurrent Connections | Whole number | Connection | Maximum number of concurrent connections allowed for a connector. |
| Connection Timeout | Whole number | Connection | Timeout before connection to the OPC UA Server is deemed failed |
| Certificate Name | Text | Connection | Certificate Name issued by the OPC UA and stored in the default certificate path |
| Tag Delimiter | Text | Connection | |
| Tag | Text | Connection | Tag Name property used to return Measure Values. |
Measure Properties
| Property | Type | Applies to |
|---|---|---|
| Sampling Interval | Whole number | Connection |
| Monitoring Mode | Editor | Connection |
OPCUA Historian#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Port | Text | DataSource | Port on which OPCUA connection is avaulable |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| Connection Timeout | Whole number | DataSource | Timeout before connection to the OPC UA Server is deemed failed |
| Certificate Name | Text | DataSource | Certificate Name issued by the OPC UA and stored in the default certificate path |
| Tag | Text | Tag | Tag Name property used to return Measure Values. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | Define the aggregation type. |
| Scaling Factor | Number | Measure | Measure property used to scale a given value. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
| Filter Tag | Text | Measure | Filter tag property. |
| Filter Comparator | Choice | Measure | Filter comparator property. |
| Filter Value | Number | Measure | Filter value property. |
| Filter Default Result | Number | Measure | Define the default filter result. |
| Expression | Editor | Measure |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | EventTrigger | Determine trigger type. |
| Condition | Choice | EventTrigger | Determine comparator type. |
| Condition Value | Number | EventTrigger | Determine trigger value. |
| Expression | Editor | EventTrigger | Determine the custom calculation config trigger type. |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Type | Choice | EventAttributeSegment | Determine attribute value type. |
| Expression | Editor | EventAttributeSegment | Determine the custom calculation config attribute value type. |
Oracle Database#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | MeasureModifiedData | |
| Server | Text | DataSource | Connecting server name. |
| Service | Text | DataSource | Connecting database name. |
| Port | Whole number | DataSource | Port. |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Alternate Schema | Text | DataSource | |
| Timeout (seconds) | Whole number | DataSource | Timeout specified between connections. |
| Definition | Editor | DataSource | Simulator file definition. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| DateTime Precision | Choice | DataSource | The precicion to use for DateTime fields. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | Tag | Query string used to retrieve data from the Excel file. |
| Aggregation | Choice | Measure | Define the aggregation type. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventTrigger | Query string used to retrieve triggers from the SQL database. </summary |
| Query Period | Choice | EventTrigger |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventAttributeSegment | Query string used to retrieve attribute values from the Excel file. |
Enumeration Properties
| Property | Type | Applies to |
|---|---|---|
| Query | Text | Enumeration |
PostgreSQL Database#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | MeasureModifiedData | |
| Server | Text | DataSource | Connecting server name. |
| Database | Text | DataSource | Connecting database name. |
| Port | Whole number | DataSource | Timeout specified between connections. |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Timeout (seconds) | Whole number | DataSource | Timeout specified between connections. |
| Definition | Editor | DataSource | Simulator file definition. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| DateTime Precision | Choice | DataSource | The precicion to use for DateTime fields. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | Tag | Query string used to retrieve data from the Excel file. |
| Aggregation | Choice | Measure | Define the aggregation type. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventTrigger | Query string used to retrieve triggers from the SQL database. </summary |
| Query Period | Choice | EventTrigger |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventAttributeSegment | Query string used to retrieve attribute values from the Excel file. |
Enumeration Properties
| Property | Type | Applies to |
|---|---|---|
| Query | Text | Enumeration |
Siemens Mindsphere#
General
| Property | Type | Applies to |
|---|---|---|
| Tenant Name | Text | DataSource |
| Client ID | Text | DataSource |
| Client Secret | Text | DataSource |
| Asset ID | Text | Measure |
| Aspect Name | Text | Measure |
| Aggregation | Choice | Measure |
| Deadband | Number | Measure |
| State Comparator | Choice | Measure |
Siemens Process Historian#
Connection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Number of Max Hours To Query | Whole number | DataSource | |
| Server | Text | DataSource | |
| Username | Text | DataSource | |
| Password | Text | DataSource | Stored encrypted |
| Timeout (seconds) | Whole number | DataSource | |
| Maximum Concurrent Connections | Whole number | DataSource |
MeasureConnection
| Property | Type | Applies to |
|---|---|---|
| Aggregation | Choice | Measure |
| Tagname | Text | Measure |
| State | Number | Measure |
| State Comparator | Choice | Measure |
| Scaling Factor | Number | Measure |
EventTrigger
| Property | Type | Applies to |
|---|---|---|
| Trigger | Choice | EventTrigger |
| Condition | Choice | EventTrigger |
| Condition Value | Number | EventTrigger |
AttributeValue
| Property | Type | Applies to |
|---|---|---|
| Attribute Value Type | Choice | EventAttributeSegment |
General
| Property | Type | Applies to |
|---|---|---|
| Deadband | Number | Measure |
Filter
| Property | Type | Applies to |
|---|---|---|
| Filter Tag | Text | Measure |
| Filter Comparator | Choice | Measure |
| Filter Value | Number | Measure |
| Filter Default Result | Number | Measure |
CustomCalculation
| Property | Type | Applies to |
|---|---|---|
| Expression | Editor | Measure |
| Expression | Editor | EventTrigger |
| Expression | Editor | EventAttributeSegment |
Snowflake#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | MeasureModifiedData | |
| Account | Text | DataSource | account name. |
| Host | Text | DataSource | Connecting server name. |
| Database | Text | DataSource | Connecting database name. |
| Role | Text | DataSource | Connecting database name. |
| Warehouse | Text | DataSource | |
| Authentication Type | Choice | DataSource | |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Key File Location | Text | DataSource | |
| Key Password | Text | DataSource | Stored encrypted |
| Timeout (seconds) | Whole number | DataSource | Timeout specified between connections. |
| Definition | Editor | DataSource | Simulator file definition. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| DateTime Precision | Choice | DataSource | The precicion to use for DateTime fields. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | Tag | Query string used to retrieve data from the Excel file. |
| Aggregation | Choice | Measure | Define the aggregation type. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventTrigger | Query string used to retrieve triggers from the SQL database. </summary |
| Query Period | Choice | EventTrigger |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Query | Text | EventAttributeSegment | Query string used to retrieve attribute values from the Excel file. |
Enumeration Properties
| Property | Type | Applies to |
|---|---|---|
| Query | Text | Enumeration |
Thin Manager#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Purge Age | Whole number | Connection | |
| Use https | Yes/No | Connection | |
| Security | Choice | Connection | |
| Username | Text | Connection | |
| Password | Text | Connection | Stored encrypted |
| Token | Text | Connection | Stored encrypted |
| Poll Period (s) | Whole number | Connection |
Timebase Historian#
Connection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Host | Text | DataSource | |
| Port | Whole number | DataSource | |
| Use TLS | Yes/No | DataSource | |
| Use Authentication | Yes/No | DataSource | |
| IdP Host | Text | DataSource | |
| IdP Port | Whole number | DataSource | |
| Use TLS (IdP) | Yes/No | DataSource | |
| IdP Client | Text | DataSource | |
| IdP Client Secret | Text | DataSource | Stored encrypted |
| Dataset | Text | DataSource |
General
| Property | Type | Applies to |
|---|---|---|
| Tagname | Text | Tag |
Web Service#
Connection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Host | Text | DataSource | |
| Authentication | Choice | DataSource | |
| Validate Server Certificate | Yes/No | DataSource | |
| Username | Text | DataSource | |
| Password | Text | DataSource | Stored encrypted |
| Endpoint Key | Text | DataSource | Stored encrypted |
| Token url | Text | DataSource | |
| Grant Type | Choice | DataSource | |
| Client Authentication | Choice | DataSource | |
| Consumer Key | Text | DataSource | Stored encrypted |
| Client Secret | Text | DataSource | Stored encrypted |
| Private Key | Text | DataSource | Stored encrypted |
| Private Key ID | Text | DataSource | Stored encrypted |
| Security Algorithms | Choice | DataSource | |
| Client Assertion Type | Choice | DataSource | |
| Claims | Text | DataSource | |
| Authorization Code | Text | DataSource | Stored encrypted |
| Redirect URI | Text | DataSource | |
| Refresh Token | Text | DataSource | Stored encrypted |
| Scope | Text | DataSource | |
| Headers | Text | DataSource | |
| Cache | Yes/No | DataSource | |
| Cache Duration | Whole number | DataSource | |
| Maximum Concurrent | Whole number | DataSource |
General
| Property | Type | Applies to |
|---|---|---|
| Endpoint | Text | Measure |
| Data path | Text | Measure |
| Value path | Text | Measure |
| Quality path | Text | Measure |
| Timestamp path | Text | Measure |
| Timestamp unit | Choice | Measure |
MeasureConnection
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | |
| State | Number | Measure | |
| Scaling | Number | Measure |
Custom Calculation
| Property | Type | Applies to |
|---|---|---|
| Expression | Editor | Measure |
EventTriggerConnection
| Property | Type | Applies to |
|---|---|---|
| Trigger | Choice | EventTrigger |
| Condition | Choice | EventTrigger |
| Condition Value | Number | EventTrigger |
Wonderware Historian#
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | Define the aggregation type. |
| Scaling Factor | Number | Measure | Used to scale or multiple a given value. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
| Filter Tag | Text | Measure | Define the filter tag. |
| Filter Comparator | Choice | Measure | Define the filter comparator. |
| Filter Value | Number | Measure | Define the filter value. |
| Filter Default Result | Number | Measure | Define the default filter result. |
| Expression | Editor | Measure | Determine the custom calculation config aggregation. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | EventTrigger | Determine trigger type. |
| For Period (s) | Number | Connection | |
| Condition | Choice | EventTrigger | Determine comparator type. |
| Condition Value | Number | EventTrigger | Determine trigger value. |
| Deadband | Number | Connection | |
| Expression | Editor | EventTrigger | Determine the custom calculation config trigger type. |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Type | Choice | EventAttributeSegment | Determine attribute value type. |
| Expression | Editor | EventAttributeSegment | Determine the custom calculation config attribute value type. |
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Tag | Text | Tag | Tag Name property used to return Measure Values |
| Forward Overlap | Whole number | Measure | |
| Backward Overlap | Whole number | Measure | |
| Server | Text | DataSource | Connecting server name. |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
Wonderware Historian 2017#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Server | Text | DataSource | Connecting server name. |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| Tag | Text | Tag | Tag Name property used to return Measure Values |
| Forward Overlap | Whole number | Measure | |
| Backward Overlap | Whole number | Measure |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | Define the aggregation type. |
| Scaling Factor | Number | Measure | Used to scale or multiple a given value. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
| Filter Tag | Text | Measure | Define the filter tag. |
| Filter Comparator | Choice | Measure | Define the filter comparator. |
| Filter Value | Number | Measure | Define the filter value. |
| Filter Default Result | Number | Measure | Define the default filter result. |
| Expression | Editor | Measure | Determine the custom calculation config aggregation. |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | EventTrigger | Determine trigger type. |
| For Period (s) | Number | Connection | |
| Detect SF | Yes/No | Connection | |
| Condition | Choice | EventTrigger | Determine comparator type. |
| Condition Value | Number | EventTrigger | Determine trigger value. |
| Deadband | Number | Connection | |
| Expression | Editor | EventTrigger | Determine the custom calculation config trigger type. |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Type | Choice | EventAttributeSegment | Determine attribute value type. |
| Expression | Editor | EventAttributeSegment | Determine the custom calculation config attribute value type. |
Wonderware InTouch#
General
| Property | Type | Applies to |
|---|---|---|
| Project Path | Text | DataSource |
| Data Path | Text | DataSource |
| Version | Choice | DataSource |
| Aggregation | Choice | Measure |
| Trigger | Choice | EventTrigger |
| Tag | Text | Measure |
| Scaling Factor | Number | Measure |
| Deadband | Number | Measure |
| State Comparator | Choice | Measure |
| Condition | Choice | EventTrigger |
| Condition Value | Number | EventTrigger |
Filter
| Property | Type | Applies to |
|---|---|---|
| Filter Tag | Text | Measure |
| Filter Comparator | Choice | Measure |
| Filter Value | Number | Measure |
| Filter Default Result | Number | Measure |
Wonderware MES#
General
| Property | Type | Applies to |
|---|---|---|
| Server | Text | DataSource |
| Database | Text | DataSource |
| Username | Text | DataSource |
| Password | Text | DataSource |
| ConnectionTimeout | Whole number | DataSource |
| MaxConcurrentConnections | Whole number | DataSource |
| Scaling Factor | Number | Measure |
Attribute Values
| Property | Type | Applies to |
|---|---|---|
| Tag | Choice | EventAttributeSegment |
| Measure Type | Choice | EventAttributeSegment |
| Entity | Text | EventAttributeSegment |
| Operation | Text | EventAttributeSegment |
Measure Values
| Property | Type | Applies to |
|---|---|---|
| Entity | Text | Measure |
| Measure Type | Choice | Measure |
| Measure Desc. | Text | Measure |
| Aggregation | Choice | Measure |
| Process ID | Text | Measure |
| Operation ID | Text | Measure |
| Plan | Choice | Measure |
| Reason Filters | Choice | Measure |
Measure Value Filters
| Property | Type | Applies to |
|---|---|---|
| Work Order ID | Text | Measure |
| Work Order Desc. | Text | Measure |
| Customer | Text | Measure |
| Comments | Text | Measure |
| Spare 1 | Text | Measure |
| Spare 2 | Text | Measure |
| Spare 3 | Text | Measure |
| Spare 4 | Text | Measure |
Measure Value Utilization Filters
| Property | Type | Applies to |
|---|---|---|
| OEE Time | Choice | Measure |
| Reason Group | Text | Measure |
| Reason | Text | Measure |
| Raw Reason | Text | Measure |
| State Code | Whole number | Measure |
| State Description | Text | Measure |
Measure Value Item Filters
| Property | Type | Applies to |
|---|---|---|
| Item Class | Text | Measure |
| Reason Grp Type | Choice | Measure |
| Reason Grp | Text | Measure |
| Prod Type | Choice | Measure |
| Cons Type | Choice | Measure |
| Item Grade | Text | Measure |
| Item State | Text | Measure |
| Item Reason | Text | Measure |
| Item ID | Text | Measure |
| Item Desc. | Text | Measure |
| User ID | Text | Measure |
Triggers
| Property | Type | Applies to |
|---|---|---|
| Tag | Choice | EventTrigger |
| Measure Type | Choice | EventTrigger |
| Entity | Text | EventTrigger |
| Operation | Text | EventTrigger |
Wonderware Online#
General
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Authentication Type | Choice | DataSource | Maximum number of concurrent connections allowed for a connector. |
| Username | Text | DataSource | Username to connect to the database. |
| Password | Text | DataSource | Stored encrypted. Password to connect to the database. |
| API Token | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Solution ID Endpoint | Text | DataSource | Stored encrypted. Password to connect to the database. |
| Maximum Concurrent Connections | Whole number | DataSource | Maximum number of concurrent connections allowed for a connector. |
| Tag | Text | Measure | Tag Name property used to return Measure Values. |
Measure Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Aggregation | Choice | Measure | Define the aggregation type. |
| Scaling Factor | Number | Measure | Measure property used to scale a given value. |
| Rollover | Number | Measure | Define the Rollover. |
| Deadband | Number | Measure | Define the Rollover Deadband. |
| State Comparator | Choice | Measure | Determine Time In State aggregation conditions. |
| State | Number | Measure | Determine Aggregation conditions. |
| Filter Tag | Text | Measure | Filter tag property. |
| Filter Comparator | Choice | Measure | Filter comparator property. |
| Filter Value | Number | Measure | Filter value property. |
| Filter Default Result | Number | Measure | Define the default filter result. |
| Expression | Editor | Measure |
Trigger Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Trigger | Choice | EventTrigger | Determine trigger type. |
| Condition | Choice | EventTrigger | Determine comparator type. |
| Condition Value | Number | EventTrigger | Determine trigger value. |
| Expression | Editor | EventTrigger | Determine the custom calculation config trigger type. |
Attribute Properties
| Property | Type | Applies to | Notes |
|---|---|---|---|
| Type | Choice | EventAttributeSegment | Determine attribute value type. |
| Expression | Editor | EventAttributeSegment | Determine the custom calculation config attribute value type. |