Installing and setting up the driver (UNIX/Linux)
- Last Updated:May 13, 2024
- 3 minute read
- DataDirect Connectors
- ODBC
- Google Bigquery 8.0
- Documentation
This section provides you with an overview of the steps required to install and set-up the driver. After completing this procedure, you will be able to begin accessing data with your application.
To begin accessing data with the driver:
-
Install the driver:
- After downloading the product, extract the contents of the product file.
-
From the installer directory, run the installer's
binary file to start the installer. The file for the installer program takes the
following form:
PROGRESS_DATADIRECT_ODBC_nn_LINUX_xx_INSTALL.bin
- Follow the prompts to complete installation.
The installer program supports multiple installation methods, including command-line and silent installations. For detailed instructions, refer to the Progress DataDirect for ODBC Drivers Installation Guide.
-
Configure the environment variables:
- Check your permissions: You must log in as a user with full r/w/x permissions recursively on the entire product installation directory.
-
Run one of the following product setup scripts from
the installation directory to set variables: odbc.sh or odbc.csh. For Korn,
Bourne, and equivalent shells, execute odbc.sh.
For a C shell, execute odbc.csh. Executing the
setup script:
- Sets the ODBCINI environment variable to point to the path from the root directory to the system information file where your data source resides. For details, see ODBCINI.
- Sets the library path environment variable
for your operating system,
LD_LIBRARY_PATH
, to include the directory containing your JVM’s libjvm.so file. For details, see Library search path.
-
Set the ODBCINI environment variable to point to the
path from the root directory to the system information file where your data source
resides. For example, if you use an installation directory of /opt/odbc and the default system information file name,
you would enter:
- Korn or Bourne shell: ODBCINI=/opt/odbc/odbc.ini; export ODBCINI
- C shell: setenv ODBCINI /opt/odbc/odbc.ini
-
Set the library path environment variable for your
Linux operating system to include the directory containing your JVM’s libjvm.so file, and that directory’s parent directory.
The Library Path Environment Variable on Linux is
LD_LIBRARY_PATH
.
-
Configure the driver using one of the following
methods:
- odbc.ini file: You can begin using the
driver immediately by editing the odbc.ini file in
the installation directory with a text editor. The following demonstrates a data source
definition with the minimal
options.
[ODBC Data Sources] Google BigQuery=DataDirect 8.0 Google BigQuery [Google BigQuery] Driver=ODBCHOME/lib/xxgbq28.yy Project=myproject Dataset=mydataset AccessToken=abcdefghi12345678 RefreshToken=wxyz123456789 ClientID=123abc.apps.googleusercontent.com ClientSecret=ab123xy
See Configuration through the system information (odbc.ini) file for more information.
Note: The User and Password options are not required to be stored in the data source. They can also be sent separately by the application using the SQLConnect ODBC API. For SQLDriverConnect and SQLBrowseConnect, they will need to be specified in the data source or connection string. OAuth 2.0 access token flow
[ODBC Data Sources] Google BigQuery=DataDirect 8.0 Google BigQuery
[Google BigQuery] Driver=ODBCHOME/lib/xxgooglebigquery28.yy ... ClientID=client_id ... ClientSecret=client_secret ... AccessToken=access_token ...
See Configuration through the system information (odbc.ini) file for more information.
- Connection string: The driver also supports using connection strings for DSN (data source name), File DSN, or DSN-less connections. See Using a connection string and DSN-less connectionsfor more information.
Note: For most connections, specifying the minimum required connection options is sufficient to begin accessing data; however, you can provide values for optional connection options to use additional supported features and improve performance. - odbc.ini file: You can begin using the
driver immediately by editing the odbc.ini file in
the installation directory with a text editor. The following demonstrates a data source
definition with the minimal
options.
-
Set the values for any additional options that you
want to configure. For additional information on optional features and functionality, see
the following resources:
- Connection option descriptions provides a complete list of supported options by functionality.
- Performance considerations describes connection options that affect performance, along with recommended settings.
-
Connect to your Google BigQuery instance and begin
accessing data with your applications, BI tools, database tools, and more. To help you get
started, the following resources guide you through accessing data with some common
tools:
- Example application: The example application allows you to test connect, execute SQL statements, and practice using the ODBC API right out of the box.
- Tableau: Tableau is a business intelligence software program that allows you to easily create reports and visualized representations of your data.
- Microsoft Excel: Excel is a spreadsheet tool that allows you to connect, view tables, and execute SQL statements against your data.
This completes the deployment of the driver.