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 Oracle 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 Oracle 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)
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Data types
      • XMLType
        • Examples
      • Retrieving data type information
    • SQL support
    • Additional information
    • Contacting Technical Support
  • Tutorials
    • The Example application
    • Tableau (Windows only)
    • Microsoft Excel (Windows only)
    • Power BI (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
        • Data source configuration on UNIX/Linux
          • Configuring a data source in the system information file
            • Sample default odbc.ini file
        • The example application
        • 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
        • Performance tab
        • Failover tab
        • Pooling tab
        • Bulk tab
        • Client Monitoring tab
        • Advanced Security tab
        • Proxy tab
      • Using a connection string
      • Password Encryption Tool (UNIX/Linux only)
      • Using a logon dialog box
    • Performance considerations
    • Using LDAP
    • Connecting through a proxy server
      • Oracle Connection Manager
    • Support for Oracle RAC
    • XA interface support
    • MTS support
    • OS authentication
    • Isolation and lock levels supported
    • Unicode support
    • Using parameter arrays
    • Support of materialized views
    • Stored procedure results
    • Unexpected characters
    • 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
      • Configuring failover using the TNSNAMES.ORA file
    • Using client information
      • How databases store client information
      • Storing client information
    • Using security
      • Authentication
        • Kerberos requirements
        • Kerberos authentication
        • OS authentication
        • Oracle Internet Directory (OID)
        • Oracle Wallet SSL Authentication
        • Oracle Wallet Password Store
        • Entra ID access token authentication
      • Data encryption across the network
      • Data encryption and integrity
        • 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
        • Using Oracle Wallet as a keystore
        • Oracle Advanced Security
      • Summary of security-related options
    • Using DataDirect Connection Pooling
      • Creating a connection pool
      • Adding connections to a pool
      • Removing connections from a pool
      • Handling dead connections in a pool
      • Connection pool statistics
      • Summary of pooling-related options
    • Using 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 for Oracle
        • Verification of the bulk load configuration file
      • Sample applications
      • Character set conversions
      • External overflow files
      • Limitations
      • Summary of related options for DataDirect Bulk Load
    • Using bulk load for batch inserts
      • Determining the bulk load protocol
      • Limitations
      • Summary of related options for bulk load for batch inserts
    • Persisting a result set as an XML data file
      • Using the Windows XML persistence demo tool
      • Using the UNIX/Linux XML persistence demo tool
    • Packet logging
  • Connection option descriptions
    • Accounting Info
    • Action
    • Alternate Servers
    • Application Name
    • Application Using Threads
    • Array Size
    • Authentication Method
    • Batch Size
    • Batch Failure Returns Error
    • Bind Params As Unicode
    • Bulk Binary Threshold
    • Bulk Character Threshold
    • Bulk Options
    • Cached Cursor Limit
    • Cached Description Limit
    • Catalog Functions Include Synonyms
    • Catalog Options
    • Client Host Name
    • Client ID
    • Client User
    • Connection Pooling
    • Connection Reset
    • Connection Retry Count
    • Connection Retry Delay
    • Credentials Wallet Entry
    • Credentials Wallet Path
    • Crypto Protocol Version
    • CryptoLibName
    • Data Integrity Level
    • Data Integrity Types
    • Data Source Name
    • Default Buffer Size for Long/LOB Columns (in Kb)
    • Describe at Prepare
    • Description
    • Edition Name
    • Enable Bulk Load
    • Enable FIPS
    • Enable N-CHAR Support
    • Enable Scrollable Cursors
    • Enable Server Result Cache
    • Enable SQLDescribeParam
    • Enable Static Cursors for Long Data
    • Enable Timestamp with Timezone
    • Encryption Level
    • Encryption Method
    • Entra Access Token
    • Encryption Types
    • Failover Granularity
    • Failover Mode
    • Failover Preconnect
    • Fetch TSWTZ as Timestamp
    • Field Delimiter
    • GSS Client Library
    • Host
    • Host Name In Certificate
    • IANAAppCodePage
    • Impersonate User
    • Initialization String
    • Key Password
    • Key Store
    • Key Store Password
    • LDAP Crypto Protocol Version
    • LDAP Distinguished Name
    • LDAP Encryption Method
    • LDAP Key Store
    • LDAP Trust Store
    • LDAP Validate Server Certificate
    • Load Balancing
    • LoadBalance Timeout
    • LOB Prefetch Size
    • Local Timezone Offset
    • Lock Timeout
    • Login Timeout
    • Max Pool Size
    • Min Pool Size
    • Module
    • OpenSSLConfigFile
    • OpenSSLProviderPath
    • Password
    • Port Number
    • Proxy Host
    • Proxy Mode
    • Proxy Password
    • Proxy Port
    • Proxy User
    • PRNGSeedFile
    • PRNGSeedSource
    • Procedure Returns Results
    • Program ID
    • Query Timeout
    • Record Delimiter
    • Report Codepage Conversion Errors
    • Report Recycle Bin
    • SDU Size
    • Server Name
    • Server Process Type
    • Service Name
    • SID
    • SSLLibName
    • Support Binary XML
    • TCP Keep Alive
    • Timestamp Escape Mapping
    • TNSNames File
    • Trust Store
    • Trust Store Password
    • Use Current Schema for SQLProcedures
    • User Name
    • Validate Server Certificate
    • Wallet Password
    • Wire Protocol Mode
  • 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
    • Oracle Database Wire Protocol 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