Overview of dynamic query extensibility

Dynamic query extensibility provides a mechanism for extending the functionality of the dynamic query engine in IBM® Cognos® Analytics with Watson by adding functions that can be evaluated locally by the dynamic query engine.

Dynamic query extensibility is useful under the following conditions:

• Cognos built-in functions are not available to meet your business objectives.
• You do not want to, or cannot, put the functionality inside the database.

These functions can be written in SQL, in the Java™ programming language, or in JSR-223 scripting languages that can be run by the Java virtual machine. In this guide we provide examples of functions that use SQL and the Java programming language.

The dynamic query extensibility framework in Cognos Analytics is based upon the ISO/IEC 9075-13 SQL Routines and Types using Java Programming Language (SQL/JRT) extension to the SQL standard. This extension allows SQL applications to invoke static Java methods as routines.