Custom Databases DAP & DBServer??s

[Jackie]

I have three Oracle instances in one database that I would like to access (data dip) before routing the contact event. Am I on the right track to run the dbinstall.sh script (yup I'm on Unix Solaris; running Genesys 6.0 Framework) to create my own DBServer? Also may I use the same DBServer for each Oracle instance? Haven't found any documentation that explains adding/creating your own DBServer...I copied the template over into the Application Template folder in CME.

[Vic]

You can get away with one DB Server; however you will need to define three different Data Access Points where you will define three different aliases you want to use.

In fact, you can use a standalone DB Server as your main DB Server without starting a second one mentioned in G6 manual.

Tell me if you need more help.

Vic

[Jackie]

I have encountered problems adding the DBServer and the DAP. I've been told by Genesys that only one DBServer and one DAP is okay and will serve my needs for three tables in the same instance with same user. This is different from your information.

I ran the dbserverinstall.sh and provided the information about host, port, directory, etc. When I checked the application directory, there was no .conf file so I copied the one from another DBServer app directory and edited the file. I think steps are missed since the DBServer was not created at the time of install with the Wizards.

The DAP was defined in CME and I've been told to add a connection to the Universal Routing Server (Properties:Connection). CME spits back an error message and will not allow the DAP to be added. Just for grins, I tried adding the new DBServer and there were no complaints from CME.

Finally I got a custom dbserver.log file with some entries and it's complaining that it can't connect to the database the DBMS name, username and password arguments are blank. Possibly the result of the lack of a UR Connection definition?! DBServer and DAP have the right information. It's a mystery that I'm slowly unraveling as to how everything is set and what fields map to IRD DB Wizard fields when you're in Interaction Routing Designer and have inserted the database wizard for database dips.

[Vic]

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