Dataristix®

Connecting Data

Dataristix is a suite of software modules running on-premises or in the cloud, connecting disparate data sources and data sinks in real-time. Hybrid deployments with on-premises installations exchanging data with cloud services (databases, Power BI®, and so forth) are supported.

 

 

Need assistance to get you started? Contact us.

It’s easy to get started with Dataristix. Simply download and try out all available software modules. Mix and match software modules that you need for the most cost-effective solution. If you have any questions on the way, then please contact us. We can take you through the first steps, advise on how to best approach your envisioned solution or discuss what you need to make it work. 

Where does Dataristix fit?

Dataristix works on-premises, close to the sources of data, and the cloud, when deployed as a containerized application. Install Dataristix, for example, on computers near the factory floor and collect production data from OPC UA or MQTT devices for business level reporting. No Internet connection is required unless you want to send data to databases or other services hosted in the cloud. A single Dataristix instance will happily accumulate, aggregate and transform thousands or even tens of thousands of data points, transfer data into your database of choice or hook your spreadsheets up to real-time production data. Add more instances to scale to your needs.

 

Inform, Automate, Control

With Dataristix, you can finely control how data flows, from device to device or device to storage (or vice versa), using the graphical Task Builder.  You will be able to read from or write to devices using the OPC UA and MQTT connectors and create no-code or low-code tasks that, for example, retrieve recipes stored in a database for batch processing, automate report generation or drive processes. Transfer latest data directly from your production machinery to the business level for up-to-date decision making or feed factory floor data into business systems for further processing or visualisation, including Microsoft® Excel®, Power BI or your preferred OEE (Overall Equipment Effectiveness) solution.

Sending data from an OPC UA Server to a database

Cascading Dataflow

Handle individual tags or bulk data with ease! Many connectors support generic handling of inputs by accepting any input sent to the connector, thus eliminating the need to define target tags. This includes the various database connectors which optionally create or alter data storage tables on the fly. Use the visual task builder to hook up individual tags or define dataflows for groups of tags at the same time. Expand or collapse tag groups while the task is running.

Cascading dataflow, as objects or individual tags
Cascading dataflow, as objects or individual tags

First Class JSON support

Pass JSON objects through the task pipeline or decode and encode within the task dataflow as needed. Simply enter an example of your JSON object as text into the built-in decoder, then access individual properties within the task's dataflow. Optionally use the MQTT and REST connectors to decode JSON at the source and make indidiviual data points within the JSON object directly available as task inputs.

Dataristix JSON processing
Processing JSON as object or individual tags

Connectors

Modules that communicate with data sources or data sinks are called “Connectors”. Available Connectors include OPC UA, MQTT, ODBC (with optimizations for SQL server, Oracle®, MySQL®, PostgreSQL®, SAP HANA®, IBM DB2® and Microsoft Access® databases), Excel, CSV, E-Mail, SOAP, Power BI, Stream/JSON and InfluxDB®. Design data flows from and to connectors 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”).

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 to databases or read data from databases and exchange data with other connectors. Use with any ODBC database. Optimized for SQL server, Oracle, MySQL, PostgreSQL, SAP HANA, IBM DB2 and Microsoft Access databases. Features...

 

PostgreSQL® databases

Exchange data with PostgreSQL databases. This connector features the same capabilities as the ODBC connector but comes with a built-in client for Postgresql databases. Features...

SQL Server® databases

Exchange data with SQL Server databases. This connector features the same capabilities as the ODBC connector but comes with a built-in client for SQL Server databases. Features...

 

MySQL® databases

Exchange data with MySQL databases. This connector features the same capabilities as the ODBC connector but comes with a built-in client for MySQL databases. Features...

 

Oracle® databases

Exchange data with Oracle databases. This connector features the same capabilities as the ODBC connector but comes with a built-in client for Oracle databases. Features...

MQTT

A fully featured MQTT broker and client to exchange data with other MQTT brokers and clients and with other connectors. Features...

 

REST

Communicate with REST API services to receive or send data in JSON format. Features...

 

CSV

Log data to text files. Send data from other connectors for storage into delimiter-separated-value files. Supports various delimiters, text encodings and file rotation. Features...

Microsoft® Excel®

Automatically generate reports or copy and paste real-time data links into Microsoft Excel Desktop and receive data from other connectors in real-time. Learn more or see 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...

SOAP

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

 

Stream (deprecated)

Deprecated. It is now recommended to use the MQTT connector for inter-task and inter-instance communications.

 

InfluxDB® databases

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

Google Sheets

New. Send data to Google Sheets. Update cells in-place or append data to sheets. Please see the introduction or visit the Google Sheets connector documentation for all the details.

 

SQLite

Free! Exchange data with SQLite databases. This connector features the same capabilities as the ODBC connector but comes with a built-in client for SQLite.  Licenses are issued at no cost with every purchase. Current customers: Please contact us to claim your free license. Features...

 

Script

Free! Integrate JavaScript into your data flow to customize data processing. Licenses are issued at no cost with every purchase. Current customers: Please contact us to claim your free license. Features...

Please also see the Dataristix features or visit the Dataristix documentation for additional information.

Buy

Check out our competitive Dataristix pricing. Buy pre-selected module bundles or buy only the Connectors you need. The Dataristix core application is free, you only pay for Connector modules. Remember, you can trial all connector modules free for 30 days without obligations.


Dataristix is a registered trademark of Rensen Information Services Limited. Microsoft, Microsoft Access, Excel, Power BI, and SQL Server are registered trademarks of Microsoft Corporation. Oracle and MySQL are a registered trademark of Oracle. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada. SAP, SAP HANA are registered trademarks of SAP. IBM, IBM DB2 are registered trademarks of IBM. InfluxDB is a trademark of InfluxData. All other product names, trademarks and registered trademarks are the property of their respective owners.