Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Connecting Cognos Analytic on Premise to Azure SQL Database

    Posted Tue October 04, 2022 11:35 AM
    I am trying to create a connection to Azure SQL Database using  data server connections  (JDBC URL).  We are using Cognos 11.1.7 Fix pack 5 . I want to connect to Azure SQL Database for reporting purposes.  It is not working for me . I am getting connection errors. Did any one tried this and if yes can some one please send me step by step instructions. Thanks.

    Regards,
    Pradeep sahay

    ------------------------------
    pradeep sahay
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Connecting Cognos Analytic on Premise to Azure SQL Database

    Posted Tue October 04, 2022 01:03 PM

    Hi,

    You haven't mentioned exactly what steps you have taken in setting up the Data Server connection, and when you say "it is not working for me - I am getting connection errors", that's not really specific enough to allow anyone to help you pinpoint what the issue might be. What exact errors are you getting?

    Have you looked at this support article which details the steps? Did you do everything it includes?

    https://www.ibm.com/support/pages/how-create-data-server-connection-azure-sql-server-using-active-directory-password-authentication

    Cheers!

     MF.



    ------------------------------
    Mark Fry
    Technical Consultant
    ------------------------------

    Original Message


  • 3.  RE: Connecting Cognos Analytic on Premise to Azure SQL Database

    Posted Tue October 04, 2022 02:01 PM
    Hi Mark,
    Thanks for your reply.
    Yes this is exactly the document which I followed. (https://www.ibm.com/support/pages/how-create-data-server-connection-azure-sql-server-using-active-directory-password-authentication)

    As per the documentation i downloaded all the jar files and copied to the <install_location\drivers> folder.

    Iam using the same string URL=jdbc:sqlserver://servername:port;DATABASE=databasename;LOGINTIMEOUT=0;authentication=ActiveDirectoryPassword;DRIVER_NAME=com.microsoft.sqlserver.jdbc.SQLServerDriver

    We are able to connect to  Azure SQL Database through 3rd party tool like Dbeaver. 

    The error right now which i am getting is 
    XQE - GEN - 0002. An Unexpected exception occurred: com.microsoft.aad.adal4j.Authenticatuion Exception

    Thank you again for all your help .
    Regards,
    Pradeep Sahay

    ------------------------------
    pradeep sahay
    ------------------------------

    Original Message


  • 4.  RE: Connecting Cognos Analytic on Premise to Azure SQL Database

    Posted Fri October 07, 2022 07:17 PM

    The Azure SQL or Azure Synapse admins can copy the JDBC URL from the Azure console.

    You can paste that into the URL in your connection and provide whatever UID/PWD for the signon is required

    Will look similar to this.

    jdbc:sqlserver://.....database.windows.net:1433;database=...;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

    For persons who plan to use access tokens from an IDP such as Azure Active-D, when you move to 11.2.2 you can also use that approach

    https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=a-more-data-server-connections-that-support-jwt-authentication



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message


  • 5.  RE: Connecting Cognos Analytic on Premise to Azure SQL Database

    Posted Tue October 11, 2022 05:54 PM
    Hi Nigel,
    Thanks for your reply. yes your solution worked. Thanks again for your help.

    Regards,
    Pradeep sahay

    ------------------------------
    pradeep sahay
    ------------------------------

    Original Message