Welcome to the Progress DataDirect for ODBC for Salesforce™ Driver
What's New in this Release?
Driver Requirements
ODBC Compliance
Version String Information
getFileVersionString Function
Support for Multiple Environments
Support for Windows Environments
32-Bit Driver
64-Bit Driver
Setup of the Driver
Driver File Names for Windows
Support for UNIX and Linux Environments
32-Bit Driver
64-Bit Driver
AIX
HP-UX 11 aCC
Linux
Oracle Solaris
Setup of the Environment and the Drivers
Driver Names for UNIX/Linux
Mapping Objects to Tables
Data Types
Contacting Technical Support
Getting Started
Configuring and Connecting on Windows
Setting the Library Path Environment Variable (Windows)
Configuring a Data Source
Testing the Connection
Configuring and Connecting on UNIX and Linux
Environment Configuration
Test Loading the Driver
Setting the Library Path Environment Variable (UNIX and Linux)
Configuring a Data Source
Testing the Connection
Accessing Data With Third-Party Applications
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
The Example Application
DSN-less Connections
Sample odbcinst.ini File
File Data Sources
UTF-16 Applications on UNIX and Linux
Configuring the Product Using the GUI
SQL Engine Tab
Advanced Tab
Security Tab
Web Service Tab
Pooling Tab
Bulk Tab
Using a Connection String
Using a Logon Dialog Box
Connecting Through a Proxy Server
Performance Considerations
Using the SQL Engine Server
Configuring the SQL Engine Server on Windows
Configuring Server Mode
Starting the SQL Engine Server
Stopping the SQL Engine Server
Configuring the SQL Engine Server on UNIX/Linux
Configuring and Starting the SQL Engine Server on UNIX/Linux
Stopping the SQL Engine Server
Configuring Java Logging for the SQL Engine Server
Using Client-Side Caches
Creating a Cache
Modifying a Cache Definition
Disabling and Enabling a Cache
Refreshing Cache Data
Dropping a Cache
Cache MetaData
Catalog Tables
SYSTEM_CACHES Catalog Table
SYSTEM_CACHE_REFERENCES Catalog Table
SYSTEM_REMOTE_SESSIONS Catalog Table
SYSTEM_SESSIONINFO Catalog Table
SYSTEM_SESSIONS Catalog Table
Using Reports
Using Security
Authentication
Configuring OAuth 2.0 authentication
Data Encryption Across the Network
SSL Encryption
Certificates
SSL Server Authentication
SSL Client Authentication
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
Configuring Pooling-Related Options
Using Identifiers
Using IP Addresses
Timeouts
Views and Remote/Local Tables
SQL Support
Isolation and Lock Levels Supported
Number of Connections and Statements Supported
Unicode Support
Parameter Metadata Support
Insert and Update Statements
Select Statements
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
Verification of the Bulk Load Configuration File
Sample Applications
Character Set Conversions
External Overflow Files
Summary of DataDirect Bulk Load Related Options
Using Bulk API with SQL Statements
Summary of Options for Using Bulk API with SQL Statements
Troubleshooting
Diagnostic Tools
ODBC Trace
Creating a Trace Log
Enabling Tracing
Windows ODBC Administrator
System Information (odbc.ini) File
The Test Loading Tool
ODBC Test
Logging
Logging Components
Driver to SQL Communication Logger
SQL Engine Logger
Wire Protocol Adapter Logger
Configuring Logging
Using the JVM
Using the Driver
The Example Application
Other Tools
Error Messages
Troubleshooting
Setup/Connection Issues
Troubleshooting the Issue
Interoperability Issues
Troubleshooting the Issue
Performance Issues
Connection Option Descriptions
Access Token
Application Using Threads
Authentication Method
Bulk Fetch Threshold
Bulk Load Asynchronous
Bulk Load Batch Size
Bulk Load Concurrency Mode
Bulk Load Poll Interval
Bulk Load Threshold
Bulk Load Timeout
Client ID
Client Secret
Config Options
AuditColumns (Config Option)
CustomSuffix (Config Option)
KeywordConflictSuffix (Config Option)
MapSystemColumnNames (Config Option)
NumberFieldMapping (Config Option)
UppercaseIdentifiers (Config Option)
Connection Pooling
Connection Reset
Create Database
Create Map
Data Source Name
Database
Description
Enable Bulk Fetch
Enable Bulk Load
Enable Primary Key Chunking
Fetch Size
Field Delimiter
Host Name
IANAAppCodePage
Initialization String
JVM Arguments
JVM Classpath
LoadBalance Timeout
Log Config File
Login Timeout
Logon Domain
Max Pool Size
Min Pool Size
Password
Primary Key Chunk Size
Proxy Host
Proxy Password
Proxy Port
Proxy User
Read Only
Record Delimiter
Refresh Dirty Cache
Refresh Schema
Refresh Token
Report Codepage Conversion Errors
Schema Map
Security Token
Server Port Number
SQL Engine Mode
Statement Call Limit
Statement Call Limit Behavior
Transaction Mode
User Name
WSFetch Size
WSPoolSize
WSRetry Count
WSTimeout
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
Reference
What Is ODBC?
How Does It Work?
Why Do Application Developers Need ODBC?
Code Page Values
IANAAppCodePage Values
ODBC API and Scalar Functions
API Functions
Scalar Functions
String Functions
Numeric Functions
Date and Time Functions
System Functions
Internationalization, Localization, and Unicode
Internationalization and Localization
Locale
Language
Country
Variant
Unicode Character Encoding
Background
Unicode Support in Databases
Unicode Support in ODBC
Unicode and Non-Unicode ODBC Drivers
Function Calls
Unicode Application with a Non-Unicode Driver
Unicode Application with a Unicode Driver
Data
Unicode Driver
ANSI Driver
Default Unicode Mapping
Connection Attribute for Unicode
Driver Manager and Unicode Encoding on UNIX/Linux
References
Character Encoding in the odbc.ini and odbcinst.ini Files
Designing ODBC Applications for Performance Optimization
Using Catalog Functions
Caching Information to Minimize the Use of Catalog Functions
Avoiding Search Patterns
Using a Dummy Query to Determine Table Characteristics
Retrieving Data
Retrieving Long Data
Reducing the Size of Data Retrieved
Using Bound Columns
Using SQLExtendedFetch Instead of SQLFetch
Choosing the Right Data Type
Selecting ODBC Functions
Using SQLPrepare/SQLExecute and SQLExecDirect
Using Arrays of Parameters
Using the Cursor Library
Managing Connections and Updates
Managing Connections
Managing Commits in Transactions
Choosing the Right Transaction Model
Using Positioned Updates and Deletes
Using SQLSpecialColumns
Using Indexes
Introduction
Improving Row Selection Performance
Indexing Multiple Fields
Deciding Which Indexes to Create
Improving Join Performance
Locking and Isolation Levels
Locking
Isolation Levels
Locking Modes and Levels
WorkAround Options
Threading
DataDirect Bulk Load
DataDirect Bulk Load Functions
Utility Functions
GetBulkDiagRec and GetBulkDiagRecW
Export, Validate, and Load Functions
ExportTableToFile and ExportTableToFileW
LoadTableFromFile and LoadTableFromFileW
Using the TableName Parameter with the Salesforce Driver
SetBulkOperation
GetBulkOperation
DataDirect Bulk Load Statement Attributes
SQL_BULK_EXPORT_PARAMS
SQL_BULK_EXPORT
Glossary
application
authentication
bulk load
client load balancing
conformance
connection pooling
connection retry
connection string
data source
driver
Driver Manager
DSN (Data Source Name)
DTC (Distributed Transaction Coordinator)
failover
index
isolation level
Kerberos
load balancing
locking level
MTS (Microsoft Transaction Server)
NTLM
ODBC Administrator
OS authentication
Performance Tuning Wizard
reauthentication
SQL Grammar
Secure Sockets Layer (SSL)
SSL client/server authentication
Unicode
user ID/password authentication
Copyright
Welcome to the Progress DataDirect for ODBC for Salesforce™ Driver
Copyright
sfgeneral
sfproxy
sfadvanced
sfsecurity
sfwebservice
sfpool
sfbulk
sfexporttable
sfloadtable
salesforcelogon