•  Welcome to the Progress DataDirect for ODBC for MongoDB Driver
  • What's New in this Release?
  • Conventions Used in This Guide
  • About the Product Documentation
  • 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 in the System Information File
    • Testing the connection
  • Accessing Data in Tableau
•  What Is ODBC?
  • How Does It Work?
  • Why Do Application Developers Need ODBC?
•  About the MongoDB Driver
  • Driver Requirements
  •  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 Requirements
      • 64-Bit Driver Requirements
      • AIX
      • HP-UX 11 aCC
      • Linux
      • Oracle Solaris
      • Setup of the Environment and the Drivers
      • Driver Names for UNIX/Linux
  •  Mapping Objects to Tables
    • Normalizing Native Data
    • Mapping Nested Complex Types
    • Flattening Native Data
  • ODBC Compliance
  •  Version String Information
    • getFileVersionString Function
  •  Data Types
    • Default Mapping of Columns with Inconsistent Native Data Types
    • Retrieving Data Type Information
  • Isolation and Lock Levels Supported
  • Binding Parameter Markers
•  Supported Features
  • Unicode Support
  • Using IP Addresses
  •  Parameter Metadata Support
    • Insert and Update Statements
    • Select Statements
  • SQL Support
  • Number of Connections and Statements Supported
  • MongoDB Sharding Support
•  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 on Windows
      • SQL Engine Tab
      • Advanced Tab
      • Security Tab
    • Using a Connection String
    • Using a Logon Dialog Box
  •  Creating and Customizing Schemas Using the DataDirect Schema Tool
    •  Starting the Schema Tool
      • Starting the Schema Tool on UNIX/Linux
      • Starting the Schema Tool on Windows
    •  Creating a Schema with the Table Wizard
      • Generating a Normalized View
      • Generating a Flattened View
      • Starting with Custom View
    •  Customizing Your Schema
      •  Viewing Information and Statistics
        • About Column Information and Statistics
      •  Mapping Native Objects in a Schema
        • Mapping Native Objects
        • Mapping Newly Detected Objects
      • Extracting a New Table
      • Adding Columns
      • Removing Objects from a Schema
      • Removing Columns
      • Defining Columns
      • Designating a Primary Key
      • Naming Conflicts
    • Restarting the Wizard
  • Performance Considerations
  •  Using Security
    • Data Encryption Across the Network
    •  SSL Encryption
      • Certificates
      • SSL Server Authentication
      • SSL Client Authentication
    •  Using Security with the Schema Tool
      • Configuring Security for the Schema Tool on Windows
      • Configuring Security for the Schema Tool on UNIX/Linux
    • Summary of Security-Related Options
  • Using Identifiers
  •  Configuring the SQL Engine Server
    • Configuring Server Mode
    • Starting the SQL Engine Server
    • Stopping the SQL Engine Server
    • Configuring Java Logging for the SQL Engine Server
•  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
    • Out-of-Memory Issues
•  Connection Option Descriptions
  • Application Using Threads
  •  Config Options
    • columnDiscoverySampleSize (Config Option)
    • DefaultVarcharSize (Config Option)
    • KeywordConflictSuffix (Config Option)
    • LeadingUnderscoreReplacement (Config Option)
    • MaxVarcharSize (Config Option)
    • MinVarcharSize (Config Option)
    • SchemaFilter (Config Option)
    • UppercaseIdentifiers (Config Option)
  • Create Database
  • Data Source Name
  • Database
  • Description
  • Encryption Method
  • Fetch Size
  • Host Name
  • Host Name In Certificate
  • IANAAppCodePage
  • Initialization String
  • JVM Arguments
  • JVM Classpath
  • Key Password
  • Key Store
  • Key Store Password
  • Log Config File
  • Login Timeout
  • Min Long Varchar Size
  • Password
  • Port Number
  • Read Only
  • Read Preference
  • Report Codepage Conversion Errors
  • Result Memory Size
  • Schema Definition
  • Server Port Number
  • SQL Engine Mode
  • Transaction Mode
  • Trust Store
  • Trust Store Password
  • User Name
  • Validate Server Certificate
  • Varchar Threshold
•  Supported SQL Statements
  • Delete
  • Insert
  • Refresh Map (EXT)
  • Reload Map (EXT)
  •  Select
    •  Select Clause
      • Aggregate Functions
      •  From Clause
        • Outer Join Escape Sequences
        • 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
  •  Custom Function Escapes
    • CAST_TO_NATIVE Function Escape
•  Reference
  •  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
•  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