ODBC Driver for Google BigQuery

Connecting Oracle BI to Google BigQuery via ODBC Driver

Importing Data from Google BigQuery into Oracle BI Through an ODBC Connection

Oracle BI is a set of analytical tools by the Oracle Corporation that support many different data sources, including relational databases, OLAP systems, and files, and combine data from these sources in a single report. Using a corresponding ODBC driver, you can fast connect to Google BigQuery to gain access to relevant information.

This article explains how to connect to Google BigQuery and import data into Oracle BI Administration Tool using an ODBC driver. It is assumed that you have already installed and configured a DSN for the ODBC driver for Google BigQuery.

To connect to an ODBC data source from Oracle BI using our Google BigQuery driver, follow the next steps:

  1. Run Oracle BI Administration Tool and click File>New Repository.
  2. New Repository in Oracle BI

  3. In the Repository Information tab, provide a name for your connection and create a password for repository. Click Next.
  4. Repository Information

  5. Choose a previously configured DSN and click Next.

    Select Data Source to Connect

  6. Select Tables as Relational Source.
  7. Select Metadata Type

  8. Select the table you want to get the data from and click Import button. Click Finish.
  9. Select Metadata Objects

  10. Now, to view data from the selected table, you need to specify the backtick sign (`) as a value for the Identifier Quote Char field. To do this, double-click on the installed DSN and go to Features.
  11. Database Features

  12. Expand the drop-down list, right click on table and select View data.
  13. Retrieve data from the table

    View data from the data source

© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback