Cognos Analytics

 View Only
  • 1.  Ability to read source data through API

    Posted Wed December 04, 2019 08:40 AM
    Hello Team,

    Whether Cognos has the ability to read source data through an external API? Basically the source data comes through an API call, and Cognos should able to read the data and do reporting on top of it. Please let me know if this is feasible and can share any document /links which helps in this regard. Any help will be appreciated. Thanks in advance

    ------------------------------
    Sesidhar A
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Ability to read source data through API

    Posted Thu December 05, 2019 09:42 AM
    Cognos Analytics does not have that capability today.  While this has been a long standing request to CA Product Management, it remains as an enhancement request currently marked as 'future consideration'; https://ibm-data-and-ai.ideas.aha.io/ideas/CAOP-I-739 and https://ibm-data-and-ai.ideas.aha.io/ideas/CAOP-I-1131  Take a look at those RFE items and vote, if you like.   There are also third-party products such as Progress REST ODBC driver and Denodo (which I recommend and is supported by CA), both at a cost, of course.  Denodo has a free trial version called Denodo Express.    -Greg

    ------------------------------
    Gregory Mullinax
    ------------------------------



  • 3.  RE: Ability to read source data through API

    Posted Fri December 06, 2019 05:13 AM
      |   view attached
    Hi Gregory,

    Thanks for the reply. My initial understanding was the same but however got doubt by seeing the architecture diagram provided by IBM. In the diagram, it is depicted as API call is querying the database and communicating to the Cognos server. Please see the link below. Diagram is also attached for your reference.

    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_dg_sdk.doc/i_d15e231405.html

    Also, I am wondering if there is any way at least in Cognos TM1/Transformer to read the source data through an external API.


    ------------------------------
    Sesidhar A
    ------------------------------



  • 4.  RE: Ability to read source data through API

    Posted Sat December 07, 2019 10:10 AM

    Dynamic Query supports several sources via a non-JDBC API.  The diagram is remaining abstract rather than listing specific vendors  or vendor API's.

    For example, Microsoft Analysis Services, ORACLE Essbase and SAP BW use vendor specific API's.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



  • 5.  RE: Ability to read source data through API

    Posted Fri December 06, 2019 05:52 AM
      |   view attached

    Hi,

    Thanks for the reply. My initial understanding was the same but however got doubt by seeing the architecture diagram provided by IBM. In the diagram, it is depicted as API call is querying the database and communicating to the Cognos server. Please see the link below. Diagram is also attached for your reference.


    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_dg_sdk.doc/i_d15e231405.html
    (See attached file: Cognos Architecture.jpg)

    Also, I am wondering if there is any way at least in Cognos TM1/Transformer to read the source data through an external API.


    Regards,
    Sesi.






  • 6.  RE: Ability to read source data through API

    Posted Thu December 05, 2019 08:19 PM

    Directly as data connection no.

    Dynamic Query supports a user-defined table-function concept which would require you to implement it in Java. See Cognos SDK docs/call support for more details.

    Indirectly you could consider in-database "external" table-functions which can invoke external routines

    If your API is really more like a "data source", then consider solutions such as Presto, PostgreSQL etc re foreign data wrappers.

    https://prestosql.io/docs/current/connector.html

    https://prestosql.io/docs/current/develop.html



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



  • 7.  RE: Ability to read source data through API

    Posted Fri December 06, 2019 05:18 AM
      |   view attached
    Hi Nigel,

    Thanks for the reply. My initial understanding was the same but however got doubt by seeing the architecture diagram provided by IBM. In the diagram, it is depicted as API call is querying the database and communicating to the Cognos server. Please see the link below. Diagram is also attached for your reference.

    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_dg_sdk.doc/i_d15e231405.html

    Also, I am wondering if there is any way at least in Cognos TM1/Transformer to read the source data through an external API.

    Regards,
    Sesi.


    ------------------------------
    Sesidhar A
    ------------------------------