Table of Contents

• Preface
  • Scope
  • Who Should Use This Document
  • Summary of Contents
• Introduction
  • Examples
• Access Through JDBC
  • Parameters of the JDBC Connection URL
  • Connecting to Virtual DataPort Through a Load Balancer
  • When to Use the “Basic” Version of the JDBC Driver
  • Connecting to Virtual DataPort with SSL
  • Connecting to Virtual DataPort Using Kerberos Authentication
    • When the Client Application Does Not Belong to the Domain
  • Details of the JDBC Interface
    • Description of Views and Their Fields
    • Retrieving the Content Type of Blob Values
    • Obtaining the Names of Elements Inside a Struct (Register)
• Access Through ODBC
  • Configuration of the ODBC Driver on Windows
    • Install the ODBC Driver on Windows
    • Set Up a DSN on Windows
  • Configuration of the ODBC Driver in Linux and Other UNIX
    • Install the ODBC Driver on Linux
      • 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
    • Set Up a DSN on Linux and Other UNIX
      • Install UnixODBC
      • Register the Denodo ODBC Driver in UnixODBC
      • Configure the DSN in UnixODBC
  • Creating a DSN-Less Connection
  • Integration with Third-Party Applications
    • Increasing the Performance of the Denodo ODBC Driver
    • Supporting Queries with Brackets
    • Maximum Length of Text Values
    • Maximum Length of Error Messages
    • Disabling Transactions
• 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
  • Developing Stored Procedures
    • Required Libraries to Develop 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
  • Developing Custom Input Filters
    • Required Libraries to Develop Custom Filters
    • Developing Custom Filters
• Custom Policies
  • Developing a Custom Policy
• Appendix
  • Output Schema of the LIST Command
  • Output Schema of the DESC Commands
  • Error Codes Returned by Virtual DataPort