Self-Service Dashboard

Pull all your data together in one place and easily create charts and dashboards for anything you need.

Drag and Drop widgets to display data. Aggregate, filter and group data directly in the user interface. Share dashboards with your fellow colleagues. Embed dashboards and widgets on your intranet.
digreal-time-laptops-1

What’s Unique?

We’ve made it super simple to customize your data visualization-, monitoring- and interactive analysis applications in any way you like. In addition to the built in standard drag-and-drop widgets (lines, bars, dots, pies, tables, maps, speedometers, value labels, paretos and web frames), you can create your own unique widgets with a few lines of HTML and CSS code. And you can make true magic happen by throwing in a couple of lines of JavaScript code. The only limit is your imagination!
widgets
digrealtime-dashboard
You are therefore not limited to the built in chart types, and their configuration possibilities, but are totally free to come up with your own ideas that suit your business needs better, and you can do it yourself, as long as you have some basic understanding of HTML.

We’ve got plenty of templates for you to get started.

Furthermore, if you go pro, you will have full access to our royalty free marketplace for code snippets, where you can find totally amazing visualizations shared by other pro users and our own designer lab. These code snippets are made with nothing but HTML, CSS and JavaScript, and you can just copy and paste the code into your own widgets to implement the visualization and its functionality. You can then easily tweak it to fit your own special needs.

Register today to get started. It’s free!

Data Pipelines

There are three ways you can get data into the ScreamDB memory node (our memory cache technology):

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.

System Components

The DigRealtime Server Software is made up by a rich set of software modules. Everything is installed with the Installer App.
digrealtime-modules-1
You can download the FREE Basic Edition of the server software here. It has all the functionalities except for Enterprise Rights Management.

System Requirements

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.

 

6. CONFIGURATOR

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

This service will monitor data inside Memory Node and perform tasks when needed such as posting data to websites or sending email alerts. It is fully programmable (in javascript) and includes a code editor and visual subscription tools.

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.

11. SDK

Through our SDK for .net and java, developers can quickly utilize the power of our software inside their own applications. Benefit from fast in-memory data processing and push-updates with just a few lines of code. The SDK comes with multiple example projects to get you started quickly.

It’s FREE.

Download the FREE Basic Server Edition.

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.

widget-trigger-color

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”:

value-label-customization

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

digrealtime-vocabulary