COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: bhupendra.fatnani on 22 Jul 2015 05:50:48 AM

Title: Modify Connection
Post by: bhupendra.fatnani on 22 Jul 2015 05:50:48 AM
Hi,

What are the ways to list down and modify the Connections being used by Framework Manager?
Is there any way we can modify the connection parameters after the project is created, so that any changes can be recorded in the Framework Project?

Thanks,
Bhupendra
Title: Re: Modify Connection
Post by: bus_pass_man on 22 Jul 2015 08:44:00 PM
Edit the content manager data source connection, catalog and schema properties to match your data source.

Title: Re: Modify Connection
Post by: bhupendra.fatnani on 23 Jul 2015 02:57:29 AM
QuoteEdit the content manager data source connection, catalog and schema properties to match your data source.
Ok. And what do I set them to?
Can you please guide?
Title: Re: Modify Connection
Post by: Michael75 on 23 Jul 2015 05:43:19 AM
Is your question one that's arisen through your work, or are you preparing for an interview?

You should know from your requirements what values you should set them to. Nobody here can help you on this one  ::)

Take a look at the IBM Cognos doc here: http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_fm.pdf (http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_fm.pdf), page 33 onwards.
Title: Re: Modify Connection
Post by: bhupendra.fatnani on 24 Jul 2015 02:42:22 AM
QuoteIs your question one that's arisen through your work, or are you preparing for an interview?
Hahahaha.. I'm new to Cognos and learning how to do some of the functions.
Modifying a connection is one of the tasks which arises every now and then, like changing a password,updating TNS names,etc.? right?

QuoteYou should know from your requirements what values you should set them to. Nobody here can help you on this one  ::)
Yes I already know what values I would set, however, don't know which property parameter should map to what value.
Also, there should be a simpler way to modify a connection once set in Framework Manager, shouldn't there be?

I hope you now know what I'm looking for.
Title: Re: Modify Connection
Post by: bus_pass_man on 24 Jul 2015 11:35:06 PM
Quotethere should be a simpler way to modify a connection once set in Framework Manager, shouldn't there be?
Simpler than selecting something and editing some of its property values in the property pane?

QuoteI hope you now know what I'm looking for.

I think you ought to know that I'm not quite sure if the problem that you've defined in this thread matches what you think you've defined because I'm not sure what difficulty you've encountered that our answers have failed to address and solve.

As a boy, I forced my hand to do the Vulcan salute so now it comes naturally but that doesn't mean I can do the Vulcan mind-meld.  I'm not going to mention pon farr.

QuoteI already know what values I would set, however, don't know which property parameter should map to what value.
The content manager data source connection property maps to the name of the content manager data source which you want to use.   The schema property maps to the schema of the underlying data base which is defined in the data source connection.  Ditto for the catalog, which may not exist in your database, in which case you just leave it blank.   There's a complext property near the end of the list of properties, which when expanded shows a two letter code identifying the data base vendor type (d2 for db2, or for oracle etc. ) but I don't think it does anything.  The docs might have something about it though.

An alternative, which isn't quite as simple as that, is to import a table from the data source that you want to use, select the newly created data source connection and the data source connection you want to modify and use the little black inverted triangle thingy in the values columns of the property pane to copy the property values you want to copy over. 
Title: Re: Modify Connection
Post by: bhupendra.fatnani on 27 Jul 2015 05:57:12 AM
Well,
I think the post had gotten a little too far. However, the last paragraph in the previous post is exactly what I was expecting in terms of the answer. Although it doesn't answer it completely, however, a lot more appreciated.
I chose to skip through the rest of the answer though.
Many thanks for the help.

Cheers,
Bhupendra