Increasing demand for accessing Google BigQuery data via BI tools means more requests to test our Simba drivers for BigQuery. While a variety of applications have built-in connectors to BigQuery, many enterprises still have difficulty establishing connectivity between BigQuery and BI tools like Power BI.

The Simba ODBC driver typically allows much more granular configuration options than BI tools.  This allows you to tune the connection for your specific requirements, sometimes unlocking significant performance or capability benefits.

In this blog, we will guide you through the three steps to easily install and configure the Magnitude Simba Google BigQuery ODBC connector for accessing GBQ data in your BI tool.

  1. Download and install the Simba Google BigQuery ODBC connector.
  2. Allocate the license.
  3. Configure Simba BigQuery ODBC connector.

Let’s dive deeper into each step.

1. Download and install the Simba Google BigQuery ODBC connector.

  1. You should choose the platform on which you will run your installation before accessing the form. For our example we will be using Windows version. After downloading the connector, double click the MSI file to install it:

    BigQuery-ODBC-Driver-Download

  2. Click NEXT to accept the licensing agreement
    BigQuery_ODBC_Driver-License


  3. Click NEXT to provide the directory where you’ll install the driver:
    Google BigQuery_Install_folder
  4. Click INSTALL to proceed to installation
    Google BigQuery Installation

    Let the installer complete the installation and click “Finish.”

2. Allocate the license.

Once you have installed the connector, verify that the license file is in the correct location. It must be in the /lib/ folder underneath where the connector has been installed.

NOTE: The license file is sent via email after you submit the form. If you have not received the license, check your junk folder.

Google BigQuery ODBC Driver Install license

3. Configure Simba BigQuery ODBC connector and test your connection.

  1. Click SEARCH and go to ODBC Administrator

    Google BigQuery ODBC Driver Configuration

  2. Click on the System tab and look for the Simba Google BigQuery ODBC DSN.

    Select it and press CONFIGURE to go to the Simba Google BigQuery ODBC DSN setup window.

    Google BigQuery ODBC Driver Configuration 2



  3. In the DSN you will need to adjust all settings appropriate to your case

    NOTE: For the detailed configuration options for Catalog/Project, Dataset, settings please see our documentation.

    Google BigQuery ODBC Driver Configuration DNS

  4. Test your connection

    When you have completed your configuration click TEST

    Google BigQuery ODBC Driver Configuration DNS Test

    Connection test is successful!
    Now, click OK on the test window and on the DSN setup window to save your configuration.

Simba Tip

Need Help?
If your test did not succeed, check your configuration and try again. If you ran into trouble installing and configuring your connector, check out the installation guide and our FAQ or contact our support team.

As you have successfully installed, configured and tested your driver connection with Simba Google BigQuery ODBC connector you can test access to BigQuery data in any BI tool.

Simba Eval

Need to get Google BigQuery data into your BI tool? Download the Google BigQuery ODBC driver or Talk to us about your use case.


Learn more:

How to connect Google BigQuery to Power BI
How to Connect Google BigQuery to Microsoft Excel.