Welcome to the Progress DataDirect Autonomous REST Connector for ODBC
What's New in this Release?
Quick Starts
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 Linux Environments
32-Bit Driver
64-Bit Driver
Linux
Setup of the Environment and the Drivers
Driver Names for Linux
Mapping Objects to Tables
Normalizing JSON Maps
Determining the primary key
Data Types
Contacting Technical Support
Using the Driver
Setting Up the Driver
Configuring the Relational Map
Using the REST Sample Path Method
Using the Input REST File Method
Creating an Input REST File
Modifying the Relational View
Designating the Primary Key
Adding/Removing Objects
Configuring and Connecting to Data Sources
Configuring the Product on Linux
Environment Variables
Library Search Path
ODBCINI
ODBCINST
DD_INSTALLDIR
The Test Loading Tool
Data Source Configuration on 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 Linux
Setting the Library Path Environment Variable (Windows)
Configuring the Product Using the GUI
SQL Engine Tab
Authentication Tab
TLS/SSL Tab
Advanced Tab
Using a Connection String
Using a Logon Dialog Box
The Example Application
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 on Windows
Stopping the SQL Engine Server
Configuring the SQL Engine Server on Linux
Configuring and Starting the SQL Engine Server on Linux
Stopping the SQL Engine Server
Configuring Java Logging for the SQL Engine Server
Authentication
Basic authentication
HTTP header authentication
URL parameter authentication
OAuth 2.0 Authentication
Access Token Flow
Authorization Code Grant
Client Credentials Grant
Password Grant
Refresh Token Grant
Custom authentication
Data Encryption
Data Encryption Across the Network
SSL Encryption
Certificates
SSL Server Authentication
SSL Client Authentication
Enabling SSL Encryption
Summary of Data Encryption Options
Identifiers
Using IP Addresses
SQL Support
Isolation and Lock Levels Supported
Number of Connections and Statements Supported
Unicode Support
Parameter Metadata Support
Troubleshooting
Diagnostic Tools
ODBC Trace
Creating a Trace Log
Enabling Tracing
Windows ODBC Administrator
System Information (odbc.ini) File
The Test Loading Tool
Enabling Debug Record Mode
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
Auth Code
Auth Header
Auth Param
Authentication Method
Client ID
Client Secret
Create Map
Crypto Protocol Version
Custom Auth Params
Data Source Name
Description
Debug Folder
Fetch Size
Host Name
Host Name In Certificate
IANAAppCodePage
JVM Arguments
JVM Classpath
Key Password
Key Store
Key Store Password
Log Config File
Login Timeout
Logoff URI
Read Ahead
Refresh Token
Password
Redirect URI
Report Codepage Conversion Errors
REST Config File
REST Sample Path
Result Memory Size
Schema Map
Scope
Security Token
Server Port Number
SQL Engine Mode
Token URI
Transaction Mode
Trust Store
Trust Store Password
User Name
Validate Server Certificate
Input REST file syntax
HTTP response code processing
OAuth 2.0 authentication
Custom authentication requests
Table definition entries
Paging
Using templates for paging parameters
REST model parsing
POST requests
Requests with custom HTTP headers
Query paths
Requests with unparameterized paths
Requests with parameterized paths
Requests with query parameters
Arrays of endpoints
Column names
Data type mapping
Primary key
Columns as an array
Columns as a key-value map
Columns with nested objects
Date, time, and timestamp formats
Subfields
Columns as HTTP headers
Filtering and URI parameters
Example input REST file
Supported SQL statements and extensions
Alter Session (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
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 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
SSL Encryption Cipher Suites
WorkAround Options
Threading
Copyright
Welcome to the Progress DataDirect Autonomous REST Connector for ODBC
Copyright
autorestgeneral
autorestproxy
autorestauthentication
autoresttlsssl
autorestadvanced
autorestlogon