If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Cognos Controller Licensing - reading from SQL Server  (Read 5899 times)

Offline pontushaglund

  • Associate
  • **
  • Join Date: Jan 2018
  • Posts: 1
  • Forum Citizenship: +0/-0
Cognos Controller Licensing - reading from SQL Server
« 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

Offline smiley

  • Community Leader
  • *****
  • Join Date: Oct 2005
  • Posts: 204
  • Forum Citizenship: +12/-0
Re: Cognos Controller Licensing - reading from SQL Server
« Reply #1 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.