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 Salesforce User's Guide Release 8.0.0

UNIX/Linux environment variables

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 Salesforce Driver
    • What's new in this release?
    • Driver requirements
    • Mapping objects to tables
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (UNIX/Linux)
    • Connection string examples
      • User ID and password authentication
      • OAuth 2.0 authentication string
    • Data types
    • Driver specifications
    • Version string information
      • getFileVersionString function
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Tutorials
    • The Example application
    • Tableau (Windows only)
    • Microsoft Excel (Windows only)
  • Configuring and connecting to data sources
    • Environment settings
      • Windows environment variables
      • UNIX/Linux environment variables
        • Library search path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
        • The Test Loading Tool
      • UTF-16 applications on UNIX and Linux
    • Configuring data sources with the Configuration Manager
    • Generating connection strings with the Configuration Manager
    • 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
    • Testing connections and queries with the Configuration Manager
    • Password Encryption Tool (UNIX/Linux only)
    • Using a logon dialog box
    • Authentication
      • User ID and password authentication
      • Configuring OAuth 2.0 authentication
        • Registering your application with Salesforce
        • Obtaining the client ID, client secret, and scopes
        • Obtaining access and refresh tokens with Postman
        • Configuring the driver to use OAuth 2.0
        • Configuring the driver to use OAuth 2.0 with JWT grant
    • TLS/SSL encryption
      • Certificates
      • TLS/SSL server authentication
      • TLS/SSL client authentication
    • Proxy server
    • DataDirect connection pooling
    • DataDirect Bulk Load
      • Bulk export and load methods
      • Exporting data from a database
      • Bulk loading to a database
      • The bulk load configuration file
        • Bulk load configuration file schema
        • Verification of the bulk load configuration file
      • Sample applications
      • Character set conversions
      • External overflow files
    • Using Bulk API with SQL statements
      • Summary of options for using the Bulk API with SQL statements
    • Performance considerations
  • Additional features and functionality
    • Identifiers
    • Catalog tables
      • SYSTEM_CACHES catalog table
      • SYSTEM_CACHE_REFERENCES catalog table
      • SYSTEM_REMOTE_SESSIONS catalog table
      • SYSTEM_SESSIONINFO catalog table
      • SYSTEM_SESSIONS catalog table
    • Client-side caches
      • Creating a cache
      • Modifying a cache definition
      • Disabling and enabling a cache
      • Refreshing cache data
      • Dropping a cache
      • Cache metadata
    • Reports
    • Views and remote/local tables
    • 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
    • ApplyToLabel
    • Authentication Method
    • Bulk Fetch Threshold
    • Bulk Load Async
    • Bulk Load Batch Size
    • Bulk Load Concurrency Mode
    • Bulk Load Job Size
    • Bulk Load Poll Interval
    • Bulk Load Threshold
    • Bulk Load Version
    • Claims Issuer
    • Claims Subject
    • Client ID
    • Client Secret
    • Collate With UTF Values
    • Config Options (deprecated)
    • Connection Pooling
    • Connection Reset
    • Connection Retry Delay
    • Connection Retry Count
    • Create Map
    • Data Source Name
    • Description
    • Enable Bulk Fetch
    • Enable Bulk Load
    • Enable Primary Key Chunking for Bulk Select
    • Extended Options
    • Fetch Size
    • Host Name
    • Initialization String
    • IN-values Join Limit
    • Java Double To String
    • JVM Arguments
    • JVM Classpath
    • JVM Path
    • JWT Certificate Alias
    • JWT Certificate Password
    • JWT Certificate Store
    • Load Balance Timeout
    • Log Config File
    • Login Timeout
    • Login Timeout
    • Max Pool Size
    • Min Pool Size
    • Password
    • Primary Key Chunk Size
    • Proxy Host
    • Proxy Password
    • Proxy Port
    • Proxy User
    • Read Only
    • Refresh Schema
    • Refresh Token
    • Report Codepage Conversion Errors
    • Schema Map
    • Security Token
    • Server Port Number
    • Statement Call Limit
    • Statement Call Limit Behavior
    • String Collation Mode
    • SQL Engine Mode
    • SQL Service
    • Transaction Mode
    • User
    • Web Service Fetch Size
    • Web Service Pool Size
    • Web Service Retry Count
    • Web Service Timeout
  • Supported SQL statements and extensions
    • Alter Cache (EXT)
      • Relational caches
    • Alter Index
    • Alter Sequence
    • Alter Session (EXT)
    • Alter Table
      • Altering a remote table
        • Add clause: columns
        • Add clause: constraints
        • Drop clause: columns
      • Altering a local table
        • Add clause: columns
        • Add clause: constraints
        • Drop clause: columns
        • Drop clause: constraints
        • Rename clause
    • Create Cache (EXT)
      • Relational caches
      • Referencing clause
      • Refresh Interval clause
      • Initial Check clause
      • Persist clause
      • Enabled clause
      • Call Limit clause
      • Filter clause
    • Create Index
    • Create Sequence
      • Next Value For clause
    • Create Table
      • Creating a remote table
        • Column definition for remote tables
        • Constraint definition for remote tables
        • Foreign Key clause
      • Creating a local table
        • Column definition for local tables
        • Constraint definition for local tables
    • Create View
    • Delete
    • Drop Cache (EXT)
    • Drop Index
    • Drop Sequence
    • Drop Table
    • Drop View
    • Explain Plan
    • Insert
      • Specifying an external ID column
    • Refresh Cache (EXT)
    • Refresh Map (EXT)
    • Select
      • Select clause
        • Aggregate functions
        • From clause
          • Join in a From clause
          • Subquery in a From clause
        • Where clause
        • Group By clause
        • Having clause
        • Union operator
        • Intersect operator
        • Except and Minus operators
        • Order By clause
        • Limit clause
    • Update
    • SQL expressions
      • Column names
      • Literals
        • Character string literals
        • Numeric literals
        • Binary literals
        • Date/time literals
        • Integer literals
      • Operators
        • Unary operator
        • Binary operator
        • Arithmetic operators
        • Concatenation operator
        • Comparison operators
        • Logical operators
        • Operator precedence
      • Functions
      • Conditions
    • Subqueries
      • IN predicate
      • EXISTS predicate
      • UNIQUE predicate
      • Correlated subqueries
  • Copyright
Table of Contents

UNIX/Linux environment variables

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: July 30, 2025
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Salesforce 8.0
    • Documentation

The following topics guide you through setting the environment variables for UNIX/Linux platforms. You must set these environment variables before connecting with your driver.

Contents
  • Library search path
  • ODBCINI
  • ODBCINST
  • DD_INSTALLDIR
  • The Test Loading Tool
TitleResults for “How to create a CRG?”Also Available inAlert