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. In the Repository Information tab, provide a name for your connection and create a password for repository. Click Next.



3. Choose a previously configured DSN and click Next.

   

4. Select Tables as Relational Source.



5. Select the table you want to get the data from and click Import button. Click Finish.



6. 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.



7. Expand the drop-down list, right click on table and select View data.