Cognos Analytics

 View Only
Expand all | Collapse all

REST API error when connecting to OData source

  • 1.  REST API error when connecting to OData source

    Posted Mon November 30, 2020 07:32 PM
    We are testing the REST API against an OData source.  I've connected to this source on my desktop web browser and it returned .json content.  When I set up the connecting in Cognos I receive the following when I test it.  This is the URL (without UN/PW) that we were testing in the data source connection: jdbc:ibmcognos:autorest:ValidateServerCertificate=false;Sample='https://<domain.com>/8.6/CCPUD.Prod.Test/odata/v4'
    Error message returned from the test:

    XQE-DS-0006 Unable to logon to the data source.

    [IBM Cognos][AutoREST JDBC Driver][AutoREST]com.ibm.cognos.util6_00_000230.ak: SSL handshake failed: java.security.cert.CertificateException: Certificates does not conform to algorithm constraints

    com.ibm.cognos.util6_00_000230.ak: SSL handshake failed: java.security.cert.CertificateException: Certificates does not conform to algorithm constraints

    com.ibm.cognos.util6_00_000230.ak: SSL handshake failed: java.security.cert.CertificateException: Certificates does not conform to algorithm constraints

    SSL handshake failed: java.security.cert.CertificateException: Certificates does not conform to algorithm constraints

    I searched online regarding the certificate message but most everything talks about JAVA JDK and old security standard MD2.  Based on the error I'm receiving does anyone know what might be needed to get this to work?

    This type of data connection is new to me so any help would be greatly appreciated.

    ------------------------------
    Scott
    Cognos Administrator
    Wenatchee WA
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: REST API error when connecting to OData source

    Posted Wed December 02, 2020 12:30 PM
    Just wanted to let all know that we solved this problem.  First there were additional changes needed in our firewall for the Cognos server.  Then when we tested again we received a 401 error.  Searched IBM and found that we need to add 'AuthenticationMethod=basic' to the Connection properties.  Doing this solved the 401 error and successfully connected to our Odata source.
    Hope this helps someone else working with the REST API.

    ------------------------------
    Scott
    Cognos Administrator
    Wenatchee WA
    ------------------------------