Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Ability to read source data through API

    Posted 12/04/19 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 12/05/19 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 12/06/19 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
    ------------------------------

    Original Message


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

    Posted 12/07/19 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
    ------------------------------

    Original Message


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

    Posted 12/06/19 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.



    ------Original Message------

    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
    ------------------------------

    #CognosAnalyticswithWatson


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

    Posted 12/05/19 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 12/06/19 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
    ------------------------------

    Original Message


Related Content