UA Office Link Features

Core Features

UA Office Link Core Documentation →

Feature 
Client / Server architectureUser interface application and data processing services are separate and may run on the same or on different computers.
Background serviceUA Office Link runs data processing tasks in the background without user logon and can start automatically after reboot.
Management applicationManage UA Office Link services and all connectors conveniently within one application.
Headless deployment optionUA Office Link services may be configured for remote administration and do not require Desktop features.
Remote administrationManage UA Office Link instances installed elsewhere when services are configured for remote administration. There is no cost associated with the core application or App plugins for connectors when used for remote administration.
No task limitCreate as many data processing tasks as you like.
Modular architectureExtend functionality by adding connectors or processors.

OPC UA Connector Features

OPC UA Connector Documentation →

Feature 
Sample data from OPC UA ServersSample data from OPC UA servers to send to other connectors.
Write data to OPC UA ServersWrite data received from other connectors to OPC UA Servers
OPC UA data bridgeTransfer data from one OPC UA server to another.
No server limitConnect to as many OPC UA servers as you like.
No tag limitConnect to as many OPC UA tags as you like.
Drag & Drop tagsExplore available OPC UA tags and drag and drop into topics.
Subscription Read ModeAcquire data by receiving data change notifications from the OPC UA Server.
Poll Read ModePoll the OPC UA Server in regular intervals to read data. Optionally synchronize polling to real-time, for example, to poll on the minute or on the hour.
Sampling of arraysUA Office Link supports sampling of scalar items and one-dimensional arrays.
Deadband valuesOptionally define tag deadband values if the OPC UA server supports it.
Convert to target typeOptionally convert data received from other connectors to the OPC UA server's tag data type.
Write data status and timestampsOptionally write value quality/status and timestamp information if the OPC UA server supports it.
Credentials managementSupports Username/Password authentication with options to prompt for login or store credentials securely.
Seamless reconnectAutomatically reconnects to OPC UA servers should the connection be lost.
Application pluginManage the OPC UA connector within the UA Office Link Core application.

ODBC Connector Features

ODBC Connector documentation →

Feature 
Log data into ODBC databasesStore data received from other connectors into MS SQL Server, MS Access, Oracle, MySql, PostgreSQL and other ODBC databases using Insert, Update or custom queries.
Read data from ODBC databasesRead data from ODBC databases to send to other connectors.
Optimized for Microsoft SQL ServerBest-match data type mapping
Support for quoted or bracketed identifiers
Create index on automatically created tables
Optimized for MySQLBest-match data type mapping
Support for quoted identifiers or identifiers enclosed in backtick characters
Create index on automatically created tables
Optimized for OracleBest-match data type mapping
Support for quoted identifiers
Create index on automatically created tables
Optimized for PostgreSQLBest-match data type mapping
Support for quoted identifiers
Create index on automatically created tables
Optimized for Microsoft AccessBest-match data type mapping
Support for quoted or bracketed identifiers
Create index on automatically created tables
ODBC data bridgeTransfer data from one database to another.
Custom Write queriesUse your own queries for storing samples. Simply type your query and use place holders where actual data item values, timestamps or qualities are to be substituted.
Custom Read queriesUse your own queries for retrieving samples.
Batch processing and recipe transfersLook-up records in a database as requested by a device and write records back to the device via, for example, the OPC UA connector.
Selective data processingProcess specific data within a table using a "Where" clause
Create tables automatically or manuallyDatabase table structures for data collection with matching field names and data types can be created automatically or user defined.
Drag & Drop fieldsExplore database table fields using a field browser, drag and drop fields into topics.
Sampling of arraysUA Office Link supports data logging of scalar items or one-dimensional arrays. The maximum number of array elements is only limited by the number of supported table fields of the database in use.
Store data quality and timestampsOptionally store value quality/status and timestamp information.
Process value statusDetermine how values of bad or uncertain status should be treated
Credentials managementUse Integrated security, login prompts or securely stored credentials for database connections.
Seamless reconnectAutomatically reconnects to databases should the connection be lost.
64-bit or 32-bit or bothInstall either the (default) 64-bit ODBC connector or the 32-bit ODBC connector or both to connect to 64-bit and/or 32-bit data sources.
Application pluginManage the ODBC connector within the UA Office Link Core application.

