Analytics Connector


Organizations have made significant investments in BI platforms like Cognos and MicroStrategy, augmenting them with governed and prepared data, business rules and security measures. But because Tableau does not connect directly to these bastions of BI fortitude – and all their clean data – users bypass them altogether. Instead, they spend 80% or more of their time remodeling the data and, in the process, potentially compromise data integrity and security.

Senturus has bridged this gap with a software connector that easily ties Cognos and MicroStrategy as data sources for – and exposes them to – Tableau. With the power of Tableau working in concert with Cognos and  MicroStrategy, organizations experience significant benefits that both IT and business users can appreciate.



The Senturus Analytics Connector serves as a bridge that allows Tableau to tap directly into Cognos and MicroStrategy. Tying in through the ODBC layer, the Analytics Connector authenticates and restricts access to data by user login. The straightforward UI allows users to then simply drag and drop data from Cognos and MicroStrategy into Tableau.

With the Analytics Connector, organizations are able to leverage their existing BI platform investments, while providing users the agility they crave.

  • Connects securely to Cognos and MicroStrategy via ODBC
  • Retrieves Cognos and MicroStrategy packagemetadata
  • Lets users drag and drop query subjects into Tableau
  • Requires no joining or remodeling
  • Pushes queries back to Cognos or MicroStrategy for optimal execution


"The Senturus Analytics Connector easily and instantaneously gets us better time utilization for our analysts…it’s a MASSIVE savings.

— Steve Kiser, Sr. Mgr Financial Systems, Ixia

Read case study

“It is clear that the combination of Tableau, Cognos and the Senturus Analytics Connector will greatly improve all our departments.”
—Dean  Clausen, Business Intelligence Architect, Aero Precision Industries

Read case study


Subscription pricing also available
$85/year desktop, $45/year server.



  • IBM Cognos 10 /11
  • MicroStrategy 10
  • Microsoft Windows 7 and 10,
    Windows Server 2008 R2 and 2012, 2012 R2    
  • Tableau 9/10


  • Modern Dual-Core
    i5/i7/Xeon or better processor     
  • 8GB of memory
  • 200MB disk space





  • Relational, dimensionally modeled relational (DMR), PowerCubes, Dynamic Cubes, TM1 and reports


  • Attributes, metrics, reports and report based intelligence cubes


Cognos Server

  • Access to Cognos dispatcher
  • Access to Cognos packages, reports and data sources
  • Capability of Specification Execution, Generate CSV Output and Generate XML Output


  • Access to project
  • Have reporter role
  • Have permission to export to CSV


  • Administrator rights to the Tableau box for installation


Q: Where is the Senturus Analytics Connector installed?
A: The Analytics Connector needs to be installed wherever the Tableau query is being executed. This is typically a Tableau Desktop or Tableau Server. Nothing needs to be installed on Cognos or MicroStrategy servers.

Q: What type of skills and time are required to install the Senturus Analytics Connector?
A: Standard installation takes about two hours and requires standard Windows administration (i.e., installation, environment variable setting, some minor registry edits).

Q: Which BI platforms are supported?
A: The Senturus Analytics Connector is designed to connect Tableau to MicroStrategy 10.6 and higher as well as to  IBM Cognos BI 10.2.x and Cognos Analytics 11.0.6 and higher. We have specifically designed the Connector so that it can be configured for other enterprise BI systems such as Tableau 9.x/10.x and Microsoft Windows operating system (Windows 7, 8, 10, Windows Server 2008 R2, 2012).

Q: Which types of Cognos and MicroStrategy data sources are supported?
A: Currently supported data sources include relational, dimensionally modeled relational (DMR), PowerCubes, Dynamic Cubes and TM1 for Cognos and relational for MicroStrategy.

Q: Is support included with the Senturus Analytics Connector and, if so, who provides it?
A: Support is provided by Senturus and included in the price of the Analytics Connector.

Q: What is the difference between live and extract query support?
A; We support both live and extract query functionality; however, certain live query functionality is limited. We are continuously enhancing this functionality based on needs and feedback.

Q: When was the Senturus Analytics Connector released?
A: The Analytics Connector was released for general availability on November 7, 2016.

Q: What are the licensing implications for Cognos?
A: Cognos: For extracts, a Cognos BI analytics user license or equivalent is required to allow extraction creation. A Cognos license is not required to connect to extracts; only a Senturus Analytics Connector license is needed. For a live connect, a Cognos BI analytics user license or equivalent is required.

MicroStrategy: For extracts, project access and reporter role are needed to allow creation of extracts. A MicroStrategy license not required to connect to extracts; only a Senturus Connector license is needed. For live connect, project access and reporter role are required.

Q: What are the Framework Manager model requirements for use with the Senturus Analytics Connector?
A: There are no special modeling requirements for the Analytics Connector, except those necessary to work around current live query limitations. However, Tableau requires that joins are created between query subjects, even if they don’t have a relationship specified at that level of abstraction. The Analytics Connector will automatically create dummy joins, but will ignore them, letting Cognos handle them in the background.

Q: How is security handled by the Senturus Analytics Connector?
A: Username and password credentials are passed through to Cognos/MicroStrategy during query execution, thereby enforcing relevant security applied within both environments.

Q: How often would updates be released during the year and how much time would it take to apply them?
A: Updates will be released as functionality is added or bug fixes dictate. We do not have a formal release timeline established yet. Updates should be fairly easy and only take a few minutes.

Q: What is the method for accessing Cognos and MicroStrategy via Tableau?
A: The Senturus Analytics Connector uses an ODBC connection to connect to Cognos and MicroStrategy.



Version 2.5 was released in April 2018. This release significantly improved the capabilities associated with using TM1 as a data source, including

  • Total control of what level attributes to show for TM1 data source
    • Show name
    • Show attributes match strings exactly
    • Show attributes match regular expression
  • Control of show or hide root level (this applies to PowerCube and Dynamic Cube data sources as well)
  • Control of show or hide leave levels of TM1 alternate hierarchy


Version 2.4 was released in January 2018. The Analytics Connector now

  • Supports report based MicroStrategy Intelligence Cubes as data source
  • Supports MicroStrategy object prompts
  • Allows users to select dummy column names, _LINK_COLUMN_ to AAA_LINK


Version 2.3 was released in Fall 2017. Highlights include

  • Support for both Cognos and MicroStrategy reports as data sources
  • Ability to configure a selection of PowerCube attributes such as short name, long name and description to reduce metadata clutter in Tableau


Version 2.0 was released Summer 2017, which added support for MicroStrategy as a data source for Tableau along with enhanced functionality to improve accessibility and admin functions.

Highlights include

  • Support for MicroStrategy as an ODBC source to Tableau
  • Support for Cognos single sign on via Siteminder and IIS/Windows authentication
  • Easier configuration through the familiar Microsoft ODBC Administration interface
  • Streamlined and simplified installation
    • Automated distribution in managed organizations without requiring user input
    • Automated handling of versions 
  • User friendly error messages and better logging for technical support
  • Streamlined troubleshooting for connection and query issues with a new diagnostic utility
  • More comprehensive support for both relational and OLAP/cube sources