Dataristix® Features
Here you'll find brief descriptions of Dataristix core features and connector module features. Links to the documentation provide further details. We welcome any questions, feature requests or other feedback you may have! Please contact support@rensen.io.
Core Features
Dataristix Core Documentation →
| Feature | |
|---|---|
| Client / Server architecture | User interface application and data processing services are separate and may run on the same or on different computers. |
| Background service | Dataristix runs data processing tasks in the background without user logon and can start automatically after reboot. |
| Management application | Manage Dataristix services and all connectors conveniently within one application. |
| Headless deployment option | Dataristix services may be configured for remote administration and do not require Desktop features. |
| Remote administration | Manage Dataristix 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 limit | Create as many data processing tasks as you like. |
| Graphical task designer | Define dataflows visually using drag and drop and by connecting tags or groups of tags in the Task designer |
| Modular architecture | Extend functionality by adding connectors or processors. |
OPC UA Connector Features
OPC UA Connector Documentation →
| Feature | |
|---|---|
| Sample data from OPC UA Servers | Sample data from OPC UA servers to send to other connectors. |
| Write data to OPC UA Servers | Write data received from other connectors to OPC UA Servers |
| OPC UA data bridge | Transfer data from one OPC UA server to another. |
| No server limit | Connect to as many OPC UA servers as you like. |
| No tag limit | Connect to as many OPC UA tags as you like. |
| Drag & Drop tags | Explore available OPC UA tags and drag and drop into topics. |
| Subscription Read Mode | Acquire data by receiving data change notifications from the OPC UA Server. |
| Poll Read Mode | Poll 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 arrays | Dataristix supports sampling of scalar items and one-dimensional arrays. |
| Deadband values | Optionally define tag deadband values if the OPC UA server supports it. |
| Convert to target type | Optionally convert data received from other connectors to the OPC UA server's tag data type. |
| Write data status and timestamps | Optionally write value quality/status and timestamp information if the OPC UA server supports it. |
| Credentials management | Supports Username/Password authentication with options to prompt for login or store credentials securely. |
| Seamless reconnect | Automatically reconnects to OPC UA servers should the connection be lost. |
| Application plugin | Manage the OPC UA connector within the Dataristix Core application. |
ODBC Connector Features
ODBC Connector documentation →
| Feature | |
|---|---|
| Log data into ODBC databases | Store 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 databases | Read data from ODBC databases to send to other connectors. |
| Optimized for Microsoft SQL Server | Best-match data type mapping Support for quoted or bracketed identifiers Create index on automatically created tables |
| Optimized for MySQL | Best-match data type mapping Support for quoted identifiers or identifiers enclosed in backtick characters Create index on automatically created tables |
| Optimized for Oracle | Best-match data type mapping Support for quoted identifiers Create index on automatically created tables |
| Optimized for PostgreSQL | Best-match data type mapping Support for quoted identifiers Create index on automatically created tables |
| Optimized for SAP HANA | Best-match data type mapping Support for quoted identifiers Create index on automatically created tables |
| Optimized for IBM DB2 | Best-match data type mapping Support for quoted identifiers Create index on automatically created tables |
| Optimized for Microsoft Access | Best-match data type mapping Support for quoted or bracketed identifiers Create index on automatically created tables |
| ODBC data bridge | Transfer data from one database to another. |
| Custom Write queries | Use 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 queries | Use your own queries for retrieving samples. |
| Batch processing and recipe transfers | Look-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 processing | Process specific data within a table using a "Where" clause |
| Create tables automatically or manually | Database table structures for data collection with matching field names and data types can be created automatically or user defined. |
| Drag & Drop fields | Explore database table fields using a field browser, drag and drop fields into topics. |
| Sampling of arrays | Dataristix 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 timestamps | Optionally store value quality/status and timestamp information. |
| Process value status | Determine how values of bad or uncertain status should be treated |
| Credentials management | Use Integrated security, login prompts or securely stored credentials for database connections. |
| Seamless reconnect | Automatically reconnects to databases should the connection be lost. |
| 64-bit or 32-bit or both | Install 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 plugin | Manage the ODBC connector within the Dataristix Core application. |
Connector for SQL Server Databases Features
Connector for SQL Server documentation →
| Feature | |
|---|---|
| Log data into SQL Server databases | Store data received from other connectors into SQL Server databases using Insert, Update or custom queries. |
| Read data from SQL Server databases | Read data from SQL Server databases to send to other connectors. |
| Optimized for Microsoft SQL Server | Best-match data type mapping Support for quoted or bracketed identifiers Create index on automatically created tables |
| SQL Server data bridge | Transfer data from one SQL Server database to another. |
| Custom Write queries | Use 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 queries | Use your own queries for retrieving samples. |
| Batch processing and recipe transfers | Look-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 processing | Process specific data within a table using a "Where" clause |
| Create tables automatically or manually | Database table structures for data collection with matching field names and data types can be created automatically or user defined. |
| Drag & Drop fields | Explore database table fields using a field browser, drag and drop fields into topics. |
| Sampling of arrays | Dataristix 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 timestamps | Optionally store value quality/status and timestamp information. |
| Process value status | Determine how values of bad or uncertain status should be treated |
| Credentials management | Use Integrated security, login prompts or securely stored credentials for database connections. |
| Seamless reconnect | Automatically reconnects to databases should the connection be lost. |
| Application plugin | Manage the connector within the Dataristix Core application. |
Connector for Oracle Databases Features
Connector for Oracle Databases documentation →
| Feature | |
|---|---|
| Log data into Oracle databases | Store data received from other connectors into Oracle databases using Insert, Update or custom queries. |
| Read data from Oracle databases | Read data from Oracle databases to send to other connectors. |
| Optimized for Oracle Databases | Best-match data type mapping Support for quoted identifiers Create index on automatically created tables |
| Oracle databases data bridge | Transfer data from one Oracle database to another. |
| Custom Write queries | Use 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 queries | Use your own queries for retrieving samples. |
| Batch processing and recipe transfers | Look-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 processing | Process specific data within a table using a "Where" clause |
| Create tables automatically or manually | Database table structures for data collection with matching field names and data types can be created automatically or user defined. |
| Drag & Drop fields | Explore database table fields using a field browser, drag and drop fields into topics. |
| Sampling of arrays | Dataristix 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 timestamps | Optionally store value quality/status and timestamp information. |
| Process value status | Determine how values of bad or uncertain status should be treated |
| Credentials management | Use Integrated security, login prompts or securely stored credentials for database connections. |
| Seamless reconnect | Automatically reconnects to databases should the connection be lost. |
| Application plugin | Manage the connector within the Dataristix Core application. |
Connector for MySQL Databases Features
Connector for MySQL documentation →
| Feature | |
|---|---|
| Log data into SQL Server databases | Store data received from other connectors into MySQL databases using Insert, Update or custom queries. |
| Read data from SQL Server databases | Read data from MySQL databases to send to other connectors. |
| Optimized for Microsoft SQL Server | Best-match data type mapping Support for quoted or back-tick identifiers Create index on automatically created tables |
| SQL Server data bridge | Transfer data from one MySQL database to another. |
| Custom Write queries | Use 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 queries | Use your own queries for retrieving samples. |
| Batch processing and recipe transfers | Look-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 processing | Process specific data within a table using a "Where" clause |
| Create tables automatically or manually | Database table structures for data collection with matching field names and data types can be created automatically or user defined. |
| Drag & Drop fields | Explore database table fields using a field browser, drag and drop fields into topics. |
| Sampling of arrays | Dataristix 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 timestamps | Optionally store value quality/status and timestamp information. |
| Process value status | Determine how values of bad or uncertain status should be treated |
| Credentials management | Use Integrated security, login prompts or securely stored credentials for database connections. |
| Seamless reconnect | Automatically reconnects to databases should the connection be lost. |
| Application plugin | Manage the connector within the Dataristix Core application. |
Connector for PostgreSQL Databases Features
Connector for PostgreSQL documentation →
| Feature | |
|---|---|
| Log data into SQL Server databases | Store data received from other connectors into PostgreSQL databases using Insert, Update or custom queries. |
| Read data from SQL Server databases | Read data from PostgreSQL databases to send to other connectors. |
| Optimized for Microsoft SQL Server | Best-match data type mapping Support for quoted identifiers Create index on automatically created tables |
| SQL Server data bridge | Transfer data from one PostgreSQL database to another. |
| Custom Write queries | Use 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 queries | Use your own queries for retrieving samples. |
| Batch processing and recipe transfers | Look-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 processing | Process specific data within a table using a "Where" clause |
| Create tables automatically or manually | Database table structures for data collection with matching field names and data types can be created automatically or user defined. |
| Drag & Drop fields | Explore database table fields using a field browser, drag and drop fields into topics. |
| Sampling of arrays | Dataristix 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 timestamps | Optionally store value quality/status and timestamp information. |
| Process value status | Determine how values of bad or uncertain status should be treated |
| Credentials management | Use Integrated security, login prompts or securely stored credentials for database connections. |
| Seamless reconnect | Automatically reconnects to databases should the connection be lost. |
| Application plugin | Manage the connector within the Dataristix Core application. |
Connector for SQLite Databases Features
Connector for SQLite documentation →
| Feature | |
|---|---|
| Log data into SQL Server databases | Store data received from other connectors into SQLite databases using Insert, Update or custom queries. |
| Read data from SQL Server databases | Read data from SQLite databases to send to other connectors. |
| Optimized for Microsoft SQL Server | Best-match data type mapping Support for quoted identifiers Create index on automatically created tables |
| SQL Server data bridge | Transfer data from one SQLite database to another. |
| Custom Write queries | Use 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 queries | Use your own queries for retrieving samples. |
| Batch processing and recipe transfers | Look-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 processing | Process specific data within a table using a "Where" clause |
| Create tables automatically or manually | Database table structures for data collection with matching field names and data types can be created automatically or user defined. |
| Drag & Drop fields | Explore database table fields using a field browser, drag and drop fields into topics. |
| Sampling of arrays | Dataristix 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 timestamps | Optionally store value quality/status and timestamp information. |
| Process value status | Determine how values of bad or uncertain status should be treated |
| Credentials management | Use Integrated security, login prompts or securely stored credentials for database connections. |
| Seamless reconnect | Automatically reconnects to databases should the connection be lost. |
| Application plugin | Manage the connector within the Dataristix Core application. |
MQTT Connector Features
MQTT Connector documentation →
| Feature | |
|---|---|
| MQTT Broker | Acts as a broker to send or receive data to and from MQTT clients. |
| MQTT Client | Acts as one or more MQTT client(s) to connect to MQTT brokers |
| TCP/IP or Websockets | Configure brokers and clients to connect via TCP/IP or WebSockets |
| TLS | Supports secure connections via Transport Layer Security |
| MQTT 3.1.1 | Supports the MQTT 3.1.1 protocol |
| MQTT 5.0 | Supports the MQTT 5.0 protocol |
| QoS Levels | Supports all quality-of-service levels |
| Retained messages | Broker supports retained messages |
| Message persistence | Broker supports persistent messages |
| Integrated JSON processing | Process JSON properties in task flows as if they were individual tags |
| Tag Browser | Browse available MQTT broker topics by specifying a root topic with integrated JSON decoding |
| Username / Password Authentication | Supports username and password authentication |
| Client Certificate Authentication | Supports authentication via client certificates |
| Connector Integration | Send and receive data to and from other connectors |
| Application plugin | Manage the MQTT connector within the Dataristix Core application. |
REST Connector Features
REST Connector documentation →
| Feature | |
|---|---|
| REST API Clients | Configure one or more REST client(s) to exchange data with various REST API servers in JSON format |
| Send or Receive | Receive data using GET requests or send data using PATCH, PUT or POST |
| Secure Connections | Use HTTP or HTTPS connections |
| Basic Security | Supports basic authentication with username and password |
| API Key Security | Supports API Key authorization using flexible header names and header value templates |
| Certificate Security | Supports authentication with client certificates |
| OAuth 2.0 Security | Supports OAuth 2.0 authorization (client credentials flow) |
| Custom Headers | Add custom headers in HTTP(S) requests |
| Decode JSON | Optionally decode JSON to process contained values separately or to minimize requests to the REST service |
| Tag Browser | Inspect the REST service response and decode JSON before adding the response or response parts as tags for processing in dataflow tasks |
| Connector Integration | Send and receive data to and from other connectors |
| Application plugin | Manage the REST connector within the Dataristix Core application. |
CSV Connector Features
| Feature | |
|---|---|
| Log data to text files | Receive data from other connectors and store values into text files. |
| Group files | Log related data into different folders |
| Write Header Option | Optionally write column headers for each new file. |
| Zero tag configuration | "Generic" topics accept any tag sent to the connector. |
| ASCII Text Encoding | Save text files with ASCII text encoding. |
| UTF-8 Text Encoding | Save text files with UTF-8 text encoding. |
| UTF-16 Text Encoding | Save text files with UTF-16 text encoding. |
| Delimiters | Separate values by comma, semicolon or tab. Optionally include an indicator for use of CSV files across regions. |
| Rotate files daily | Automatically start a new file at midnight. |
| Rotate files hourly | Automatically start a new file every hour. |
| Log value timestamps | Optionally log value time stamps in UTC or local time for each value |
| Log value status | Optionally log value status codes for each value |
| Uncertain value handling | Log value, log blank value, or ignore values of "uncertain" quality |
| Bad value handling | Log blank value or ignore values of "bad" quality |
| Application plugin | Manage the CSV connector within the Dataristix 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 timestamp | Optionally include a timestamp for the entire dataset when sending data to Power BI for charting over time. |
| Value timestamps | Optionally include timestamps for each value in the dataset when sending data to Power BI for charting over time. |
| Value status | Optionally include status code information for each value when sending data to Power BI. |
| Reconnect | Automatically reconnect to Power BI after connection loss. |
| Application plugin | Manage the Power BI connector within the Dataristix Core application. |
SOAP Connector Features
SOAP Connector documentation →
| Feature | |
|---|---|
| No Web Service limit | Connect to as many Web Services as you like |
| WSDL File Import | Import Web Service Description files from disk. |
| WSDL URL Import | Fetch Web Service Descriptions via URL from the network. |
| HTTPS or HTTP | Connect to Web Services via HTTP or HTTPS. |
| Authentication | Optionally configure basic (username / password) authentication. |
| Complex types | Supports fetching of complex result types. |
| Test methods | Test individual Web Service methods by manually entering parameters. |
| Trigger Web Service calls | Call Web Services based on a trigger input or based on input data changes. |
| Processor | Use as "Processor" in Dataristix tasks. Data inputs are sent to the Web Service and data outputs may be forwarded to other connectors. |
| Application plugin | Manage the SOAP connector within the Dataristix Core application. |
E-Mail Connector Features
E-Mail Connector documentation →
| Feature | |
|---|---|
| Send data via e-mail | Receive data from other connectors and send data in e-mail messages. |
| No message template limit | Configure as many e-mail message templates as you like. |
| TLS | Securely connect to mail servers via TLS |
| Authentication | Optionally authenticate via username / password |
| Configure port | Configure the mail server port as required. |
| Configure "From" | Configure sender name and "From" e-mail address as required. |
| Configure message | Each 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 delay | Configure a minimum delay between messages for fast changing data. |
| Flexible send logic | Use the e-mail connector in Dataristix 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 plugin | Manage the E-Mail connector within the Dataristix Core application. |
Excel Connector Features
Excel Connector Documentation →
| Feature | |
|---|---|
| Report Generation | Prepare Excel workbooks with placeholder cells where live values are to be substituted and control timing and frequency of report generation in Dataristix tasks. |
| Live spreadsheets | Design spreadheets with continuously updating real-time data. |
| Select data columns | For 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 values | Right-click on a connector topic in the Dataristix Core application to copy live data from connector topics and paste into Excel as real-time data links. |
| Manually edit links | Manually edit pasted links or create new ones using the "RTD" live value formula to access any data column. |
| Array data | Expand "RTD" formulas to access some or all values in value arrays. |
| Remote RTD | Serve dozens or even hundreds of Excel users elsewhere on the Intranet by enabling remote RTD access at now additional cost. |
| Application plugin | Manage the Excel connector within the Dataristix Core application. |
Script Connector Features
Script Connector Documentation →
| Feature | |
| JavaScript | Supports JavaScript data processing |
| Data flow integration | Integrates into a task's data flow just like other processors |
| Flexible data access patterns | Loop through input values to calculate output values or access values by name. |
| Generic data processing | Supports generic tag processing without the need to specify individual tags. |
| Specific data processing | Supports named tag configurations for inputs and outputs. |
| Application plugin | Manage the Script connector within the Dataristix Core application. |
The following connector modules are in pre-release.
InfluxDB Connector Features
InfluxDB Connector Documentation →