Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC for Google BigQuery User's Guide Release 8.0.0

Using the driver

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for ODBC for Google BigQuery Driver
    • What's new in this release?
    • Driver requirements
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (UNIX/Linux)
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Data types
    • Standard and legacy SQL support
      • Using identifiers
    • Troubleshooting
    • Contacting Technical Support
  • Tutorials
    • The Example application
    • Accessing data in Tableau (Windows only)
    • Accessing data in Microsoft Excel (Windows only)
    • Accessing data in Microsoft Excel from the Query Wizard (Windows only)
  • Using the driver
    • Configuring and connecting to data sources
      • Configuring the product on UNIX/Linux
        • Environment variables
          • Library search path
          • ODBCINI
          • ODBCINST
          • DD_INSTALLDIR
        • The test loading tool
        • Data source configuration on UNIX/Linux
          • Configuration through the system information (odbc.ini) file
            • Sample default odbc.ini file
        • DSN-less connections
          • Sample odbcinst.ini File
        • File data sources
        • UTF-16 applications on UNIX and Linux
      • Setting the library path environment variable (Windows)
      • Configuring data sources with the Configuration Manager
      • Generating connection strings with the Configuration Manager
      • Using a connection string
      • Testing connections and queries with the Configuration Manager
      • Password Encryption Tool (UNIX/Linux only)
      • Using a logon dialog box
    • Connecting through a proxy server
    • Using security
      • Authentication
        • Configuring OAuth 2.0 authentication
          • Dynamic authorization code grant
        • Configuring service account authentication
        • Generating access tokens and refresh tokens
    • Performance considerations
    • Internal and external tables support
    • Google BigQuery Storage API
    • Google BigQuery Streaming API
    • DataDirect connection pooling
    • Timeouts
    • Isolation and lock levels supported
    • Unicode support
    • Parameter metadata support
      • Insert and Update statements
      • Select statements
  • Using the SQL engine server
    • Configuring server mode using the Configuration Manager
      • Stopping the SQL engine server using the Configuration Manager
    • Configuring the SQL engine server using Java options
      • Stopping the SQL engine server
    • Configuring Java logging for the SQL engine server
  • Connection option descriptions
    • Access Token
    • Allow Large ResultSet
    • Application Using Threads
    • Authentication Method
    • Auth URI
    • Binary Length
    • Client ID
    • Client Secret
    • Config Options
      • SchemaSet (Config Option)
      • VarcharLength (Config Option)
    • Connection Pooling
    • Connection Reset
    • Create Map
    • Dataset
    • Data Source Name
    • Description
    • Enable Login Prompt
    • Enable Catalog Support
    • Fetch Size
    • Host Name
    • IANAAppCodePage
    • Job Timeout
    • Json Format
    • JVM Arguments
    • JVM Classpath
    • JWT Audience
    • KMSKeyName
    • Legacy Dataset
    • Legacy Table
    • Location
    • LoadBalance Timeout
    • Log Config File
    • Login Timeout
    • MaximumBytesBilled
    • MaximumBilling Tier
    • Max Pool Size
    • Min Pool Size
    • Primary Key Pattern
    • Project
    • Proxy Host
    • Proxy Password
    • Proxy Port
    • Proxy User
    • Redirect URI
    • Refresh Schema
    • Refresh Schema For DDL
    • Refresh Token
    • Report Codepage Conversion Errors
    • Retry Exceptions
    • Schema Map
    • Scope
    • Server Port Number
    • Service Account Email
    • Service Account Key Content
    • Service Account Private Key
    • SQL Engine Mode
    • Storage API Min Page Count
    • Storage API Threshold
    • Syntax
    • Token URI
    • Use Query Cache
    • Use Storage API
    • Use Streaming Insert
    • WS Fetch Size
    • WS Pool Size
    • WS Retry Count
    • WS Timeout
  • Copyright
Table of Contents

Using the driver

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: February 16, 2021
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Google Bigquery 8.0
    • Documentation

This section guides you through the configuring and connecting to data sources. In addition, it explains how to use the functionality supported by your driver.

Contents
  • Configuring and connecting to data sources
  • Connecting through a proxy server
  • Using security
  • Performance considerations
  • Internal and external tables support
  • Google BigQuery Storage API
  • Google BigQuery Streaming API
  • DataDirect connection pooling
  • Timeouts
  • Isolation and lock levels supported
  • Unicode support
  • Parameter metadata support
TitleResults for “How to create a CRG?”Also Available inAlert