Pull all your data together in one place and easily create charts and dashboards for anything you need.
We’ve got plenty of templates for you to get started.
Register today to get started. It’s free!
1. Use our Command Scheduler (direct poll) to monitor tables or views for updates directly in databases, and let the memory node load data directly from the source, without sending it to a persistent SQL database.
2. Use our ETL Data Tool to pull data and updates on intervals from your databases to the persistent storage, which is then loaded into the memory node upon request from the web client (Dashboard Studio) .
3. Use our API to write data directly to the memory node, or to the persistent SQL database.
You need to run the software on Windows. It doesn’t have to be Windows server. It works on any newer Windows platform.
You also need a database for persistent storage. You can chose between Microsoft SQL Server, PostgreSQL or Oracle.
The Dashboard Studio Web Application needs to be run in an HTML5 compatible web browser.
1. DASHBOARD STUDIO
This web application is used by the end-users to build, view and share dashboards.
It’s a simple-but-advanced rich web application that requires a browser that supports HTML5 and CSS3.
It’s simple to build dashboards, aggregate data and link widgets through drag-and-drop.
2. DATA ROUTER & MEMORY NODE
These two components make up “the heart” of the software suite. The router receives commands and data-subscriptions and pass them on to the memory node. The memory node (there can be multiple nodes connected to the same router) loads data from a persistent data source and caches it in memory. Data-subscriptions are “live” and updates will be pushed to the subscribing clients.
The system requires a master database and supports MSSQL, Oracle and PostgreSQL databases natively. Data from other systems have to be replicated using either our ETL tool or similar 3rd party applications.
3. XMPP SERVER
This third party software handles the communication between all the components of the software suite.
It keeps a roster of online and offline users and can connect to external user directories that implement the LDAP standard.
It is bundled into our installer and preconfigured to connect to our servers.
4. ETL Data Tool
Consisting of a service and a client application, this software “pulls” data on intervals from regular MSSQL or any ODBC data source such as Oracle, MySQL, PostgreSQL or even Excel sheets. It can be configured to fetch historic data in “chunks” using timestamps or IDs, minimizing the required load on the original data source. The result is replicated in any of DigRealtimes persistent data sources and loaded (if ever requested by a client) into the memory cache immediately.
5. SYSTEM MONITOR
This is a service and an application that can be setup on a local or remote computer to receive and show or log (into Windows event log) the logs from the Data Router and Memory Node.
By default these logs are written to the console and only displayed when the software is run through the command prompt.
This is the configuration- and control-center for all the data sources and server-side components except the ETL Data Tool.
7. Command Scheduler
A scheduler service that will issue commands to pull updates or purge old data on configured intervals. Used when DigRealtime is configured to monitor tables or views directly in databases.
8. WATCH DOG
9. RW SERVER
This service is required when you want to write data directly to DigRealtime using our SDK within your own applications. This allows you to create new tables and data programmatically that will be pushed to subscribers and stored in persistent storage.
10. ENTERPRISE AUTHENTICATION
This module/software component hooks into the core of the software suite and manages user rights. Access can be set on table or even column-value level per user and/or user group. This component is not included in the Basic version of the software suite.
Frequently Asked Questions
Yes it is. Any data that you visualize, filter and aggregate through the column-widget, you can export to Excel by simply hitting the “Export to Excel icon”.
Yes it is. Any dashboard can be exported to PDF in either landscape- or portrait mode.
Yes it is. On any date-time data, you can offset data from “now, yesterday, etc.”, by seconds, days, weeks, months and years. You can chose a “from” time, and “to” time, by offsets, and there are more than 10 presets to chose from like “beginning of this minute, beginning of this hour, etc., that cover the most used scenarios for sliding time frames.
Yes it is. You can select a single widget, or multiple widgets, and even the whole dashboard and press the “Embed code” icon to get the code to insert into your web page of choice. It works pretty much in the same way as you normally embed YouTube videos. Since it is an iframe, all functionalities like zoom, select, drill-downs, etc., remains, and so do user rights.
Yes you can. Right-click anywhere in an empty space in the dashboard and chose “Add annotation”. Use the built in WYSIWYG html editor to compose your annotation, hit “save”, and share your findings with fellow colleagues.
There’s one standard widget that can do this: the “Value Label” widget. However, if you need this functionality in other visualizations, it can easily be done through custom widgets.
In general no. You can change colors, backgrounds, themes, chart type etc., but you can’t customize the underlying raw graphics, with one exception: the “Value Label”:
You can write standard HTML in the PREFIX and SUFFIX text boxes, and as an example insert images etc., in this widget.
Otherwise, you need to create a custom widget using HTML and CSS, using the “Template List” widget.
You should think in terms of denormalized data, as in big tables with attributes and values in columns. Our in-memory technology is optimized to be compute efficient on rows of columnar data. Filtering, aggregations and math operations on rows of columns are very fast. You should expect a performance in the range of 20,000 – 100,000 times faster compared to any relational database on the market, right from the web based Dashboard Studio, which handles paging and down-sampling by default to be able to plot huge amounts of data in a web browser.
Yes, but there are some limitations: For performance reasons our backend system doesn’t join tables on the fly (bad joins can result in an immense amount of data, unsuitable for realtime operations). Joins need to be handled in a database view or import-query before it goes into our system. But you can still use data from multiple tables in different widgets on the same dashboard and criterias/filters. For instance, the ones generated by user selections can be inherited from one widget to another by simply adding a “term” in the “vocabulary” by specifying what column the filter should translate into. For example, if multiple tables contain a timestamp, you might want to select a date-range within one table and have data from a second table displayed with the same date-range filter applied. You might also want to select an order ID from a list of orders and have the order lines shown in a second widget. Note that if you need to display, for example, orders and order lines and want to enable a “Country” filter, both the order table and the order lines table need to have a column containing the the same data, in this case “Country”.