UA Office Link

Download Free Trial

Connecting Data

UA Office Link is a suite of software modules running on-premise to connect disparate data sources and data sinks in real-time, with optional Cloud connectivity to the UA Office Link Cloud service or third-party services such as Microsoft Power BI or cloud based databases.

It’s easy to get started with UA Office Link. Simply download a 30-day trial, no questions asked, and try out all available connectors for a month. The core application to host connector plugins is free.

Modules that communicate with data sources or data sinks are called “Connectors”. Available Connectors include OPC UA, ODBC (SQL server, Oracle, MySQL, PostgreSQL, Microsoft Access, and others), Excel, CSV, E-Mail, SOAP/SAP, Power BI, Stream/JSON, InfluxDB and the UA Office Link Cloud service. Dataflows from and to connectors are defined using the graphical Task builder. Once a task is started, data flows from input connectors, through optional processors, to output connectors.

You need at least one connector to transfer data within the same type of data source/data sink (for example, “OPC UA Server” to “OPC UA Server” as an OPC UA data bridge), or at least two connectors to transfer data between different types of data sources/data sinks (for example, “OPC UA Server” to “ODBC database”). Please see the UA Office Link features or visit the UA Office Link documentation → for additional information.

Sending data from an OPC UA Server to a database

Connectors

OPC UA

Connect to OPC UA Servers to exchange data with other connectors. Control processes, log data, use as OPC UA data bridge, and more. Features...

 

ODBC

Log data data to databases; read and exchange data with other connectors. Use with any ODBC database. Optimized for SQL Server, Oracle, MySQL, PostgreSQL and MS Access. Features...

 

CSV

Log data to text files. Send data from other connectors for storage into delimiter-separated-value files. Features...

SOAP / SAP

Connect to SOAP Web Services, including SAP Web Services, to receive or send data from other connectors or execute Web Service methods when triggered. Features...

 

Power BI

Visualize data with Power BI. Send data from other connectors to streaming data sets in Microsoft Power BI. Features...

 

E-Mail

Send data received from other connectors via E-Mail. Compose e-mail templates to send values as periodic reports or when triggered. Features...

Excel

Copy and Paste data links into Excel Desktop to receive data from other connectors in real-time. Features...

 

Stream / JSON

Prerelease. Serve real-time data received from other connectors as JSON data or interconnect instances of UA Office Link across the network. Features...

 

InfluxDB

Prerelease. Store data received from other connectors into time-series databases. Features...

Cloud

Prerelease. Send or receive end-to-end encrypted data to and from the UA Office Link Cloud Service across the Internet. Features...

 

MQTT

Coming soon!

 

 

REST

Coming in 2022!