Migration guide: How to migrate from Chartio to Cumul.io
Posted On 04/03/2021
Last week, Chartio announced they will be joining Atlassian. We wish them a big congrats on this awesome news! 🎉 Unfortunately, this also means thousands of clients are now left without a BI tool in their data stack.
If you’re a Chartio customer, we’re sure you were shocked to hear their data visualization platform will be deprecated as of March 2022. And you’re probably asking yourself: what are we going to do now?
But hey, no need to worry! You still have 12 months left to migrate to another platform, and with Cumul.io, you’ll get it done way faster than that!
Evidently, Chartio is a very powerful platform. But we are confident that Cumul.io is a great alternative you will love at least as much, and even more because of its powerful embedding. If you’re looking to achieve client-facing reporting, you will simply love the transition to Cumul.io!
In this migration guide, you’ll get step-by-step guidance on how to migrate from Chartio to Cumul.io. We’ll discuss all of Chartio’s key features, and how these translate to the Cumul.io platform.
But first things first: is Cumul.io the right fit for you?
There are lots of data visualization alternatives out there, and selecting the right one can be overwhelming. Cumul.io is a generalist platform that can tackle many use cases. However, there are some use cases in which it truly outshines other players in the market.
Generally, Cumul.io will be a great solution for you if:
you are looking to accomplish client-facing reporting, e.g. dashboards embedded into your own application, a custom reporting portal for clients, or a white-labeled dashboard builder for clients;
business users need control & manage the dashboards through an intuitive interface, without having to write code;
at the same time, you want to offer developers enough flexibility to create tailored analytical features through an API, or let data analysts create their own SQL datasets;
in general, you want a high degree of flexibility and customization to the look & feel and functionality of your dashboards;
For all the above reasons, Cumul.io is generally a good fit for SaaS companies or service providers, looking to offer client-facing reporting inside their own application.
Does that sound like you? Then Cumul.io is definitely right for you. If you’d like to test the waters first, we offer a free 10-day trial to explore the platform, no strings attached.
How to migrate from Chartio to Cumul.io
To migrate from Chartio to Cumul.io will be a fairly frictionless process for 2 reasons:
Lots of Chartio’s features are matched 1-on-1 in Cumul.io
We’ve outlined the most important differences – and how to deal with them – in this migration guide for you! 😉
Get ready to make a smooth transition with plenty of resources. We’ll cover how to migrate every step of the dashboarding process below: all the way from data connection to embedding a dashboard.
1. How to migrate data connections from Chartio to Cumul.io
Which data sources does Cumul.io connect to?
Just like Chartio, Cumul.io connects easily with the most common databases and data warehouses, as shown below. If you were using Chartio in combination with a data warehouse partner like Panoply, we also offer this as a native integration to ensure your smooth transition.
How can I connect other data sources Cumul.io doesn’t natively support?
Your data does not necessarily need to sit in a database or data warehouse in order to connect it to Cumul.io. If you want to connect data from a cloud application, your own API, or any other data source we don’t natively support, you can use Cumul.io’s plugin API to build your own plugin.
A plugin is a data adapter that sits between Cumul.io and any data source of your choice. It queries the data source directly, in order to have the data flow through our systems and populate the dashboard. By default, we will never store data that was passed on through a plugin.
Writing SQL datasets in Cumul.io
Chartio has a visual SQL editor that lets you produce a chart or a dashboard. In Cumul.io, you’ll create charts using a visual drag & drop editor, which automatically generates SQL queries for you.
However, if you prefer having full control over the queries being sent out, there are still a number of ways to do so. You can use our SQL dataset editor to craft a specific SQL query directly inside Cumul.io, add (materialized) views as data sources to Cumul.io, or make use of Cumul.io plugins. For more information, check out the Academy article on writing your own SQL queries.
2. How to migrate dashboards from Chartio to Cumul.io
You will be happy to discover that Cumul.io has quite an intuitive interface when you start migrating dashboards from Chartio. This will save you countless hours recreating your most important dashboards.
Let’s highlight a few important similarities & differences of the dashboarding experience in Cumul.io vs Chartio.
Creating charts & dashboards
In Chartio, you’ll typically create charts using a visual or SQL editor, and then save them to a dashboard. It’s important to understand that, in Cumul.io, you will create charts on the dashboard level. This means every chart is tied to a single dashboard.
The process of creating a chart in Cumul.io feels slightly different compared to Chartio. While Chartio is heavily SQL driven, Cumul.io is visually more intuitive and lets you drag & drop charts together on the dashboard canvas. This might be a change at first, but our users love the ease of use!
Once you get used to this new style of editing, the other functions of the platform will feel very similar to Chartio’s features.
Allowing access to dashboards
Just like Chartio, Cumul.io allows you to set different user roles. On account level, a user can either create & manage dashboards, or only view dashboards. You can also set user rights for individual dashboards, and allow someone to only view dashboard A, while giving him or her edit rights on dashboard B, etc.
Later in this guide, we’ll get into more detail on user roles & rights for dashboards that are used in an embedded context.
Styling your dashboards
Cumul.io’s theme editor is very alike to the Chartio interface. The only difference being Cumul.io allows for more customization: adapt borders, padding, shadows, or even add custom CSS. When embedded, you can even go as far as rendering a different styling depending on who views the dashboard.
Organizing your dashboards
While Chartio lets you add dashboards to categories, Cumul.io uses a tag system that allows you to easily organize dashboards in your account. Whether the dashboard belongs to a specific department, client, or use case.
Interacting with your dashboards
Cumul.io allows similar interactivity as Chartio – including additional interactivity options. When filtering on a chart, the rest of your dashboard will adapt automatically. Drilldown filtering is also available in any chart type. Cumul.io also matches all of Chartio’s dashboard controls – only we call them filters. Add a slider, calendar, dropdown or multi-select box to your dashboard with simple drag & drop.
When using the dashboards embedded in your platform, you can add even more interactivity. Trigger an action in your platform directly from the dashboard, such as reordering an item that is almost out of stock.
Cumul.io offers roughly the same visualization types as Chartio, including additional chart types like speedometer, sankey, financial charts and more. Each chart type has its own set of customization options, similar to Chartio.
Just like in Chartio, you can set a timezone for your data in Cumul.io. You’ll set the timezone on dashboard level, and when someone else views the dashboard, the data will automatically reflect the timezone your user is in.
Using hidden variables in Cumul.io
If you want to filter a dashboard based on hidden variables, you can use Cumul.io’s parameters. This is especially useful if you want to embed a dashboard, as parameters will be used to define which information will be shown in your dashboard, depending on who is viewing the dashboard.
3. How to migrate client-facing dashboards
Just like Chartio, Cumul.io has many sharing options available: share your dashboard with a share link, download a PDF or PNG export, schedule automatic email reports, or share dashboards with your clients using interactive embedding.
Embedding a dashboard
Embedding a Cumul.io dashboard is as simple as copy-pasting the embed code of your dashboard, which can be accessed through the share modal.
Similar to Chartio’s JWT tokens, Cumul.io uses temporary authorization tokens to securely embed dashboards into your platform. In these authorization tokens, you can define which data & dashboards to show to each user, and add other filters to personalize the experience for each viewer of the embedded dashboard.
The advantage is that you can reuse the access rights defined in your platform for each specific user, group or suborganization. If your dashboards are embedded in a login-protected environment, dashboard viewers don’t need an additional Cumul.io login. Their platform login will suffice to render the dashboards securely, only showing the data they have access to. This authorization setup is made possible by Cumul.io’s Core API, which we’ll discuss in more detail later on.
In addition to the embed script, you can also use our libraries for React, React Native and Angular to embed into your application even more easily.
Add more functionality to your embedded dashboards
Our integration API lets you do much more than simply embedding. For example, trigger actions from an embedded dashboard to your platform, create dashboards based on user context, and more! Check out the Integration API documentation or integration course for more information.
4. How does Cumul.io’s API compare to Chartio?
If you’re using Chartio’s Admin API to programmatically add or remove users, edit team permissions, or refresh data sources, you’ll find that Cumul.io’s API offers an even wider range of functions to leverage.
Our platform was built API-first, meaning anything you can do in the UI is also possible through API. Amongst other things, Cumul.io’s Core API lets you:
Create, update and delete dashboards and datasets
Creat and manage users, groups, organizations etc.
Create or delete authorization tokens
Associate dashboards and datasets to specific users or user groups
Apart from the Core API, Cumul.io also has an Integration API and Plugin API available. While the plugin API allows you to build plugin data connectors, the Integration API lets you easily embed dashboards and set up interaction between your platform and the embedded dashboards. Check out the developer documentation to get started with Cumul.io’s APIs.
And that’s it!
With this guide, you’re all set to say goodbye to Chartio for good, and welcome Cumul.io to your data stack. 🙌 You’ll love the beautiful-looking dashboards, the easy user interface and the embedded capabilities it provides!
While you migrate from Chartio to Cumul.io, these additional resources and documentation will be useful: