Connecting Tableau to Cognos & Microstrategy

June 22, 2017

Cognos 10, Cognos Analytics (v11), Data Integration, End User Self Service, Report Authoring, System Admin & Security, Tableau

Easily Access the Governed Data in Your Enterprise Analytics Platform

Some organizations running enterprise analytics have hesitated to widely deploy Tableau – with understandable reason. Because Tableau can’t connect to the Cognos and MicroStrategy environments, Tableau users bypass the secure, governed and business friendly data that lives there. Instead, they work directly with raw source data, going through a labor-intensive process of re-remodeling data. Aside from wasting valuable time, this method compromises data integrity, security and reporting accuracy.

View a show-and-tell of the Senturus Analytics Connector, our simple, elegant solution that ties Tableau to Cognos and MicroStrategy as data sources. By increasing data accuracy and eliminating time consuming redundancies in report creation, the Analytics Connector provides significant benefits to both IT and Tableau users.

This demo shows how the Senturus Analytics Connector easily enables:

  • Faster report building in Tableau
  • Reduced change management
  • Improved security with appropriate guardrails around data access
  • Increased data accuracy
  • Better overall Tableau performance

Cognos, Tableau, Senturus Analytics Connector, MicroStrategy


BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, IT / BI Executives (CTO), Business Executives (CEO), Tableau users


Michael Weinhauer
Practice Area Director and Solutions Architect
Senturus, Inc.

Michael Weinhauer heads up the Tableau Practice at Senturus. Michael comes to us from Oracle, IBM and SAP, where he spent over 20 years in different roles acquiring a wealth of hands-on, practical BI and Big Data experience. Michael’s team is also responsible for the development of the Senturus Business Analytics Connector for Tableau to Cognos, which lets Tableau use Cognos as a data source.


Overview of the Senturus Analytics Connector

  • Huge value in existing BI models
  • Tableau users circumvent them
  • Why you shouldn’t (re)-create metadata
  • The solution? The Senturus Analytics Connector!
  • Instant access to quality data sets
  • Don’t sacrifice integrity for agility
  • The Senturus Analytics Connector gives you
    • Faster, more accurate reporting
    • Change management reductions
    • Trust in the data
    • Improved security
    • Superior Tableau performance
  • New Senturus Analytics Connector features
    • Local cache for Cognos package metadata – improves performance
    • Support for Cognos 10.2.0 and 11.0.6
    • Support for multiple dispatchers and fail over by specifying multiple dispatcher URLs in dataSoruces.xml.
    • 32 bit ODBC driver on Windows 64 bit OS
    • Automatically install documentation with Connector
    • DSN modification via Windows ODBC Administrator
    • Improved troubleshooting via new batch script (diagnosis.bat)
    • Configuration GUI
    • Simplify installation process – no need to copy Cognos SDK jar and Tableau .dll post-installation
    • Support silent installation
    • Support IIS/Windows authentication
    • Increased the length limit of character data types, from 254 to 8000 for char, from 4000 to 32765 fro varchar, 127 to 4000 for nchar and from 2000 to 16383 for nvarchar
    • Support sort on min/max value of PowerCube and Dynamic Cube levels
    • Support Top N in filter
    • SiteMinder SSO
  • Demonstration
  • Summary
  • Frequently asked questions
  • ROI for the Senturus Analytics Connector
  • Take a Connector test drive