July 20, 2017

Cognos Analytics (v11), System Admin & Security

Updated Tips for the Latest Release

As Cognos Analytics continues to receive quarterly releases, the back-end installation also has had numerous changes. We review the latest steps for installing and upgrading your Cognos environment.

Our Cognos installation and upgrade expert, Todd Schuman, describes the installation and configuration steps on the server side of Cognos Analytics.

Among the highlights:

  • Latest installation options
  • Setting up a multi-server environment
  • Dealing with advanced IIS configuration
  • Keeping your database drivers current
  • Installing releases and preserving custom settings
  • Odds and Ends

IBM Cognos Analytics


BI Power Users (Developers, Support Staff), BI Managers, IT Managers, Program or Project Managers


Todd Schuman
Practice Lead – Installations, Upgrades and Performance Tuning

Todd has over 15 years of Cognos experience and heads up the Senturus Install, Upgrade and Optimization Practice. Todd presented alongside IBM product managers at the 2016 World of Watson conference Considerations When Upgrading to IBM Cognos Analytics.

  • Installation options
    • Cognos Analytics – server software
    • Cognos tools – lifecycle manager
    • Easy vs custom
    • First install vs connect and install
    • Selecting components
      • Content repository
      • Application services
      • Optional gateway
      • Samples
  • Multi server environments
    • Need at least one running content repository
    • Namespace
    • Need an account with system admin rights
    • Need content manager URI
  • IIS configuration
    • Stay on top of documentation – frequent changes
    • ARR 3.0
    • Application request routing
    • URL rewrite
    • App pools
    • MIME types
    • Rewrite rules
    • Server farms
    • SSO
    • Cheat code
      • Automate everything with a command line, batch file!
      • Plug in:
        • IIS website name (Default)
        • App pool name (ICAPool)
        • Alias (ibmcognos)
        • Install path
        • Dispatcher list (0-X)
        • Enable SSO
        • Web farm name
  • Database drivers
    • JDBC drivers: [install Dir]\drivers and dashboard/data modules require JDBC
    • Install DB software on servers that require database Access
    • App tier/dispatchers
    • Content repository
    • SQL native client
    • Oracle client
  • Preserving settings while updating to new releases
    • Preserve custom folders
      • New releases overwrite all folders
      • Always backup before
      • [Install Dir]\analytics\configuration\preserve – preserve.txt
      • # specify files or folders to preserve – [folder name] and [folder name]\image.jpg
      • Preserve – images/logos, JS files, WAR files, certs
  • Installing releases
    • On top installation
    • Backup/archive content store before
    • Check supported software and prerequisites
    • Download and install new samples