Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Controller => Topic started by: pontushaglund on 30 Jan 2018 03:05:36 AM

Title: Cognos Controller Licensing - reading from SQL Server
Post by: pontushaglund on 30 Jan 2018 03:05:36 AM
Hello.

I have a customer that is using Cognos Controller that uses a Microsoft SQL Server as the backend database. We're trying to figure out if a license is needed to read data from the Cognos data straight from SQL Server (without using any Cognos license). Anybody that has an answer to this question?

Thanks,

Pontus
Title: Re: Cognos Controller Licensing - reading from SQL Server
Post by: smiley on 30 Jan 2018 04:41:06 AM
You can use the datamart option from Controller.
That will create a star schema in the Controller database, ready to report on.
https://www.ibm.com/support/knowledgecenter/en/SS9S6B_10.3.1/com.ibm.swg.ba.cognos.ctrl_inst.10.3.1.doc/t_ctrl_usedatamart.html

As for Controller tables themselves, they are not encrypted, so you can extract whatever you want from it.

I don´t see why you should have anything to do with licensing. You own the data that Controller generates.
Text only | Text with Images