Cognos Analytics

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

#CognosAnalyticswithWatson

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

Original Message:
Sent: Wed June 09, 2021 08:53 PM
From: Mark Peterson
Subject: How to connect to Aventri using REST API Connector?

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

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

Original Message:
Sent: Thu June 10, 2021 03:04 AM
From: Kiran Passumarthi
Subject: How to connect to Aventri using REST API Connector?

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

Original Message:
Sent: Wed June 09, 2021 08:53 PM
From: Mark Peterson
Subject: How to connect to Aventri using REST API Connector?

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

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

Original Message:
Sent: Thu June 10, 2021 10:02 AM
From: Mark Peterson
Subject: How to connect to Aventri using REST API Connector?

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

Original Message:
Sent: Thu June 10, 2021 03:04 AM
From: Kiran Passumarthi
Subject: How to connect to Aventri using REST API Connector?

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

Original Message:
Sent: Wed June 09, 2021 08:53 PM
From: Mark Peterson
Subject: How to connect to Aventri using REST API Connector?

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