How to Pass Datasource Name via Report Studio Link

[froto23]

I have a situation that is unique. I have over 20 customer databases that have different data, but the database structure is all the same. I want to be able to create one framework that will be able to execute on all database for a given report. I was wondering if the database name can be passed as a parameter via a URL (p_databaseName=db1) and then how would I modify either the framework model or the report to dynamically insert this into the SQL. Any help would be much appreciated. Thanks.
- Christopher

 

[blom0344]

There is no need for such a construction. You can specify 20 different connections for a given datasource and then choose the right connection at run time.

We use this as a standard option with 1 model for umpteen customer databases on one SQL instance.

I think that it is just as well possible to dynamically steer users towards a certain database by using standard Cognos security settings on the datasource connections.

Ties Blom

 

[froto23]

Thanks for your response. I realize what you are saying is possible, but we don't customer A to be able to choose customer B's database. We currently are able to select the database at run time also. I was looking for a way to short-circuit this selection via a URL parameter or something else. Do you know of a way to do that?

 

[blom0344]

This is confusing. How would your customer A have access to Customer's B database in the first place? Do you mean that you have 1 Cognos instance that is used by multiple customers? Do the multiple databases reside on one database server instance? you need to paint the picture more clearly..



Ties Blom