Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

Connecting to Your BI Tools

You’ve likely already selected an analytics partner, so we won’t go too deep into the similarities and differences between them. Based on our experience with BI and analytics technologies, we’ve linked to detailed guides below on how to get started on what to look out for when connecting them to SingleStore.

In these examples, you’ll be using your client endpoint here provided in Portal, along with the credentials you used when spinning up your cluster. You will want to make sure that the inbound IP whitelist within the “Firewall” section of the portal allows communication between your BI and SingleStore Managed Service environments.

Tableau

Documentation

Quick Setup Walkthrough

Notes: Tableau has a limitation of auto updates at most one per hour, so you may not see your real-time data updating within your dashboard by the second. However, you can manually refresh in Tableau to see freshly ingested data.

Power BI

Documentation

Quick Setup Walkthrough

Notes: Make sure you are using DirectQuery mode to truly harness the power of SingleStore and all of the data you have stored. Otherwise, you will be using Import mode to bring only a subset of data into PowerBI. This will also help you harness the power of your real-time data.

Looker

Documentation

Quick Setup Walkthrough

Notes: Looker allows dashboards to update up to the second, so be sure to watch the video in (b) to see how to configure that. This is very beneficial to showcase the speed of data ingest with SingleStore.

Other Third-Party Integrations

Analytics and BI Tools