Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.5.6
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Google BigQuery
  3. PowerExchange for Google BigQuery Configuration
  4. Google BigQuery Sources and Targets
  5. Google BigQuery Mappings
  6. Google BigQuery Sessions
  7. Google BigQuery as CDC Target
  8. Google BigQuery Pushdown Optimization
  9. Appendix A: Google BigQuery Data Type Reference

PowerExchange for Google BigQuery User Guide for PowerCenter

PowerExchange for Google BigQuery User Guide for PowerCenter

Back Next

Configuring the Google BigQuery ODBC Driver on Windows

Configuring the Google BigQuery ODBC Driver on Windows

To establish an ODBC connection to connect to Google BigQuery on Windows, install the 64-bit Google BigQuery ODBC driver on the machine where the PowerCenter Integration Server runs. Install the 32-bit ODBC driver on the machine where you install the PowerCenter Client.
After you install the driver, configure the Data Source Name (DSN) in the ODBC Data Source Administrator.
  1. Click
    Start
    Control Panel
    .
  2. Click
    Administrative Tools
    .
  3. Click
    Data Sources (ODBC)
    .
    The
    ODBC Data Source Administrator
     dialog box appears.
  4. Click the
    System DSN
     tab.
    The
    System DSN
     tab appears. The following image shows the System DSN tab on the ODBC Data Source Administrator (64-bit) dialog box:
    The image shows the System DSN on the ODBC Data Source Administrator (64-bit) dialog box.
  5. Click
    Add
    .
    The
    Create New Data Source
     dialog box appears. The following image shows the Create New Data Source dialog box where you can select the Google BigQuery data source:
    The following image shows the Simba ODBC driver for Google BigQuery available for your operating system
  6. Select
    Simba ODBC Driver for Google BigQuery
     to set up the data source.
  7. Click
    Finish
    .
    The
    Simba ODBC Driver for Google BigQuery DSN Setup
     dialog box appears.
    The following image shows the connection properties in the
    Simba ODBC Driver for Google BigQuery DSN Setup
     dialog box: The following image shows the connection configuration properties in the Simba ODBC Driver for Google BigQuery DSN Setup dialog box
  8. Configure the connection properties.
    The following table describes the connection properties that you must configure:
    Property
    Description
    Data Source Name
    Enter a name for the data source. The ODBC Driver for Google BigQuery uses the DSN to connect to the Google BigQuery.
    Description
    Enter a description.
    OAuth Mechanism
    The OAuth 2.0 authentication mechanism used to authenticate the driver. Select the
    Service Authentication
     option to authenticate the driver through a Google service account.
    If you select the
    User Authentication
     option, you will need to sign in to your Google service account. Click on
    Sign In
     and in the browser that opens, enter your credentials and then click
    Sign In
    . Click
    Accept
     to allow the Google BigQuery Client Tools to access Google BigQuery objects.
    Confirmation Code
    Code that Google provides when you click
    Accept
    . Copy and paste the code in the
    Confirmation Code
     field.
    Refresh Token
    The OAuth Mechanism populates the
    Refresh Token
     field when you paste the confirmation code.
    Email
    Specify the Google service account email id. This field is needed to authenticate the service account.
    Key File Path
    Enter the path to the .p12 or JSON key file that is used to authenticate the Google service account.
    Request Google Drive scope access
    Allows the driver to access Google Drive so that the driver can support federated tables that combine Google BigQuery data with data from Google Drive.
    Trusted Certificates
    Path of the
    .pem
     file. Use the trusted CA certificates from a specific
    .pem
     file or use the trusted CA certificates
    .pem
     file that is installed with the driver.
    If you specify the Trusted Certificates .pem file path, you do not need to select the
    Use System Trust Store
     option.
    Use System Trust Store
    If you select the
    Use System Trust Store
     option, you do not need to specify the Trusted Certificates
    .pem
     file path.
    Catalog (Project)
    Name of the Google BigQuery project associated with your billing account that the Simba ODBC Driver for Google BigQuery queries against.
  9. Click
    Proxy Options
     to configure the connection to a data source through a proxy server.
  10. Click
    Advanced Options
     to configure the Simba ODBC Driver for Google BigQuery advanced properties. To perform pushdown optimization, select
    Standard SQL
     from the
    Language Dialect
     option in the
    Advanced Options
     dialog box.
    Simba ODBC Driver for Google BigQuery does not support Legacy SQL.
  11. To enable logging, click
    Logging Options
    .
  12. Click
    Test
     to verify the connection to Google BigQuery.
  13. Click
    OK
     to close the
    Simba ODBC Driver for Google BigQuery DSN Setup
     dialog box.
  14. Click
    OK
     to close the
    ODBC Data Source Administrator
     dialog box
0 COMMENTS
We’d like to hear from you!