It's now possible to visualize any data from any tool in Databox.
Part of the reason why Databox is so easy to setup is that we have built and we maintain 100+ deep integrations with popular tools that make it easy. Once we build a native integration with a tool like HubSpot, Google Ads, Youtube, Quickbooks, etc, etc, the dashboard and report setup process process becomes simple for a Databox user:
1️⃣ Connect via OAuth (all you need is your id and password)
2️⃣ Select from a list of pre-built metrics specific to each integration and add them to a dashboard, report, scorecard, set a goal, build a forecast model, etc, etc.
3️⃣ Browse pre-built dashboard and report templates which include groups of metrics in the visualizations you'd expect.
In other words, you can have live dashboards in minutes.
This is in stark contrast with typical business intelligence tools that require hours, if not days, of a developer’s or analyst’s time.
We wish we could build a native integration with every tool out there. But, we do not have the resources to build every integration that every customer could want.
In the past, we had an API that allowed a customer to push in data for one metric at a time (a value, a time stamp and a dimension).
This was limiting for a variety of reasons:
➡️ They'd have to write and host code that pulled data from APIs and formatted it the way our system required.
➡️ They'd have to write code for every metric they wanted to track.
➡️ If something changed in the way a customer stored their data, they'd have to update their 3rd-party code.
Our new ingestion API (https://lnkd.in/eFhFGknk) eliminates these limitations.
It does this by allowing our customers to push us tables of data. You can still write and host your own code to pull the data from another system and send it into Databox.
But, the smarter thing to do is to use an ETL tool. (Stands for Extract, Transform, Load.)
As part of launching this new API, we have also launched a partnership with Dataddo (https://lnkd.in/e-R9bTmj). Dataddo makes it easy to pull data in from any system and push it out to any destination. They’ve also built connectors with 300+ SaaS tools with plans to have 450 by the year's end, which makes the authentication process very quick and easy, just like in Databox.
Once you push the data into Databox via our ingestion API or from Dataddo, you can then filter and merge datasets, calculate new values and build metrics that can be used on dashboards, reports, scorecards, as goals, etc.
We'll continue to maintain and build new integrations for the most popular SaaS tools and services, in order to make setting up dashboards and reports as easy as possible.
But with our new ingestion API, tools like Dataddo can help our customers push data into Databox from anywhere.
