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)法語Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC for Greenplum Wire Protocol Driver User's Guide Release 8.0.2

Tutorials

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 Greenplum Wire Protocol Driver
    • What's new in this release?
    • Driver requirements
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (UNIX/Linux)
    • Connection string examples
    • Version string information
      • getFileVersionString function
    • Driver specifications
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
    • Data Types
      • Using the XML data type
      • Retrieving data type information
  • Tutorials
    • The Example application
    • Tableau (Windows only)
    • Microsoft Excel (Windows only)
    • Power BI (Windows only)
  • Configuring and connecting to data sources
    • Environment settings
      • UNIX/Linux environment variables
        • Library search path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
        • The Test Loading Tool
      • UTF-16 applications on UNIX and Linux
    • Configuring the driver using the GUI
      • General tab
      • Advanced tab
      • Security tab
      • Failover tab
      • Pooling tab
    • Using a connection string
    • Additional configuration methods for UNIX and Linux
      • Configuration through the system information (odbc.ini) file
        • Sample default odbc.ini file
      • DSN-less connections
        • Sample odbcinst.ini file
      • File data sources
    • Password Encryption Tool (UNIX/Linux only)
    • Using a logon dialog box
    • Authentication
      • User ID/password authentication
      • Kerberos authentication
    • TLS/SSL encryption
      • Certificates
      • TLS/SSL server authentication
        • Using SQL_COPT_INMEMORY_TRUSTSTORECERT
        • Importing root certificates into the Windows certificate store
          • Importing root certificates using Certificate Import Wizard
          • Importing root certificates using a PowerShell script
      • TLS/SSL client authentication
      • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
      • Designating an OpenSSL library
    • Failover support
      • Configuring failover
      • Guidelines for primary and alternate servers
    • DataDirect connection pooling
    • Proxy server support
    • Performance considerations
  • Additional features and functionality
    • Persisting a result set as an XML data file
      • Using the Windows XML Persistence Demo tool
      • Using the UNIX/Linux XML Persistence Demo tool
    • Using arrays of parameters
    • User-defined function results
    • Packet logging
    • Using IP addresses
  • Connection option descriptions
    • Alternate Servers
    • Application Using Threads
    • Authentication Method
    • Batch Mechanism
    • Connection Pooling
    • Connection Reset
    • Connection Retry Count
    • Connection Retry Delay
    • Crypto Protocol Version
    • CryptoLibName
    • Data Source Name
    • Database Name
    • Description
    • Enable FIPS
    • Enable Keyset Cursors
    • Enable SQLDescribeParam
    • Encryption Method
    • Extended Column MetaData
    • Extended Options
    • Failover Granularity
    • Failover Mode
    • Failover Preconnect
    • Fetch RefCursors
    • Fetch TSWTZ as Timestamp
    • Fetch TWFS as Time
    • GSS Client Library
    • Host Name
    • Host Name In Certificate
    • IANAAppCodePage
    • Initialization String
    • Keyset Cursor Options
    • Key Password
    • Keystore
    • Keystore Password
    • Load Balance Timeout
    • Load Balancing
    • Login Timeout
    • Max Char Size
    • Max Long Varchar Size
    • Max Pool Size
    • Max Varchar Size
    • Min Pool Size
    • OpenSSLConfigFile
    • OpenSSLProviderPath
    • Password
    • Port Number
    • Proxy Host
    • Proxy Mode
    • Proxy Password
    • Proxy Port
    • Proxy User
    • Query Timeout
    • Report Codepage Conversion Errors
    • Service Principal Name
    • SSLLibName
    • TCP Keep Alive
    • Transaction Error Behavior
    • Truststore
    • Truststore Password
    • Unbounded Numeric Precision
    • Unbounded Numeric Scale
    • User Name
    • Validate Server Certificate
    • XML Describe Type
  • Copyright
Table of Contents

Tutorials

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: November 2, 2020
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Greenplum 8.0
    • Documentation

The following sections guide you through using the driver to access your data with some common third-party applications. For information on installing your driver and setting the CLASSPATH, see "Installing and setting-up the driver (Windows)" or "Installing and setting-up the driver (Linux)."

Contents
  • The Example application
  • Tableau (Windows only)
  • Microsoft Excel (Windows only)
  • Power BI (Windows only)
TitleResults for “How to create a CRG?”Also Available inAlert