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 Arrow Flight-SQL
  • Access using Flight SQL
    • Access using Flight SQL JDBC driver
      • Connection Parameters
    • Access using Flight SQL Python driver
      • Requirements
      • Connection parameters
      • OAuth 2.0 Authentication providing access token
      • Notes
      • Examples
  • Current Restrictions
  • Type mapping: Virtual DataPort to Apache Arrow
  • Mapping: Virtual DataPort Types to Arrow Types
• 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
  • Developing Custom Authenticators
    • Using Custom Authenticators
      • JDBC Driver properties
        • Basic Authentication
        • Token-Based Authentication
      • Custom Parameters: Additional Authentication Information
        • JDBC
        • RESTful
    • Configuring Custom Authenticators
      • Upload a Custom Authenticator to Virtual DataPort
      • Enable Custom Authentication
      • Configuring a Custom Authenticator
      • Configuring Authenticators in Groups
      • Session Attributes
        • Example: Specifying Session Attributes
      • Set Non-Modifiable Session Attributes in Virtual DataPort
        • Using the Custom Authenticator Interface
        • Using a Configuration Property
      • Custom Authenticator Process
      • Custom Parameters: Additional Authentication Information
        • Example: Using ‘customParameters’ Property
      • Determining the Authentication Method
        • Understanding the ‘authMethod’ Property
        • Example: Using ‘authMethod’ in the Code
      • Custom Authenticator Implementation
        • Choosing the Right Interface
        • Handling Authentication Outcomes
    • Diagnosing Custom Authenticators
      • Missing JAR File
      • Insufficient Privileges
      • Log File with ‘doCustomAuthLogin’ Exception or Error
      • Other Problems
    • Implementing Custom Authenticators
      • Configuring the Developing Environment
      • Simple JDBC Implementation
• Custom View Policies
  • Developing a Custom View Policy
  • Predefined View Policies
    • DYNAMIC_RESTRICTIONS_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