Analytics Connector
CONNECTS POWER BI TO COGNOS
Power BI may well have become an industry powerhouse but it is hampered by its inability to take advantage of the data in existing BI platforms. Organizations have made significant investments in Cognos, augmenting it with governed and prepared data, business rules and security measures. But because Power BI users cannot access Cognos as a data source, they resort to using it for ETL and/or recreating models in Power BI data panes. This process is not only a huge (and error prone) time sink that keeps business analysts from examining the real business questions at hand, it compromises data integrity and security.
The Senturus Analytics Connector solves this problem, allowing Power BI to tap directly and securely into the clean, organized data in Cognos. The straightforward UI allows users to simply drag and drop data into Power BI data panes.
With Cognos and Power BI working in harmony, IT and business users gain tremendous benefits in terms of time savings, data security and accuracy, and report execution. Duplicative and error prone manual efforts are eliminated.
- Connects securely to Cognos via ODBC
- Retrieves Cognos package metadata
- Lets users drag and drop query subjects into Power BI
- Pushes queries back to Cognos for optimal execution
THE SENTURUS ANALYTICS CONNECTOR SAVES TIMES AND REDUCES RISK
|
Faster, more accurate reporting Power BI analysts can spend time doing actual analysis instead of manipulating data sets and/or remodeling data already curated in Cognos. |
|
Reduced change management cost and risk Changes in Cognos Framework Manager models are automatically picked up by the Analytics Connector, eliminating costly and time-consuming changes to individual Power BI files. |
|
Increased trust in the data Auditable, governed data provides a "single version of the truth" that is the basis for all Power BI reporting. With trust in the reporting data, company-wide adoption increases. |
|
Improved security Eliminates redundant security application; reduces risks associated with the use of unsecure data sources (flat files, Excel spreadsheet exports) and allows appropriate guardrails to be set up around data access. |
|
Superior Power BI performance Poorly modeled data in Power BI can dramatically decrease performance. Analytics Connector users leverage the performance-optimized data modeled in Cognos. |
Two-week proof of concept including installation, configuration and testing.
SUPPORTED ENVIRONMENTS SUPPORTED DATA SOURCES Cognos ACCESS REQUIREMENTS Cognos Server Power BI
Windows Server 2008 R2, 2012, 2012 R2, 2016
A: The Analytics Connector needs to be installed wherever connectivity to Cognos is required (Power BI Desktop). Nothing needs to be installed on Cognos servers. It is also available as client/server.
Analytics Connector?
A: Standard installation takes about two hours and requires standard Windows administration (i.e. installation, environment variable setting, some minor registry edits).
A: The Senturus Analytics Connector is designed to connect Power BI to IBM Cognos BI 10.2.x and Cognos Analytics 11. We also support cloud deployments as long as the Cognos dispatcher can be accessed.
A: Currently supported data sources include relational, dimensionally modeled relational (DMR), PowerCubes, Dynamic Cubes and TM1 for Cognos.
provides it?
A: Support is provided by Senturus and included in the price of the Analytics Connector.
A: We support both live and import functionality.
A: The Analytics Connector was released on November 7, 2016. Power BI support was included beginning with version 3.
A: For imports, a Cognos Analytics User license or equivalent is required to allow imports. A Cognos license is not required to connect to imported data; only a Senturus Analytics Connector license is needed. For direct queries, a Cognos BI analytics user license or equivalent is required.
A: There are no special modeling requirements for the Analytics Connector. Power BI 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. The Analytics Connector also supports CQM and DQM.
A: Username and password credentials are passed through to Cognos during query execution, thereby enforcing relevant security applied within both environments.
A: The Analytics Connector is developed and enhanced with an agile methodology. Typically, we release a new version every 4-8 weeks. The updates are super easy to install.
A: The Senturus Analytics Connector uses an ODBC connection to connect to Cognos.
A: Power BI users leveraging the Connector will generate load on the Cognos servers similar to an interactive report user on those systems.