You can translate the question and the replies:

Cognos + Denodo + Framework Manager

This article is great if you are using Cognos' limited Data Module ability. Is it possible to hook up Cognos to Denodo via Data Source and a Framework Manager model?
user
10-01-2018 19:49:31 -0500
code

5 Answers

Hi, You sure can! Denodo comes with JDBC drivers to connect to your Virtual Database from any tool that supports it. Check out the documentation sections under [Access Through JDBC](https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_jdbc/access_through_jdbc) for information on where to find these drivers and what parameters you can use when setting up your Data Source for use within Framework Manager. If you are using an older version of Cognos, you may need to [Access Through ODBC](https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_odbc/access_through_odbc) instead of JDBC. Hope this helps!
Denodo Team
11-01-2018 12:13:01 -0500
code
It's actually pretty useless as Cognos does have Denodo as database listed, thruth is that it only is a hook to the JDBC driver. It does NOT support the Denodo VQL function set. So any function you throw in the Cognos report or FM will be executed locally so the performance will have a significant hit rendering the use of Denodo with a direct connection almost useless. Denodo: Please provide Cognos with a proper function mapping as described here https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.dg_fm_sdk.doc/c_cstmfnctns_creating_custom_function_sets.html#cstmfnctns_creating_custom_function_sets
user
18-11-2020 03:20:34 -0500
Hi, I would like to clarify that Cognos Analytics on Premises and also Cognos Analytics on Cloud - Hosted includes a Dendo connector as shown here: - https://www.ibm.com/support/pages/node/735235 In that official IBM page, you can select the different Cognos Analytics versions and check the supported sources. You could also find interesting information in this community question in the IBM community site: * https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?GroupId=3061&MessageKey=8daade6a-d147-4c0e-a27f-9de1fb3f79be&CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=digestviewer) When using the Denodo connector, most of the queries will be delegated to the Denodo Virtual DataPort Server. The Denodo connector is not available in Cognos Analytics on Cloud, so for that tool you could use a generic JDBC connector for connecting to Denodo, and with that generic connector Cognos will not be able to delegate most of the queries or functions to Denodo. Hope this helps!
Denodo Team
11-12-2020 08:52:24 -0500
code
Again, this answer is partly true: - There is a native connector in Cognos 11.x.. But this is nothing more then a hookup to the Denodo JDBC. - Cognos ONLY supports with this the Cognos build in function set. They may be pushed down to Denodo.. but its so limited its very pain stacking and most of the common functions for big DB like date time functions will not be supported. - Denodo VQL functions are note supported as its not recognized as a native database functions - Native underlying database funtions are with this not possible to use. For example if you have a SQL Server or Oracle connection in Denodo you cant use these functions in Cognos to pass through and pushed down. You have to use the limited Cognos build in functions to rebuild the native sql server or oracle functions.. It would be very easy for Denodo and Cognos to provide the custom functions sets as Denodo specific vql functions to bypass these issues.
user
11-12-2020 09:02:29 -0500
Hi! I would like to clarify that in Denodo, we always want and try to facilitate the development of a connector to Denodo by third-party vendors as much as possible. In this case the connector of IBM Cognos for Denodo is being develped by the Cognos team. Regarding your suggestions about that connector, I suggest you open an enhancement request on the IBM Data and AI Ideas Portal for Clients (https://ibm-data-and-ai.ideas.aha.io/) and contact your Cognos sales representative to discuss this request. This is the best way to influence the roadmap of IBM Cognos, as usually the decission of developing or improving a connector is more influenced by customers' requests, not by request from partners (such as Denodo, in this case). Hope this helps!
Denodo Team
16-12-2020 13:55:25 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here