Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  IBM Cognos c11AuditExtension

    Posted Wed June 10, 2020 10:55 AM
      |   view attached
    Anybody using the Audit Extension working?  https://developer.ibm.com/tutorials/ibm-cognos-11-audit-extension/

    I'm trying to use Database type: Microsoft SQL Server (integrated security) and I keep getting error:  Error: ERROR - Unable to connect to database - check the settings are correct. 



    ------------------------------
    Tony Barlas
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: IBM Cognos c11AuditExtension

    Posted Wed June 10, 2020 11:06 AM
    Edited by System Admin Fri January 20, 2023 04:46 PM
    ​We have set up and used the audit extensions in multiple C11 instances. We use SQL Server and 11.0.9 and 11.0.13.

    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 3.  RE: IBM Cognos c11AuditExtension

    Posted Thu June 11, 2020 08:56 AM
    I apologize. Read too fast. We have only installed the audit package, not the audit extensions. ​

    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 4.  RE: IBM Cognos c11AuditExtension

    Posted Wed June 10, 2020 11:50 AM
    I have used it in my last project with Oracle DB, works fine. I actually provided the jdbc details in the properties directly instead of configuring it from the UI.
    Did you create a seperate DB or installing in the Audit DB?
    Thanks

    ------------------------------
    Sanjay Chakravarty
    ------------------------------

    Original Message


  • 5.  RE: IBM Cognos c11AuditExtension

    Posted Mon June 15, 2020 06:03 PM
    What format did you use for the jdbc details in the properties file?

    ------------------------------
    Matt Cantrell
    ------------------------------

    Original Message


  • 6.  RE: IBM Cognos c11AuditExtension

    Posted Wed June 10, 2020 05:46 PM
    I've installed this on several instances as well (SQL Server 2016 and CA v11.0.7) and haven't had any issues with DB connectivity.  A couple things that might help though:
    1. I added the Audit_EXT tables to existing Cognos Audit DBs
    2. I don't remember all the options for DB types but something tells me your issue is likely related to the MS SQL Server (integrated security) choice - if there is just a regular MS SQL Server option, give that a try.

    The audit extension has its own security, completely separate from whatever your Cognos environemnt uses...We use AD with SSO enabled for Cognos but there is nothing equivalent to that for the Audit EXT that I'm aware of.

    One final suggestion would be to open your main Cognos Configuration interface and verify how you have the connection to the main Audit DB configured.  If your primary audit DB is working as expected that configuration could give you a clue as to how this connection should be set up.  Obviously, that's assuming you're not trying to set up a brand new DB just for the Audit EXT tables.

    Anyway, hope this helps. Good luck!
    -Chris

    ------------------------------
    Chris Schultz
    ------------------------------

    Original Message


Related Content