" /> Outbound and database view - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: Outbound and database view  (Read 5328 times)

Thierry

  • Guest
Outbound and database view
« on: January 01, 1970, 12:00:00 AM »
Advertisement
Is there someone who knows if it is possible to works with an oracle view and the ocs solution
Logged

John

  • Guest
Outbound and database view
« Reply #1 on: January 01, 1970, 12:00:00 AM »
I am trying to do the same with MSSql if any one has been sucessful.
Logged
Marked as best answer by on Today at 10:04:57 PM

peter

  • Guest
Outbound and database view
« Reply #2 on: January 01, 1970, 12:00:00 AM »
  • Undo Best Answer
    • 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.
    Logged

    Fon Wang

    • Guest
    Outbound and database view
    « Reply #3 on: January 01, 1970, 12:00:00 AM »
    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)

    Logged

    Paul

    • Guest
    Outbound and database view
    « Reply #4 on: January 01, 1970, 12:00:00 AM »
    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.
    Logged

    Jeff K.

    • Guest
    Outbound and database view
    « Reply #5 on: January 01, 1970, 12:00:00 AM »
    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.
    Logged
    Pages: [1]   Go Up
    « previous next »