Bold BI

Integration with Cloud Hub Data Connectors

Integration with Cloud Hub Data Connectors

CData Cloud Hub provides data connectivity for more than 100 different cloud data sources with virtual database connections using the wire protocol database of MySQL instances. It enables integration with other cloud applications to connect their data sources using MySQL instances in an easy and secure manner. If you are new to the CData Cloud Hub, request a trial. Now that Syncfusion has partnered with CData Software, you can connect Syncfusion’s business intelligence dashboard platform, Bold BI, to any CData-supported data connector, including Shopify, Snowflake, Zoho CRM, and HubSpot. The virtual MySQL endpoint is provided by CData Cloud Hub for both cloud and on-premises versions.

In this blog, let’s see how to connect Northwind Traders Sales data in Google Sheets through creating a virtual database in the CData Cloud Hub and then create a live, interactive dashboard visualizing that data. CData Cloud Hub allows you to create a virtual database for any supported connector and make it available as a standard SQL interface.

If you are new to Bold BI dashboards, register for a free trial on our website. At the end of the registration process, you will reach the following page view.

Homepage view of Bold BI
Homepage view of Bold BI

Creating a virtual database in CData Cloud Hub

In your CData Cloud Hub, click the Google Sheets data source and create a virtual database by logging into your Google account.

Selecting Google Sheets in CData Cloud Hub
Selecting Google Sheets in CData Cloud Hub
Creating virtual database for Google Sheets
Creating virtual database for Google Sheets
Showing available databases in CData Cloud Hub
Showing available databases in CData Cloud Hub

Once you’ve authenticated and saved the Google Sheets virtual database, you are ready to connect to Bold BI with the MySQL endpoint.

Creating a sales dashboard

If you are new to data source creation, refer to Introduction to Bold BI Data Sources.

To create your dashboard, first connect to the Bold BI MySQL data source with the CData Cloud Hub MySQL instance in live mode. Live mode fetches the data from the database server by executing the query every time. Hence the dashboard shows the latest metrics in real time for live connections.

Selecting MySQL data source in Bold BI
Selecting MySQL data source in Bold BI

Once connected to the MySQL data source, the Google Sheets associated with your Google account will be shown as a table. Drag the required table to the canvas and save the data source.

Drag and drop tables into data source design window
Drag and drop tables into data source design window

Now you are all set to create a dashboard. Check out the How to Create a Dashboard video tutorial to get started with dashboard creation.

Bold BI Dashboard - Northwind Trade Sales Analysis
Northwind Trader Sales Analysis Dashboard
Bold BI Dashboard - filtered by UK country
Bold BI Dashboard – filtered by UK country
Bold BI Dashboard - filtered by Spain county
Bold BI Dashboard – filtered by Spain country

In the above sample dashboard, you can see the metrics of orders and total sales by country and product. You can also filter the data by selecting a specific country on the map widget. Now you can share your dashboard with your team and start to collaborate on the Bold BI dashboard online.

If you have any questions, please post them in the comments section below. You can also contact us by submitting your questions through the Bold BI website, or if you already have an account, you can log in to submit your support question. Bold BI dashboards now come with a 15-day free trial with no credit card information required. We welcome you to start a free trial and experience Bold BI for yourself.

Start your free 15-day trial today

Leave a Reply