Architecture: reports should be run against many databases (identical sources, different companies).

Hi there,

we have a Forms/Reports application, which is used for 3 companies. Each company has a separate database, the source code is identical. By now, we provide the database at the login form (for the Forms part) and the user decides for which company he wants to start the application. Reports are started using "userid=username/password@database" as part of the url which calls the Report server. This design is many years old and I know... but I can't change it.

Now we are about to migrate from Reports to BI Publisher and this one-application-for-many-databases seems to be a problem. A BI Publisher report has a data model and in that data model I assign a database as the data source. So for serving 3 companies I would need 3 identical data models (only difference would be the data source name, queries are the same) for every report. And I would need 3 identical reports, each using it's companies data model. The layout would also be the same, despite of the logo. That doesn't make any sense. Providing a BI Publisher