Hello,
I have a requirement to connect to different databases depending on a given condition. The condition can be encoded as a part of the URL. I want to use the same CMS code, same template, same page types, etc.; but to connect to a different database.
For example lets say I have a site called http://my_sample_site.com/ and I want SS to use the database 'fruits' whenever the URL http://my_sample_site.com/fruits/ or http://my_sample_site.com/?target=fruits is found. Likewise I may have another database called 'vegetables' whenever SS sees http://my_sample_site.com/vegetables/ or the other variant of the URL. Is this possible by any means?
I can do this by using an HTTP Post variable but then permanent URLs cannot be given.
Tried using Subsites module but no luck. It installs without issues but I don't get the Subsites drop-down on the CMS admin.
Any help is greatly appreciated.
Thanks.