Thanks for the response. We are supporting SQL and Oracle stack set of databases.Schema remains same between the two.
We are maintaining same VDB with changed vdb.xml to connect between SQl adn Oracle. So there should be a person supporting when they want to make this switch or maintain different set of data sources wiht same name in 2 servers.
We are trying to avoid this scenario and we want to deploy the VDB with pre-configured connection information for SQL and Oracle.
So when the SQL connectivity is present, the data to be returned from SQL sources and vice-versa. Also if both connection exists, there should be some parameter which would help us to chose which source (SQL or Oracle) to pick from.
> there should be some parameter which would help us to chose which source (SQL or Oracle) to pick from.
What is that flag/event currently your person is basing this on?