CSV Connector Features

CSV Connector documentation →

Feature 
Log data to text filesReceive data from other connectors and store values into text files.
Group filesLog related data into different folders
Write Header OptionOptionally write column headers for each new file.
Zero tag configuration"Generic" topics accept any tag sent to the connector.
ASCII Text EncodingSave text files with ASCII text encoding.
UTF-8 Text EncodingSave text files with UTF-8 text encoding.
UTF-16 Text EncodingSave text files with UTF-16 text encoding.
DelimitersSeparate values by comma, semicolon or tab. Optionally include an indicator for use of CSV files across regions.
Rotate files dailyAutomatically start a new file at midnight.
Rotate files hourlyAutomatically start a new file every hour.
Log value timestampsOptionally log value time stamps in UTC or local time for each value
Log value statusOptionally log value status codes for each value
Uncertain value handlingLog value, log blank value, or ignore values of "uncertain" quality
Bad value handlingLog blank value or ignore values of "bad" quality
Application pluginManage the CSV connector within the UA Office Link Core application.

 

Power BI Connector Features

Power BI Connector documentation →

Feature 
Send data to "streaming data sets"Receive data from other connector and send data to Power BI "streaming datasets".
No limits on "streaming data sets"Connect to as many streaming datasets as you like.
Dataset timestampOptionally include a timestamp for the entire dataset when sending data to Power BI for charting over time.
Value timestampsOptionally include timestamps for each value in the dataset when sending data to Power BI for charting over time.
Value statusOptionally include status code information for each value when sending data to Power BI.
ReconnectAutomatically reconnect to Power BI after connection loss.
Application pluginManage the Power BI connector within the UA Office Link Core application.

 

SOAP Connector Features

SOAP Connector documentation →

Feature 
No Web Service limitConnect to as many Web Services as you like
WSDL File ImportImport Web Service Description files from disk.
WSDL URL ImportFetch Web Service Descriptions via URL from the network.
HTTPS or HTTPConnect to Web Services via HTTP or HTTPS.
AuthenticationOptionally configure basic (username / password) authentication.
Complex typesSupports fetching of complex result types.
Test methodsTest individual Web Service methods by manually entering parameters.
Trigger Web Service callsCall Web Services based on a trigger input or based on input data changes.
ProcessorUse as "Processor" in UA Office Link tasks. Data inputs are sent to the Web Service and data outputs may be forwarded to other connectors.
Application pluginManage the SOAP connector within the UA Office Link Core application.

 

E-Mail Connector Features

E-Mail Connector documentation →

Feature 
Send data via e-mailReceive data from other connectors and send data in e-mail messages.
No message template limitConfigure as many e-mail message templates as you like.
TLSSecurely connect to mail servers via TLS
AuthenticationOptionally authenticate via username / password
Configure portConfigure the mail server port as required.
Configure "From"Configure sender name and "From" e-mail address as required.
Configure messageEach message template may contain a different subject, different recipients and a message text with placeholders. Placeholders are replaced with real-time data values sent by other connectors.
Minimum delayConfigure a minimum delay between messages for fast changing data.
Flexible send logicUse the e-mail connector in UA Office Link tasks to finely control when e-mail messages are sent, for example, based on a trigger, in regular intervals, or when an error condition is met.
Application pluginManage the E-Mail connector within the UA Office Link Core application.

 

Excel Connector Features

Excel Connector Documentation →

Feature 
Send live data to spreadsheetsReceive data from other connectors and create live links in spreadsheets
Select data columnsFor real-time data links, choose to include header text and any combination of connector name, topic name, tag name, tag value, value time stamp in local time, value time stamp in UTC, value status code or value status text.
Copy live valuesRight-click on a connector topic in the UA Office Link Core application to copy live data from connector topics and paste into Excel.
Manually edit linksManually edit pasted links or create new ones using the "RTD" live value formula to access any data column.
Array dataExpand "RTD" formulas to access some or all values in value arrays.
Application pluginManage the Excel connector within the UA Office Link Core application.

 

Stream Connector Features

Stream Connector Documentation →

InfluxDB Connector Features

InfluxDB Connector Documentation →

Cloud Connector Features

Cloud Connector Documentation →