Author Topic: Alternative Content Store Database  (Read 5786 times)

Offline Chamopak

  • Full Member
  • ***
  • Join Date: Feb 2015
  • Posts: 42
  • Forum Citizenship: +0/-0
Alternative Content Store Database
« on: 22 Jun 2015 08:15:56 am »
The Cognos Express uses the Informix database as its default content store database.
Is is possible (and Allowed) to use an alternative e.g. SQL Server for the content Store?


Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,273
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Alternative Content Store Database
« Reply #1 on: 23 Jun 2015 06:09:33 am »
The Cognos Express uses the Informix database as its default content store database.
Is is possible (and Allowed) to use an alternative e.g. SQL Server for the content Store?

Hi,

Not in versions of Express up to and including 10.2.1, no. In all versions to this point, Informix is the only content store database you can use.

MF.
Meep!

Offline Chamopak

  • Full Member
  • ***
  • Join Date: Feb 2015
  • Posts: 42
  • Forum Citizenship: +0/-0
Re: Alternative Content Store Database
« Reply #2 on: 20 Aug 2015 01:49:07 pm »
Thank you for your info, it was helpful (sorry for the delay in answering)


Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,273
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Alternative Content Store Database
« Reply #3 on: 21 Aug 2015 03:40:08 am »
Thank you for your info, it was helpful (sorry for the delay in answering)

If you upgrade to Express 10.2.2, however, you can use a content store in SQL Server :)

MF.
Meep!

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,273
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Alternative Content Store Database
« Reply #4 on: 21 Aug 2015 05:36:38 am »
Chamopak wrote in a personal message:

Hi

Question,  what is the difference in installing Cognos Express 10.2.1 with 10.2.2  or BI 10.2.2
Thank you for your answer

Will the installation process change completely to resemble the Enterprise / BI or its the installation of 10.2.2 same as 10.2.1  but with the option of choosing your content store?

From 10.2.2 onwards, Cognos Express is now just a licensing model for Cognos 10 BI and TM1. There is no longer a specific download for Express - you download the enterprise versions of BI and TM1 and install them as you would install an instance using enterprise licensing. For BI 10.2.2 there is a new "quick install" that gives you a BI instance using DB2 as a content store and web access via the servlet gateway (so no web server required), or you can do a "normal" install and set up your own content store and web server. The old Express method of installing a Manager instance (with Informix content store) which then auto-provisions BI and TM1 is gone.

Cheers!

MF.
Meep!

Offline Chamopak

  • Full Member
  • ***
  • Join Date: Feb 2015
  • Posts: 42
  • Forum Citizenship: +0/-0
Re: Alternative Content Store Database
« Reply #5 on: 27 Oct 2015 06:46:58 am »
Hi Guys,

I am using my ole post to ask this question, I am looking for the Upgrade Document of IBM Cognos Express 10.2.1 to 10.2.2

Can anybody lead me to it?

Thank you.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,273
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Alternative Content Store Database
« Reply #6 on: 27 Oct 2015 06:59:40 am »
Hi Guys,

I am using my ole post to ask this question, I am looking for the Upgrade Document of IBM Cognos Express 10.2.1 to 10.2.2

Can anybody lead me to it?

Thank you.

Hi,

There isn't much in the docs, sadly. Take a look at the Express 10.2.1 Manager guide, chapter 4 and the section "Upgrading from Express to an Enterprise product".

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1/ig_exprss.pdf

This is essentially what's happening in terms of the product when moving to Express 10.2.2 - the installs are the same as for the Enterprise versions.

MF.
Meep!

Offline Chamopak

  • Full Member
  • ***
  • Join Date: Feb 2015
  • Posts: 42
  • Forum Citizenship: +0/-0
Re: Alternative Content Store Database
« Reply #7 on: 27 Oct 2015 12:55:27 pm »
Hi,

There isn't much in the docs, sadly. Take a look at the Express 10.2.1 Manager guide, chapter 4 and the section "Upgrading from Express to an Enterprise product".

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1/ig_exprss.pdf

This is essentially what's happening in terms of the product when moving to Express 10.2.2 - the installs are the same as for the Enterprise versions.

MF.

I did find this in the document:
You do not need to install a web server. The Quick Setup option configures a
servlet gateway as part of the installation, meaning that there is no need for a
web server


Does this mean that there is still a seperate Express installer of does the new BI 10.2.2 come with an automatic / Quick Setup Option?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,273
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Alternative Content Store Database
« Reply #8 on: 27 Oct 2015 02:42:55 pm »
I did find this in the document:
You do not need to install a web server. The Quick Setup option configures a
servlet gateway as part of the installation, meaning that there is no need for a
web server


Does this mean that there is still a seperate Express installer of does the new BI 10.2.2 come with an automatic / Quick Setup Option?

No - there's no separate Express installer. Cognos BI 10.2.2 has a quick install option that installs the Cognos 10 BI with the servlet gateway and DB2 for use as a content store and a My Data Sets repository.

MF.
Meep!

Offline Chamopak

  • Full Member
  • ***
  • Join Date: Feb 2015
  • Posts: 42
  • Forum Citizenship: +0/-0
Re: Alternative Content Store Database
« Reply #9 on: 03 Nov 2015 01:09:51 pm »
I am having problems starting up the CXMD in the 10.2.2 env.

Is there a specific setting for the tm1s.cfg to be able to start the old 10.2.1 TM1 server into the new 10.2.2 env?


Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,273
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Alternative Content Store Database
« Reply #10 on: 05 Nov 2015 03:51:09 am »
I am having problems starting up the CXMD in the 10.2.2 env.

Is there a specific setting for the tm1s.cfg to be able to start the old 10.2.1 TM1 server into the new 10.2.2 env?

Not as far as I'm aware. What security setting (integratedsecuritymode) is defined in tm1s.cfg? Are you using the same authentication provider?

MF.
Meep!

Offline NLRST

  • Associate
  • **
  • Join Date: Apr 2016
  • Posts: 1
  • Forum Citizenship: +0/-0
Re: Alternative Content Store Database
« Reply #11 on: 12 Apr 2016 05:41:29 am »
Good to see that other database can now be userd as content store. However, IBM says: IBM Cognos Content Database can be used where you do not want to implement a commercial database for the content store, such as in a test or proof-of-concept environment. You must use a supported commercial database for the content store in a production environment.

Does someone know how the licensing for the commercial database should be? Or can I use SQL Server Express?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,273
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Alternative Content Store Database
« Reply #12 on: 13 Apr 2016 08:25:31 am »
Good to see that other database can now be userd as content store. However, IBM says: IBM Cognos Content Database can be used where you do not want to implement a commercial database for the content store, such as in a test or proof-of-concept environment. You must use a supported commercial database for the content store in a production environment.

Does someone know how the licensing for the commercial database should be? Or can I use SQL Server Express?

Hi,

No - SQL Server Express isn't supported for use as a content store database.

MF.
Meep!

 


       
Twittear