Getting Started With Devart ODBC Driver for Google BigQuery
ODBC is a standard API developed by Microsoft that allows applications to access data across different database management systems (DBMS) using a set of functions, regardless of the database type.
Devart ODBC Driver for Google BigQuery is a high-performance connectivity solution with enterprise-level features that enable access to, analysis of, and reporting on BigQuery data from ODBC-compliant tools on Windows. The Driver processes standard ODBC function calls, submits SQL statements to BigQuery, and returns results to the application.
In an ODBC architecture, applications connect to an ODBC Driver Manager, which then communicates with the appropriate ODBC driver to access the target data source. With Devart ODBC Driver for Google BigQuery, applications can connect to the data source directly over HTTPS, and if direct HTTPS access is unavailable, the driver can also work through a proxy server.
This guide walks you through the installation, configuration, and connection setup to BigQuery using the Devart ODBC Driver.
Advantages of the ODBC Driver for Google BigQuery
Native data connectivity
Devart ODBC Driver for Google BigQuery fully supports standard ODBC API functions and data types. It enables easy and secure access to live BigQuery data from anywhere and is compatible with the Google BigQuery API itself.
Real-time data access
The Driver allows ODBC-compliant applications to work with Google BigQuery data as with a regular database, enabling reading, writing, updating, and deleting data in large tables using SQL statements.
Integration
Devart ODBC Driver for Google BigQuery is compatible with third-party tools for data analysis, BI, ETL, and development, including Microsoft Excel and Visual Studio, as well as many other ODBC-aware environments.
Cost-effective deployment
Devart ODBC Driver for Google BigQuery is delivered as a standalone installation file and does not require additional client software or vendor libraries, which simplifies rollout and reduces deployment costs.
Platform support
ODBC Driver for Google BigQuery can be used with 32-bit and 64-bit applications on supported Windows environments. The download page currently offers the Windows installer for version 1.7.
Fully Unicode-compliant
The Driver is fully Unicode-compliant, allowing applications to correctly retrieve and modify multilingual data regardless of character set or language environment.
Installation process
Installing the Devart ODBC Driver for Google BigQuery is straightforward. All you need is to download it to your computer and follow the installation wizard. Currently, the download page provides the Windows installer.
Download ODBC Driver for Google BigQuery from the Devart website, open it, and click Next.
Follow the steps of the wizard: accept the license agreement and select the destination folder for the Driver. On the Select Components page, choose the required version and click Next. Optionally, you can also install Help and Manual.
To activate the Driver immediately after installation, select Input activation key or the Trial evaluation, and enter your key. You can find it in the registration email or your Customer Portal. For that, click Get Activation Key.
If you decide not to complete activation during setup, you can activate the Driver later by selecting Activate product later. If the activation key is saved on your computer, click Load Activation Key and select the corresponding file.
Important!
Make sure to activate the Driver even for the trial version.
Complete the installation by clicking Next to proceed and then press Finish to complete it.
ODBC Driver for Google BigQuery can be installed using Silent installation on Windows as well.
Configuring an ODBC data source
After installing the Devart ODBC Driver for Google BigQuery, you need to create a Data Source Name (DSN) for your ODBC connection and verify the connection details. Follow the steps described below to configure the Driver on Windows.
Open the ODBC Data Source Administrator, select User DSN or System DSN, and click Add. In the dialog box, select Devart ODBC Driver for Google BigQuery and click Finish.
In the setup dialog, enter the connection information in the appropriate fields.
For a basic connection, use the required BigQuery-specific parameters, such as Project ID, Dataset Id, and Refresh Token.
Devart's documentation shows a sample connection string in the following format:
DRIVER={Devart ODBC Driver for Google BigQuery};Project ID=myprojectid;DataSet Id=mydatasetid;Refresh Token=myrefreshtoken
Note
Most applications work with both User DSN and System DSN, but some require a specific one.
Test ODBC connection
To test an ODBC connection on Windows, click Test Connection in the configuration dialog.
If all parameters are valid, the Driver displays a success message.
For more advanced setup details, connection string parameters, and usage instructions, refer to the Devart ODBC documentation.
Conclusion
Devart ODBC Driver for Google BigQuery enables reliable and efficient access to cloud warehouse data. It provides direct HTTPS connectivity, supports standard ODBC API functions and BigQuery data types, and ensures Unicode compliance, as well as compatibility with a wide range of analytics, BI, ETL, and development tools.
You can evaluate Devart ODBC Driver for Google BigQuery firsthand. Download the fully-functional free trial, follow the installation steps, and begin working with your Google BigQuery data effortlessly!
ODBC Drivers
Reliable and easy-to-use data connectors for ODBC data sources. Compatible with multiple third-party tools.
