Preface
Introduction to PowerExchange for Google BigQuery
PowerExchange for Google BigQuery Configuration
- PowerExchange for Google BigQuery Configuration Overview
- Registering the PowerExchange for Google BigQuery Plug-in
  - Registering the PowerExchange for Google BigQuery Plug-in from the Administrator Tool
  - Registering the PowerExchange for Google BigQuery Plug-in from the Command Line Program
Google BigQuery Sources and Targets
Google BigQuery Mappings
- Google BigQuery Mappings Overview
- Source Filter
  - Configuring a Source Filter
Google BigQuery Sessions
Google BigQuery as CDC Target
Google BigQuery Pushdown Optimization
Appendix A: Google BigQuery Data Type Reference
- Data Type Reference Overview
- Google BigQuery and Transformation Data Types

PowerExchange for Google BigQuery User Guide for PowerCenter

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7

Back Next

Configuring a Google BigQuery ODBC Connection

You can set the pushdown optimization for the ODBC connection type that uses the Google BigQuery ODBC driver to enhance the session performance. To use an ODBC connection to connect to Google BigQuery, you must configure the ODBC connection.

After you create a Google BigQuery ODBC connection, set the value of the

Pushdown Optimization

property as

Full

in the

Performance

section on the

Properties

tab of the session.

You cannot configure target-side pushdown optimization by using Google BigQuery ODBC driver.

Google BigQuery supports Google BigQuery ODBC drivers on Windows and Linux systems. You can install one of the following 64-bit drivers based on your system requirement:

2.2.5.1012 version of the Informatica ODBC Driver for Google BigQuery

2.1.19.1024 version of the Simba ODBC Driver for Google BigQuery

Google BigQuery Pushdown through ODBC Connection

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal