•  Welcome to Progress DataDirect for ODBC for TeamCity 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
    • Basic authentication method
    • Bearer token authentication method
    • 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
  • Using a logon dialog box
  •  Authentication
    • Basic authentication
    • Bearer token authentication
  • 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
  • Application Using Threads
  • Authentication Method
  • Data Source Name
  • Debug Folder
  • Default Query Options
  • Description
  • Extended Options
  • Fetch Size
  • IANAAppCodePage
  • JVM Arguments
  • JVM Class Path
  • JVM Path
  • Log Config File
  • Login Timeout
  • Password
  • Proxy Host
  • Proxy Password
  • Proxy Port
  • Proxy User
  • Query Timeout
  • Report Codepage Conversion Errors
  • Security Token
  • Server Name
  • Server Port Number
  • Server Proxy Host
  • Server Proxy Password
  • Server Proxy Port
  • Server Proxy User
  • SQL Engine Mode
  • SQL Service
  • Statement Call Limit
  • Statement Call Limit Behavior
  • User
  • Web Service Retry Count
  • Web Service Timeout
•  Supported SQL statements and extensions
  • Alter Session (EXT)
  • Explain Plan
  •  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
  •  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 TeamCity data model
  • AGENTDETAILS
  • AGENTS
  • BUILDARTIFACTDEPENDENCIES
  • BUILDARTIFACTS
  • BUILDCONFIGURATIONS
  • BUILDDETAILS
  • BUILDFAILUREDETAILS
  • BUILDFAILURES
  • BUILDLASTCHANGES
  • BUILDQUEUE
  • BUILDQUEUEDETAILS
  • BUILDQUEUELASTCHANGES
  • BUILDQUEUEPROPERTY
  • BUILDQUEUEREVISIONS
  • BUILDQUEUES
  • BUILDQUEUESNAPSHOTDEPENDENCIES
  • BUILDREVISIONS
  • BUILDS
  • BUILDSNAPSHOTDEPENDENCIES
  • BUILDSTATISTICS
  • BUILDTEMPLATES
  • BUILDTYPES
  • FLAKYTESTS
  • LASTCHANGES
  • MUTES
  • PROJECTDETAILS
  • PROJECTFEATURES
  • PROJECTS
  • PROPERTY
  • REVISIONS
  • SCOPEBUILDTYPES
  • SNAPSHOTDEPENDENCIESBUILD
  • SUBPROJECTS
  • TARGETTESTS
  • TESTFAILUREDETAILS
  • TESTFAILURES
  • USERDETAILS
  • USERGROUPS
  • USERPROPERTIES
  • USERS
• Copyright