Hi, Jackie,
it was my understanding that you had three different instance names. Or is it three different tables in the same instance? Depending on that answer you will have different approach to the problem.
Since I do not really know your requirements, here is the simplest solution I can think of no matter of what kind of layout you have:
The easiest thing to do would be adding three different DB Servers. Forget the wizard. Just add three different DB Servers to CME make sure that their ports are DIFFERENT!
Then, add three different DAP and select an appropriate DB Server for each DAP to use. In DB Info options of DAP, enter all the necessar information to access the database you need.
And this is it.
Of course, you will need to add a connection to UR. But, I think you got it backwards you add DAP TO UR and not UR to DAP. That is, go to UR's Connection and add the three DAPs you just created.
I am not sure what you are trying to do, but in whatever product you will be accessing those DAP, you will need to add those DAP to that product in that product's Connection.
Tell me if this does not work.
By the way, if you can confirm that all of the tables are in the same instance, you can get away with only one DB Server and one DAP.
I do recall being able to use more than one DAP with the same DB Server, even though, I just asked a Genesys professional support person we have with us today, and he told me that as far as he knows, you can only have a one to one relation between a DAP and DB Server... Go figure...
Vic
