•  Welcome to Progress DataDirect for ODBC for Microsoft Dynamics 365 Driver: Version 8.0.0
  • What's new in this release?
  • Driver requirements
  • Installing and setting up the driver (Windows)
  • Installing and setting up the driver (Linux)
  •  Connection string examples
    • NTLM
    • OAuth 2.0 refresh token grant
    • OAuth 2.0 client credentials grant
    • OAuth 2.0 access token flow
  • Data types
  • Driver specifications
  • Additional information
  • Troubleshooting
  • Contacting Technical Support
•  Tutorials
  • The Example application
  • Power BI (Windows only)
  • Tableau (Windows only)
  • Microsoft Excel (Windows only)
•  Configuring and connecting to data sources
  •  Environment settings
    • Windows environment variables
    •  Linux Environment Variables
      • Library Search Path
      • ODBCINI
      • ODBCINST
      • DD_INSTALLDIR
      • The Test Loading Tool
    • UTF-16 Applications on Linux
  • Configuring data sources with the Configuration Manager
  • Generating connection strings with the Configuration Manager
  • Using a connection string
  •  Additional configuration methods for 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
  • Using a logon dialog box
  •  Authentication
    • NTLM authentication
    •  OAuth 2.0 authentication
      • Access token flow
      • Client credentials grant
      • Refresh token grant
      • Registering your application on the Azure portal
      • Obtaining the service URL
      • Obtaining application client information and endpoints
      • Determining the scope
      • Obtaining access and refresh tokens using the Configuration Manager
      • Creating an application user for the client credentials grant
  • Performance considerations
•  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
  • Application Using Threads
  • Authorization URI
  • Authentication Method
  • Batch Update Chunk Size
  • Client ID
  • Client Secret
  • Connection Retry Count
  • Connection Retry Delay
  • Create Map
  • Custom Prefix
  • Custom Prefix Name
  • Data Source Name
  • Description
  • Extended Options
  • Fetch Size
  • IANAAppCodePage
  • Initialization String
  • JVM Arguments
  • JVM Classpath
  • JVM Path
  • Keyword Conflict Suffix
  • Log Config File
  • Login Timeout
  • NTLM Domain
  • Password
  • Proxy Host
  • Proxy Password
  • Proxy Port
  • Proxy User
  • Query Timeout
  • Read Only
  • Refresh Schema
  • OAuth Refresh Token
  • Report Codepage Conversion Errors
  • Schema Map
  • OAuth Scope
  • Server Port Number
  • Server Proxy Host
  • Server Proxy Password
  • Server Proxy Port
  • Server Proxy User
  • Service URL
  • SQL Engine Mode
  • SQL Service
  • Statement Call Limit
  • Statement Call Limit Behavior
  • Token URI
  • Transaction Mode
  • User
  • Web Service Compress Data
•  Supported SQL statements and extensions
  • Alter Session (EXT)
  • Delete
  • Explain Plan
  •  Insert
    • Specifying an External ID Column
  • 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
  •  Subqueries
    • IN predicate
    • EXISTS predicate
    • UNIQUE predicate
    • Correlated subqueries
  •  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
• Copyright