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 Amazon Redshift Wire Protocol Driver User's Guide Release 8.0.0

Configuring and connecting on UNIX and Linux

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 Amazon Redshift Wire Protocol Driver
    • What's new in this release?
    • Driver requirements
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Data types
      • Retrieving data type information
    • SQL support
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Getting started
    • Configuring and connecting on Windows
      • Configuring a data source
      • Testing the connection
    • Configuring and connecting on UNIX and Linux
      • Environment configuration
      • Test loading the driver
      • Configuring a data source in the system information file
      • Testing the connection
  • Tutorials
    • The Example application
    • Accessing data in Tableau (Windows only)
    • Accessing data in Microsoft Excel from the Data Connection Wizard (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
      • Data source configuration through a GUI
        • Advanced tab
        • Security tab
        • Failover tab
        • Pooling tab
        • Authentication tab
      • Using a connection string
      • Password Encryption Tool (UNIX/Linux only)
      • Using a logon dialog box
    • Performance considerations
    • Using failover
      • Connection failover
      • Extended connection failover
      • Select connection failover
      • Guidelines for primary and alternate servers
      • Using client load balancing
      • Using connection retry
      • Configuring failover-related options
        • A connection string example
        • An odbc.ini File example
    • Using security
      • Data encryption across the network
      • TLS/SSL encryption
        • Certificates
        • TLS/SSL server authentication
        • TLS/SSL client authentication
        • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
        • Designating an OpenSSL library
      • Summary of security-related options
      • Authentication
        • Basic authentication
        • Azure Active Directory authentication
        • JWT authentication
    • Isolation and lock levels supported
    • Unicode support
    • Binding parameter markers
    • Persisting a Result Set as an XML Data File
    • Packet logging
  • Connection option descriptions
    • Alternate Servers
    • Application Using Threads
    • Authentication Method
    • Auto Create
    • AWS Cluster
    • AWS DB Group
    • AWS DB User
    • AWS Region
    • Azure Client ID
    • Azure Client Secret
    • Azure Tenant ID
    • Connection Pooling
    • Connection Reset
    • Connection Retry Count
    • Connection Retry Delay
    • Crypto Protocol Version
    • CryptoLibName
    • Database Name
    • Data Source Name
    • Description
    • Enable FIPS
    • Enable SQLDescribeParam
    • Encryption Method
    • Extended Column MetaData
    • Failover Granularity
    • Failover Mode
    • Failover Preconnect
    • Fetch TSWTZ as Timestamp
    • Host Name
    • Host Name In Certificate
    • IANAAppCodePage
    • Initialization String
    • Key Password
    • Key Store
    • Key Store Password
    • Load Balance Timeout
    • Load Balancing
    • Login Timeout
    • Max Char 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
    • Show Selectable Tables
    • SSLLibName
    • TCP Keep Alive
    • Transaction Error Behavior
    • Truststore
    • Truststore Password
    • User Name
    • Validate Server Certificate
    • Web Identity Token
  • Copyright
Table of Contents

Configuring and connecting on UNIX and Linux

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


The following basic information enables you to configure a data source and test connect with a driver immediately after installation. See "Configuring and connecting to data sources" for detailed information about configuring the UNIX/Linux environment and data sources.

Note: In the following examples, xx in a driver filename represents the driver level number.
Contents
  • Environment configuration
  • Test loading the driver
  • Configuring a data source in the system information file
  • Testing the connection
Related Links
  • Configuring and connecting to data sources
TitleResults for “How to create a CRG?”Also Available inAlert