Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Thierry on January 01, 1970, 12:00:00 AM
-
Is there someone who knows if it is possible to works with an oracle view and the ocs solution
-
I am trying to do the same with MSSql if any one has been sucessful.
-
You can modify calling list tables, but you can't strats o stops campaings. So if you had running campaign you can add new records into calling list or modify them.
-
John, what are you trying to do?
OCS can use Oracle views.
From our experience, we found that OCM is not the best way to update calling lists. So, we work directly with DB and let OCS do the rest.
What do you mean by views though? Do you mean MVIEWS?
If so, then you should not have any problem. Because DBServer would not be able to distinguish it from a table.
We also did some testing and found that if we add phone records directly into DB, OCS would become aware of it. We did not look into how it does it or how often, but, it works. (At least with 6.5.2)
-
We add data directly to the Oracle database also.
Its advisable to reindex the table after new records have been added as Geneys does not do this automtaically in some versions.
If the tables aren't reindexed after new records have been added and before that table is used for a campaign your retreival time for large tables will be very slow and will also eat up resources on the server.
-
Yes, I can back that up.
I also do recall reading in OCS 6.5 manual somewhere that we would need to create our own indexes if data is not added via campaign manager.