I have two Oracle 11g databases, one for testing (
tst.world) and one for production (
prd.world). Except when I am trying out new things, they have exactly the same table structure.
In ArcCatalog I have created a connection - let's call it
My Connection - to the test database. I use it in a .mdx file to display data from multiple tables in the test base. When the file is opened I get a prompt asking me to enter username and password:
I would like the user to be able to choose between the test and the production database in that prompt, or in some other way choose which database to get the data from. Right now this is not possible since the field "Instance:" is greyed out. So far the only way in which I have been able to accomplish this is to use two separate .mdx files whit exactly the same content except that they use different connections. Clearly that is not a good solution.
Another solution would be to edit the connection settings in ArcCatalog every time I want to switch database. That works for me, but I am afraid it would be considered too complicated and tedious by many of the end users.
Is there a better way to accomplish this task?