FeatureFRIYAY September: we added SQL datasets, speedometer chart & Oracle connector

Another month flew by! September has been a productive month at Cumul.io. So we’re super excited to guide you through our latest feature updates. Learn everything about SQL datasets, and explore a brand-new chart type & connector we’ve added!

We’ve added SQL datasets to Cumul.io

If you’re a frequent BI user, from time to time you just really want to craft that specific query that’s sent to your database, and use all the power and expressiveness its SQL dialect provides.

You might want to join some tables or go crazy with subqueries and window functions. Of course you could create a view in your database, but that often involves your IT department and lengthy procedures.

Not ideal when you need to be able to tune it quickly right before that next business meeting. But what if you could create and maintain those views yourself, directly within Cumul.io itself?

Well, you can! We call them SQL Datasets and it’s one of our latest additions to our feature list.

What are the advantages of SQL datasets?

As mentioned, SQL datasets are a way to create and manage database views in Cumul.io, instead of managing them in your database. This is especially useful if you know SQL, but you’re on the business side of things, or you don’t have access rights to the production databases.

With Cumul.io’s SQL datasets, you no longer need access to the database. You can simply write and perform a database query directly in Cumul.io to create your desired view. If you want to move faster without waiting for intervention of IT, this is the perfect solution. 😉

SQL datasets in Cumul.io

As a tech-savvy (business) user, you can stay in full control over database views. You don’t need to make the views in the database itself, which will also relieve your IT team from extra workload.

At the same time, you can still take advantage of the full power of your underlying database, directly inside Cumul.io. Create queries, subqueries, and even use advanced window functions.

Which databases support SQL datasets in Cumul.io?

SQL datasets are currently available for the following databases:

  • PostgreSQL
  • SQL server
  • MySQL
  • MariaDB
  • AWS Redshift
  • Panoply
  • Stardog

Your SQL datasets work just like any other dataset in Cumul.io. You’ll be able to share it, create derived columns and activate caching.

How to use SQL datasets in Cumul.io?

Curious to see SQL datasets in action? In our monthly customer success webinar, Laura explains how to create a SQL dataset from scratch, and how use it in your dashboard.

To go through it step by step, you can simply re-watch the webinar below.

New chart: speedometer

We’ve added a new chart type to our chart directory: the speedometer! This chart is similar in use to a gauge, as it also visualizes your metric against a target. The difference is that you can use it to indicate a specific range in which your target value should locate itself, rather than a fixed target.

Especially in industrial contexts, the speedometer is very useful. Imagine you’re working with sensors to measure a specific value or quality, for example an air quality sensor, or a speed sensor. In such cases, the values usually need to be inside a specific range, and anything outside that range should be noticed immediately.

This is exactly what you can visualize using the speedometer. In the charts below, we’ve visualized the Air Quality Index for Springfield and Bedrock. Thanks to the intuitive visual interface, it’s pretty clear that the Simpsons are suffering much more from air pollution than the Flintstones!

Just like a regular gauge, you can set your target ranges manually or upload a target sheet. The speedometer has plenty of styling options as well. Change the marker from a needle to a line, an arrow, or even a band.

New speedometer chart in Cumul.io

New database connection: Oracle

Are you an Oracle user? Then it’s your lucky day! We now support Oracle database connections with our out-of-the-box Oracle connector.

Simply enter the credentials of your Oracle database and you’re ready to query data from your Oracle database, straight into your Cumul.io dashboards! No need to write code. Connect in just a few clicks.

For more instructions on connecting your Oracle database, check out our Academy article.

Cumul.io is a High Performer in G2 fall reports!

G2 just launched its fall reports, comparing the best-in-class embedded BI tools. Once more, Cumul.io is a High Performer in embedded analytics. Customers are most satisfied with our customer support & the ease of doing business with us, with ratings as high as 98%.

Cumul.io awarded High Performer in G2 Fall Reports

On the product side, our clients like us most for our ease of use and ease of setup. We’d like to thank everyone who helped us make this happen by leaving your valuable feedback, we appreciate it! If you haven’t left your feedback yet, you can still leave your review on G2.

Can’t wait to explore all these new features? Sign in to your Cumul.io account and start enjoying these new functionalities right away!

Add a Comment