In Databox, you can connect your SQL Database and visualize its data on Dashboards that you can then share via a Live URL, via email, Slack, and more.
Connect your SQL Database to Databox
Browse the different SQL integrations here: SQL Integrations in Databox.
Build metrics
Once you've connected your database, use our Metric Builder tool to get started with building your metrics. Here are a few pointers to keep in mind:
You need to select a date column and a value column. Selecting both in a query is mandatory. Specifying a dimension (attribute) is optional though.
The query must contain a column named "Date." If you need to, use "AS date" in your SELECT statement to satisfy this requirement.
Make sure your Firewall is open to Databox's public IP (52.4.198.118) and your Port is correctly forwarded to the server.
You can connect SQL databases using an SSH tunnel by following these steps.
"Null" values will not be recognized. Use a COALESCE function when needed.
Visualize your metrics on a Databoard
Navigate to the Databoards page and create a new Databoard. You can either use our wizard that will guide you to select your SQL metrics to display on the databoard, or create a blank databoard and manually select what metrics you want to visualize by clicking the "+" icon on the databoard.
Share your Databoard via Live URL
Click on Share to open up the sharing settings. There, you can set up a shareable URL link that can be copied and shared with others or sent via email or Slack.
PRO TIP: You can add multiple Databoards into a single loop to easily navigate all Databoards through one link. For this, navigate to the Looped Databoards page to set this up.
What are the benefits of using a Live URL?
When sharing Databoards or Databoard Loops via a Live URL link, viewers can hover over the charts to display detailed information like comparison values and percentages.
Viewers can also change the Date Range of the Databoard to view whatever period they want to report on. If you wish to disable the ability for viewers to change date ranges, you can configure this in the sharing settings.
When sharing a Databoard Loop URL, viewers can switch between databoards/pages:
