When configuring JDBC or ODBC data sources it is possible to set certain features of the underlying sources such as the operations they support.
Knowing the capabilities of the data sources is important for optimization reasons since it allows Virtual DataPort to delegate to the data source as much processing as possible to improve the performance of the queries.
To edit the list of functions that Virtual DataPort will delegate to the data source go to the “Source Configuration” tab of the data source configuration. Finally, selecting the “Custom” option for “Delegate scalar function list” it is possible to define the list of scalar functions that will be pushed down.
For instance, if the function “to_date” is removed from the list, it will not be delegated to the source. The same applies for the options “Delegate aggregate functions list” and “Delegate operators list”.
References
Data Source Configuration Properties
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Recommended resources
Questions
