Table of Contents

• Preface
  • Scope
  • Who Should Use This Document
  • Summary of Contents
• Introduction
  • Examples
• Access Through JDBC
  • JDBC Driver Parameters
  • Connecting to Virtual DataPort Through a Load Balancer
  • Connecting to Virtual DataPort Using Kerberos Authentication
    • When the Client Application Does Not Belong to the Domain
  • Connecting to Virtual DataPort Using OAuth Authentication
  • Details of the JDBC Interface
    • Description of Views and Their Fields
    • Retrieving the Content Type of Blob Values
    • Working with Datetime Values with the Denodo JDBC Driver
      • Setting Datetime Values on Parameters of Prepared Statements
      • How the Driver Reports the Datetime and Interval Types
    • Obtaining the Names of Elements Inside a Struct (Register)
    • Connecting from Applications that Filter Incoming Serialization Data
    • Queries with Datetime Literals
    • Get Auto-Generated Keys in IDU Statements
  • Enabling JDBC Logging
• Access Through ODBC
  • Configuration of the ODBC Driver on Windows
    • Install the ODBC Driver on Windows
    • Set Up a DSN on Windows
    • Install Multiple Versions of the ODBC Driver on Windows
  • Configuration of the ODBC Driver in Linux and Other UNIX
    • Obtain the Appropriate ODBC Driver
    • Install UnixODBC
    • Register the Denodo ODBC Driver in UnixODBC
    • Register a Data Source (DSN) on UnixODBC
    • Compiling UnixODBC
    • Troubleshooting Issues
  • Creating a DSN-Less Connection
    • Use Kerberos Authentication
    • Use OAuth Authentication
  • Details of the ODBC Interface
    • How the ODBC Interface Reports the Datetime and Interval Data Types
  • Integration with Third-Party Applications
    • Supporting Queries with Brackets
    • Maximum Length of Text Values
    • Maximum Length of Error Messages
    • Disabling Transactions
    • Limit the Number of Incoming ODBC Connections
  • Backward Compatibility of the ODBC Driver
• Access Through an ADO.NET Data Provider
  • Using Kerberos Authentication
• Access Through OLE DB
• Developing Extensions
  • Developing Custom Functions
    • Creating Custom Functions with Annotations
      • Developing Custom Functions that Can Be Delegated to a Database
    • Creating Custom Functions Using Name Conventions
    • Compound Types
    • Custom Function Return Type
      • Function Without Annotations with Return Type Depending on the Input
      • Aggregation Function Using Annotations
    • Getting Information About the Context of the Query
    • Dealing with Datetime and Interval Types
  • Developing Java Stored Procedures
    • Using Datetime Values in Denodo Stored Procedures
      • Compatibility with Stored Procedures of Previous Versions
    • Required Libraries to Develop Stored Procedures
  • Developing VQL Stored Procedures
  • Developing Custom Wrappers
    • Required Libraries to Develop Custom Wrappers
    • Extending AbstractCustomWrapper
    • Overriding AbstractCustomWrapper
    • Dealing with Conditions
    • Dealing with the ORDER BY Clause
    • Configuring a Custom Wrapper
    • Updating the Custom Wrapper Plan
    • Dealing with Datetime and Interval Types
  • Developing Custom Input Filters
    • Required Libraries to Develop Custom Filters
    • Developing Custom Filters
• Custom View Policies
  • Developing a Custom View Policy
• Appendix
  • Output Schema of the LIST Command
  • Output Schema of the DESC Commands
  • Error Codes Returned by Virtual DataPort
  • Compile the Denodo ODBC Driver
    • Pre-requisites to Compile the ODBC Driver on Linux
    • Compile the ODBC Driver (Standard Method)
    • Compile the ODBC Driver to Obtain Forwardable Tickets
    • Troubleshooting the Compilation of the Denodo ODBC Driver