Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Cognos Analytics cloud Data Connection error with Amazon Athena

    Posted Tue July 26, 2022 03:49 PM
    Hi,
    I am trying to connect Amazon Athena tables in Cognos Analytics cloud 11.2. Connection test shows success, but when we browse 'schema' it throws an error. help in this regards is greatly appreciated.

    Error
    MSR_GEN_0097 Error while getting catalogs and schemas for: "awsathenahes". Unable to connect to the data source. "[Simba][AthenaJDBC](100211) Missing credentials error: Either UID/PWD or AwsCredentialsProviderClass must be provided."


    ------------------------------
    Siva Naik
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Analytics cloud Data Connection error with Amazon Athena

    Posted Tue July 26, 2022 08:55 PM
    Hi, just a guess .. but try adding your credentials as a saved signon (then "use the following sign on" rather then the "prompt for user and pass" ..).

    ------------------------------
    Nigel Jordan
    ------------------------------



  • 3.  RE: Cognos Analytics cloud Data Connection error with Amazon Athena

    Posted Mon February 19, 2024 11:41 AM

    Hi Siva,

    Could you please tell me the steps needed to connect cognos with AWS Athena? 



    ------------------------------
    beena albert
    ------------------------------