-
1. Re: Multi source model from different database type (SQL & Oracle)
rareddy May 30, 2018 8:38 AM (in response to cm.kumar)Sure it is possible. What is the selection criteria for the source selection? How are you intending to pass that information? Read a related thread datasource selection according to the caller user
-
2. Re: Multi source model from different database type (SQL & Oracle)
cm.kumar May 31, 2018 8:22 AM (in response to rareddy)Hello Ramesh,
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.
Thanks.
-
3. Re: Multi source model from different database type (SQL & Oracle)
rareddy May 31, 2018 9:44 AM (in response to cm.kumar)> 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?