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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Limit on number of databases?

Started by laks, 18 Aug 2010 12:31:23 PM

Previous topic - Next topic

laks

Hi Folks,

I would like to know is there any limit on number of databases a FM Model can connect. We have a new requirement to get data from over 200 MySQL databases ::) (very small databases).

As there are very small if possible we want to avoid ETL.

Thanks

dlafrance

i don't think there is a maximum of datasource, but you will have a lot of "fun" doing queries to join or union all the possible datasource.

It will be hard to maintain also, on developper side to have a lot of datasource..


cognostechie

Just sharing ..

In case , the schema structures are the same and the only difference is the data, you can use a Prompt to select the Database when you run the report. That way, you can avoid the joins and unions.

We had a situation where the customer had 30 schemas and the only difference was the data, not the structure of the schema.

laks

Intersting  :o...

Thanks for sharing.

So is the prompting handled at FM level or at data connection level?  ::)

blom0344

#5
In Cognos connection you can assign 1 or more connections for each datasource (we often have 10 defined). When you run a report you will automatically be prompted if the datasource has more then 1 connection defined. Each connection point to a different database (as long as database structures are identical, this will work)

laks