A Connection between SyncFusion Dashboard and Google Bigquery is possible?

[Cristian David Cañarte]

Hello Community,

Now I got involved in a project that´s required to make queries quickly, and we have the access to Google tools Bigquery and the Syncfusion Dashboard. Our objective is to try to connect both platforms (the first to make queries, and second to show Dashboard towards our customers. Anyone know how to do it?

Thank you.

[Suriya]

Hi Cristian, 

 

You can connect with Google Big query using ODBC ANSI SQL connection in our Dashboard Designer. Please below find the documentation of ODBC ANSI SQL connection, 

https://help.syncfusion.com/dashboard-platform/dashboard-designer/connecting-via-odbc-ansisql  

Currently, the below limitations are applicable for Google Bigquery.    

• The Field/Table/Dataset name must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_), and must start with a letter or underscore.
• Maximum length for table, dataset, and job ids are 1,024 characters. Maximum length for field name is 128 characters.

Note:  In Google BigQuery, few features are not supported in Live Mode. For those functions that do not support ANSI SQL 92 in Live Mode, you can switch to Extract Mode where you can get the desired result.  Please choose StandardSQL option from Language Dialect during connecting Google Bigquery ODBC driver.    

 

Once data source is configured, you can compose the dashboard with different widgets and it can be saved or published to our Dashboard Server and it can be showed to your users. 

 

Compose a dashboard: https://help.syncfusion.com/dashboard-platform/dashboard-designer/compose-dashboard/compose-dashboard 

Save or Publish a dashboard: https://help.syncfusion.com/dashboard-platform/dashboard-designer/sharing-dashboard 

 

Also you can embed your dashboard which saved in local or remote machine using the Dashboard Viewer JavaScript component by using Dashboard Platform SDK and it can be showed to your users through your Web Application. 

 

How to embed the dashboard in a Web Application: https://help.syncfusion.com/dashboard-platform/dashboard-sdk/how-to/bind-dashboard-or-widget-to-the-dashboard-viewer  

Getting started on embedding in different platforms: https://help.syncfusion.com/dashboard-platform/dashboard-sdk/getting-started/ 

 

Visit the demo dashboards in our Dashboard Server Demo: https://dashboardserver.syncfusion.com/ and Dashboard Platform SDK Server Demo: https://dashboardsdk.syncfusion.com  

 

Revert back for any further assistance. 

 

Thanks, 

Suriya