Cognos Analytics

Expand all | Collapse all

How to connect to Aventri using REST API Connector?

  • 1.  How to connect to Aventri using REST API Connector?

    Posted 3 days ago
    Hi All,

    I started a similar thread trying to use the Cognos JDBC REST API connector to connect to a service called Tenable but had no luck with that after reading the Progress Autonomous REST documentation using various configuration methods. I ended up coding up using Microsoft SSIS to pull in the data instead.

    This time I'm trying to connect to another service called Aventri but am not having any luck with setting up this connection either.

    Here are the endpoints of the service:

    I've tried using these in the JDBC connecting string as;
    jdbc:ibmcognos:autorest:https://api-apac.eventscloud.com/api/ds/v1/;

    I've also set the master key, the test is successful but I only get what seems to be the 4 standard tables from the Autorest connector. 

    So far I haven't had any luck trying to connector to a few REST services we use, I am able to retrieve data from these services using SSIS and CURL but setting these up in the REST connector doesn't appear to be as straightforward as I thought, or at least as not as straightforward as what I've seen in some PM Square videos.

    Perhaps I'm doing something glaringly incorrect when trying to set these services up correctly, any help would/insight would be appreciated.

    Thanks.

    ------------------------------
    Mark Peterson
    ------------------------------


  • 2.  RE: How to connect to Aventri using REST API Connector?

    Posted 2 days ago
    Edited by Kiran Passumarthi 2 days ago
    Hi Mark, 

    Shouldn't the connection be like 

    jdbc:ibmcognos:autorest:Sample='https://api-apac.eventscloud.com/api/ds/v1/';

    and not 

    jdbc:ibmcognos:autorest:https://api-apac.eventscloud.com/api/ds/v1/;

    ?

    Also, one thing I came across earlier when configuring a REST connection was that when I simply click on Load Metadata it was only returning _Configuration table but when I clear the metadata and go to Load Options and then the Tables tab, I see additional tables to select and Load. It is not happening all the time but I did face this problem. So, try to load the schema by going to Load Options > Tables and then selecting the tables.  

    Regards,

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------



  • 3.  RE: How to connect to Aventri using REST API Connector?

    Posted 2 days ago
    Edited by Mark Peterson 2 days ago
    Thanks Kiran,

    I used the connection setting you suggested with the Sample= clause, and now I get a different response;
    Does this mean that perhaps the key isn't correct?


    ------------------------------
    Mark Peterson
    ------------------------------



  • 4.  RE: How to connect to Aventri using REST API Connector?

    Posted 2 days ago
    Hi Mark, 

    Based on what I know, a 403 Forbidden error can occur when either the endpoint cannot authorize your credentials or the endpoint itself authorizes but there are additional restrictions within the service that is preventing to access the data it is trying to return, with the credentials (in this case the key) you are using. 

    And, I saw your other response about only the _Configuration table being loaded, pls see my comments in the earlier post above about this. 

    Regards

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------