Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Progress DataDirect Connector - Post call

    Posted Tue August 13, 2024 04:46 PM

    Hello, I am using the progress data direct connector to make api calls. I have successfully called a public API and parameterized query parameters at a report level. Really cool stuff and can add a lot of value to our analytics platform. 

    My next POC, I am trying to make a call to an internal api we have. The endpoint requires a post call and then the response is a JSON string with data for 3 columns. From progress documentation, the definitely seems possible with the driver if you have a config file setup properly. I am able to make a successful connection but keep running into this error when trying to view the metadata in a datamodule.

    Any help is appreciated, thanks!



    XQE-DS-0006 Unable to logon to the data source.[IBM Cognos][AutoREST JDBC Driver][AutoREST]I/O Error com.ibm.cognos.jdbc.autorest.util.aj: SSL handshake failed: Received fatal alert: handshake_failureCaused by: java.io.IOException: com.ibm.cognos.jdbc.autorest.util.aj: SSL handshake failed: Received fatal alert: handshake_failureCaused by: com.ibm.cognos.jdbc.autorest.util.aj: SSL handshake failed: Received fatal alert: handshake_failureI/O Error com.ibm.cognos.jdbc.autorest.util.aj: SSL handshake failed: Received fatal alert: handshake_failureCaused by: java.io.IOException: com.ibm.cognos.jdbc.autorest.util.aj: SSL handshake failed: Received fatal alert: handshake_failureCaused by: com.ibm.cognos.jdbc.autorest.util.aj: SSL handshake failed: Received fatal alert: handshake_failurecom.ibm.cognos.jdbc.autorest.util.aj: SSL handshake failed: Received fatal alert: handshake_failureSSL handshake failed: Received fatal alert: handshake_failure



    ------------------------------
    John Bronzo
    ------------------------------


  • 2.  RE: Progress DataDirect Connector - Post call

    Posted Mon August 19, 2024 06:01 PM

    Have you tried to skip Server Certificate validation?

    jdbc:ibmcognos:autorest:sample="api_url";ValidateServerCertificate=false;



    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------

    Original Message


  • 3.  RE: Progress DataDirect Connector - Post call

    Posted Tue August 20, 2024 12:39 AM

    I am using a config file instead of sample method. But I did try this and same error. I also tried putting it in the connection properties section instead of end of JDBC string but didn't work

    jdbc:ibmcognos:autorest:config=C:\test.rest;ValidateServerCertificate=false



    ------------------------------
    John Bronzo
    ------------------------------

    Original Message


  • 4.  RE: Progress DataDirect Connector - Post call
    Best Answer

    Posted Tue August 20, 2024 09:15 AM

    I can only guess based on the exception trace that this issue is caused by SSL communication errors between the Cognos Server and the API host.

    Questions:

    1. Is this API host secured with a Valid SSL Certificate signed by a Public CA?
    2. Can you try to implement on that API host a simplified REST API GET call with the sample method (instead of config)? 

    Cheers!



    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------

    Original Message


  • 5.  RE: Progress DataDirect Connector - Post call

    Posted Mon September 09, 2024 12:47 PM

    I ended up resolving this by adding CryptoProtocolVersion=TLSv1.1,TLSv1.2 parameter to the end of the jdbc url:

    jdbc:ibmcognos:autorest:config=C:\xxx.rest;CryptoProtocolVersion=TLSv1.1,TLSv1.2;



    ------------------------------
    John Bronzo
    ------------------------------

    Original Message