Choose Database Connection at runtime?

[Former Member]

I have a few databases with the same structure but different content. In fact it are databases from the same application, but from different customers.

But the choice of the database connection is part of the VC model.

What will be the easiest way to use the same model with different databases?

[Former Member]

There is no way to dynamically change the database connection during runtime.

(Except you use a "shell" database that is already connected to the other databases and there is somewhere a filter criteria for each customer database that you can exploit)

[Former Member]

And I discovered that changing the Connection URL in the System Landscape had no effect...

My conclusion is that the url from the Connection Container in the Visual Administrator is leading.

Is that true?

[former_member193545]

Hi

I think that you should create seperate systems for each DB and then in your VC model use guard conditions to allow access to the specific data base.

Jarrod Williams