Google BigQuery Data Source

Overview

iDashboards is able to connect to a Google BigQuery Data Source by using a free propriatary JDBC driver from Simba Technologies.

Prerequisites

• Simba JDBC Driver for Google BigQuery (https://cloud.google.com/bigquery/partners/simba-drivers/)
• Google BigQuery URL with authentication

Steps

In order to access information from BigQuery, you will need to provide some kind of authentication into the Google Cloud.  For more information on Authentication types, please click here (https://www.simba.com/products/BigQuery/doc/JDBC_InstallGuide/content/jdbc/bq/options/oauthtype.htm)

In order to connect properly, all files with the .jar extension need to be placed in the drivers sub-directory of the iDashboards installation (c:\Program Files\iDashboards_SRV\ivizgroup\drivers\).  The service needs to be restarted at this point to actually load the driver.

From there, when you add the new data source, you will choose Generic JDBC.  For the Driver class, use (com.simba.googlebigquery.jdbc42.Driver).

For the Database URL, it will look something like this (jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=<Your ProjectID>;OAuthType=0;OAuthServiceAcctEmail=<Your Email-ID>;OAuthPvtKeyPath=<Your Key Path>;)

Once the Data set has been successfully connected, you will have to restart the iDashboards Service one last time to make the connection to Google BigQuery.