COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: mastan on 08 Nov 2018 01:11:39 AM

Title: How to change the Cognos 11 default database to Postgres database
Post by: mastan on 08 Nov 2018 01:11:39 AM
Hello team,
I would like to know how to change the default database of the Cognos 11 to Postgres. Could anyone please help me this.??...
Title: Re: How to change the Cognos 11 default database to Postgres database
Post by: MFGF on 08 Nov 2018 05:41:08 AM
Quote from: mastan on 08 Nov 2018 01:11:39 AM
Hello team,
I would like to know how to change the default database of the Cognos 11 to Postgres. Could anyone please help me this.??...

Hi,

Can you explain what you mean by "default database"? Are you referring to a database used as a data source, or are you referring to the content store database?

MF.
Title: Re: How to change the Cognos 11 default database to Postgres database
Post by: mastan on 09 Nov 2018 11:21:42 PM
Hi I am referring to the Content store database?..  Is it possible for Postgres??
Title: Re: How to change the Cognos 11 default database to Postgres database
Post by: hardstep on 10 Nov 2018 04:47:51 AM
You cannot use Postgres as a content store
Title: Re: How to change the Cognos 11 default database to Postgres database
Post by: mastan on 12 Nov 2018 01:01:51 AM
Hello, Thanks for the update...! Actually, I am new to the Cognos. would like to know the what is the default database will come with the setup file?
Title: Re: How to change the Cognos 11 default database to Postgres database
Post by: hardstep on 12 Nov 2018 02:55:44 AM
If you are doing an out-of-the-box installation then it will come with an Informix content store DB.
You can however use DB2, SQL Server or Oracle if required.
See this link for details of versions of content stores (aka content servers) : https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/prereqsForProduct?deliverableId=133544F0545D11E88CA35FB9AF6FA368

Title: Re: How to change the Cognos 11 default database to Postgres database
Post by: mastan on 25 Nov 2018 11:38:57 AM
Hello Thanks for your help actually for my Cognos Linux setup the looking for DB2 as a content DB so i have installed it and configured successfully.