JDBC TUTORIAL

How to Build Tableau reports on Google BigQuery Data Using the Progress DataDirect Google BigQuery Driver for JDBC

Updated: 28 Nov 2022

Introduction

Progress DataDirect’s Google BigQuery JDBC Driver offers a high-performing, secure and reliable connectivity solution, for JDBC applications to access Google BigQuery data. You can use it to create or analyze reports with tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more. In this tutorial, you will learn how to configure the DataDirect Google BigQuery driver within Tableau Desktop to create reports. These steps can also be used to configure any JDBC connection with Tableau.

Prerequisites

  1. Download and install the Progress DataDirect Google BigQuery JDBC driver using the 15-day trial software. In this tutorial, we are connecting to Google BigQuery.
  2. Installing the driver:
    • If you are on Windows, extract the PROGRESS_DATADIRECT_JDBC_GOOGLEBIGQUERY_WIN.zip and run the PROGRESS_DATADIRECT_JDBC_INSTALL.exe to install the JDBC driver.
    • If you are on Linux, extract the PROGRESS_DATADIRECT_JDBC_GOOGLEBIGQUERY_WIN.zip and run the PROGRESS_DATADIRECT_JDBC_INSTALL.jar to start the installation.
  3. After you have completed the installation, you can find the Progress DataDirect Google BigQuery Driver jar file.
    • On Windows, you will find it at C:\Program Files\Progress\DataDirect\JDBC_60\lib\googlebigquery.jar
    • On Linux, you will find it at /home//Progress/DataDirect/JDBC_60/lib\ googlebigquery.jar

Configure Connection to Google BigQuery Using the Configuration Manager

  1. Progress DataDirect Google BigQuery JDBC connector comes with a JDBC Configuration Manager that helps you configure the connection to your Google BigQuery instance easily.
  2. To Launch the Google BigQuery JDBC Configuration Manager, double click the googlebigquery.jar at Program Files \ Progress \ DataDirect \ JDBC_60 \ lib \ googlebigquery.jar, or run using java -jar googlebigquery.jar
  3. You should now see the below configuration manager launched in your browser.
    DCI database tab project input focused and set to project, dataset set to dataset, database name set to database name and syntax set to standard
  4. Provide your credentials for your Google BigQuery instance in the “Database” and “Connection” tabs in all valid text boxes. You can learn how to get the client id, client secret, access token, and refresh token here and scope is https://www.googleapis.com/auth/bigquery
    dci connection tab; client id, client secret, access token and refresh token are filled, scope is set to scope
  5. Click on “Test Connect.” Now you should see the list of tables exposed by the Progress DataDirect Google BigQuery JDBC driver.
    test connection dialog with test query field filled with a sample SQL query
  6. The configuration manager creates a JDBC connection string dynamically based upon the properties defined. You can copy the JDBC connection string so that you can start using the Progress DataDirect Google BigQuery JDBC driver with other applications or in your programs.

Connecting Tableau to Google BigQuery

  1. Below you will find an example of using the Progress DataDirect Google BigQuery driver with Tableau. Keep in mind that Google BigQuery driver can be used with any JDBC (or ODBC)-compliant application.
  2. To get started, copy googlebigquery.jar from the Progress install location to Tableau’s driver location.
    • For Windows: copy googlebigquery.jar to C:\Program Files\Tableau\Drivers
    • For Mac: copy googlebigquery.jar to ~/Library/Tableau/Drivers
  3. Open Tableau and create a new data source.
    • Select “Other Databases (JDBC).”
      connect dialog; other databases (jdbc) option highlighted in the to a server category
    • The pop-up window will appear.
      other databases (jdbc) window; url input focused and empty; dialect set to SQL92, username set to user, password filled and an empty properties file input
    • Copy and paste the JDBC connection string created above using the Progress DataDirect Configuration Manager into the “URL” textbox. Enter credentials for username and password.
      other databases (jdbc) window; url field set to the connection string, dialect set to SQL92, username set to user, a filled password field and an empty properties file field
  4. Click on “Sign In,” which will then have the Tableau connect to Google BigQuery. The configuration screen will appear.
    tableau empty view showing the drag tables here message
  5. You can use Tableau's schema and table drop-down list to browse and select your data, or you can execute SQL statements by clicking on the "New Custom SQL" option. The image below shows the schemas on the left-hand side and the relationship between BITABLE and GTABLE being displayed.
    tableau bitable+ schema setup
  6. Once Tableau can access your relevant data, you can easily create reports, like shown below:
    tableau sample report showing an example bar chart

Conclusion

We hope this tutorial helped you to get started with the Progress DataDirect Google BigQuery JDBC Driver. Please feel free to contact us if you have any questions about using the driver and we will be happy to help you.

Connect any application to any data source anywhere

Explore all DataDirect Connectors

Need additional help with your product?

Get Customer Support