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
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..
thanks :)
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.
Intersting :o...
Thanks for sharing.
So is the prompting handled at FM level or at data connection level? ::)
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)
Cool.. Thanks a lot..