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

 

Where to set the Content Store(database information) on Framework Manager?

Started by ratnalein, 23 Jul 2013 02:46:00 AM

Previous topic - Next topic

ratnalein

Hallo everyone,

in my company, everything is set well:
I am working with Framework Manager in a windows Work-Station.  After I created a package within Framework Manager, I publish the package, and everything is just fine.  I have just learnt that the publishing process is actually a process of sourcing the Content Store (database).  In our case, it is DB2.

I would like to understand where the configuration file from Framework Manager, so that Framework Manager knows in which database server, database, storage etc it should source the package.  Especially, how the connection between the Framework Manager and Content Store is developed when the publishing process runs.

Thank you for your information.

Regards,

Ratna :)

wyconian

Hi

In FM the connection to the data source is specified in the data sources section of the model.  This points to a connection set up in cognos administration which in turn specifies the database and logon.

Hope that helps.

cognostechie

Quote from: ratnalein on 23 Jul 2013 02:46:00 AM
Hallo everyone,

in my company, everything is set well:
I am working with Framework Manager in a windows Work-Station.  After I created a package within Framework Manager, I publish the package, and everything is just fine.  I have just learnt that the publishing process is actually a process of sourcing the Content Store (database).  In our case, it is DB2.

I would like to understand where the configuration file from Framework Manager, so that Framework Manager knows in which database server, database, storage etc it should source the package.  Especially, how the connection between the Framework Manager and Content Store is developed when the publishing process runs.

Thank you for your information.

Regards,

Ratna :)

Ratna -

When FM is installed on a work station, there is a component of Cognos also installed called Cognos Configuration. If you open the configuration, you will see that it is pointed to another server which would be Cognos app server. The app server is configured to connect to Content store. The DB and logon information is given there when Cognos is configured.

kommireddy

1. Make sure your FM Cognos Configuration on workstation is pointing to required server instance, through Gateway URI and dispatcher URI
2. You should have a DB client (Control center in case of DB2) on your workstation and you need to catalog your reporting DB with same alias as one you cataloged on cognos application server(s). This is important point and could be missed by many. Without this, you cannot test data source connection in FM and test/validate the query subjects.

I believe you are getting confused between content store and reporting (source) DB. When you work in FM, you don't need to configure content store DB explicitly, it goes through FM cognos configuration. All you need is, admin access (license) on portal to publish the package.

sir_jeroen

Framework Manager doesn't connect to the content store. It publishes data to Cognos using the dispatcher (http://....:9300/p2pd/servlet/dispatch
The dispatcher will then route the data to the content manager service which stores it in the contentstore database (take a look in the Cognos Architecure Guide).

But why do you want to know all this... It sounds to me that you are looking to find a way to get pass this... (No offence)