How to point current FM package to new datasource ?

[sanchoniathon]

Hi to all,

I will like to point all reports using a specific FM package (named devPackage) to another database ?
In order to do that i need to do what exactly ?

I am a bit confused because i've been told that i have to first create a new datasource in FM manager that points to the new database. But then how do i tell FM that the actual FM package points to the new datasource ? Am i obliged to modify the existing datasource and if so what exactly do i need to perform after ?

Please can someone tell me the exact steps for what i whant to do ?

Thanks in advance poeple !

[John Doe]

Have a look at the properties for the datasource connection within the FM model.  There's a property called 'content manager datasource'  You can change this to another datasource that exists within the portal.

Ensure that the schema and catalog properties are accurate (if applicable)

[sanchoniathon]

One more question: After having created my data source in Cognos Connection, i then had to go and point in FM to the new data source (created in Cognos Connection), but do i need also need to create a new data source in Frame work Manager ?

Also, after pointing to the new data source in FM, what do i need to do next ? Reimport tha METADATA ? How do i do that ?

Thanks for your valuable Help !

[Feanor]

The only thing you have to do is to change the [Content Manager Datasource] in your FM model to point to the newly created datasource.

After inserting the new name datasource name, FM will automatically try to connect to your new datasource. Just try it. You can check your new connection by testing various [Query Subjects] in your FM model. If you see the expected data then your change was succesfull. If you get an error then there is something wrong, most likely there's a chance that;

-> you haven't entered the correct name of the new datasource,
-> or the new datasource/connection is not correctly defined,
-> or the data in your new datasource is not in the same format as your existing datasource.

[shaik]

hi guys

even im also having a similar kind of problem. i hav 8.2 installed in my system n im using windows XP as OS and Oracle as DB. my installation n configuration is succesful.

if im trying to import Data Source in FWM its showing error.

my question is how can i create data source in Oracle n how can i connect it n import it to FWM. can any one help me in getting the solution. step by step process will be appreciated.

n even in cognos connection, how can i deploy those created datasources n work on it to build reports.

thanks in adv

[Feanor]

What kind of error do you receive?

For Oracle databases you'll need to install the Oracle client software on your Cognos server ánd all of the system(s) that will make use of FM.

After this you'll have to configure an address so that FM manager can connect tot the Oracle database. Addresses are configured within the tnsnames.ora file that is installed with the Oracle software. This file normally resides in the ORACLE HOME\NETWORK\ADMIN directory.

Add the following entry in your TNSNAMES.ORA file and change the values shown in brackets to suite your environment:

<addressname> =
(DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(Host = <hostname>)(Port = <port>))
   )
(CONNECT_DATA =
   (SERVICE_NAME = <sid>)
)
)

If you like, you can use the Oracle tool "sqlplus" to test your entry aside of FM.

After this you can set up your Oracle datasource within FM. Based on the <adressname> and the appropriate password you can add the datasource.

Good luck

[NaviGator]

John Doe .. Thanks a lot for this note ..