The Senturus Analytics Connector gives Tableau or PowerBI users a straightforward way to tap directly into the governed, secure, and prepared data in Northwestern’s Cognos Analytics environment.
Some of the advantages include having the ability to
- Connects securely to Cognos Analytics
- Retrieves Cognos package (Models) and report metadata.
- Let’s users drag and drop query subjects (columns) into Tableau or PowerBI
- Requires no joining or remodeling (when using a Cognos Package/Model as the single source)
- Pushes queries back to Cognos for optimal execution.
Note: You would need to have access to the underlying data in Cognos Analytics to use this solution. For access related information, please visit this link.
Pre-Requisites
The technology leverages Microsoft® SQL Server® 2012 Native Client (or versions above). Most computers have this installed. To verify, please visit this document and navigate to Page 5 (section “Checking and Installing MS SQL Server Client”).
Connecting Tableau to Cognos Analytics
The technology leverages Microsoft® SQL Server® 2012 Native Client (or versions above). Most computers have this installed. To verify, please visit this document and navigate to Page 5 (section “Checking and Installing MS SQL Server Client”).
This guide describes how the Senturus Analytics Connector is used from Tableau after it has been installed and configured to connect to Cognos Analytics.
Connecting PowerBI to Cognos Analytics
This guide describes how the Senturus Analytics Connector is used from PowerBI after it has been installed and configured to connect to Cognos Analytics.