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 Microsoft SharePoint User's Guide Release 8.0.0

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 for Microsoft SharePoint Driver
    • 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
      • OAuth 2.0 access token flow
      • OAuth 2.0 refresh token grant
      • OAuth 2.0 dynamic authorization code grant
      • Proxy server
    • 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
    • Password Encryption Tool (UNIX/Linux only)
    • Using a logon dialog box
    • OAuth 2.0 authentication
      • Register your application on the Azure portal
      • Obtain application client information and endpoints
      • Obtain access and refresh tokens using the Configuration Manager
      • Determine the scope
      • Configure the driver to use OAuth 2.0
        • Access token flow
        • Refresh token grant
        • Dynamic authorization code 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
    • Audit Columns
    • Authentication Method
    • Authorization URI
    • Batch Update Chunk Size
    • Client ID
    • Client Secret
    • Create Map
    • Data Source Name
    • DateTime Zone Shift
    • Description
    • Enable Login Prompt
    • Extended Options
    • Fetch Size
    • Initialization String
    • JVM Arguments
    • JVM Classpath
    • JVM Path
    • Keyword Conflict Suffix
    • Log Config File
    • Proxy Host
    • Proxy Password
    • Proxy Port
    • Proxy User
    • Read Only
    • Redirect URI
    • Refresh Schema
    • Refresh Token
    • Report Codepage Conversion Errors
    • Schema Map
    • Scope
    • Server Port Number
    • Server Proxy Host
    • Server Proxy Password
    • Server Proxy Port
    • Server Proxy User
    • Service URL
    • Statement Call Limit
    • Statement Call Limit Behavior
    • SQL Engine Mode
    • SQL Service
    • Token URI
    • Transaction Mode
    • 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
  • Introduction to the SharePoint List data model
    • ALLCOLUMNSLIST
    • DEFAULTCOLUMNSLIST
  • 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: July 30, 2025
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Microsoft SharePoint 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
  • Power BI (Windows only)
  • Tableau (Windows only)
  • Microsoft Excel (Windows only)
Related Links
  • Installing and setting up the driver (Windows)
  • Installing and setting up the driver (Linux)
TitleResults for “How to create a CRG?”Also Available inAlert