IVR Database Read Write and Intelligent queuing

[bghayad]

Hello;

VERSION: 2.4-309a, BUILD: 110430-1642, GoAutoDial CE 2.1, 2.6.18-238.9.1.el5.goPAE (SMP), Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz, Single Machine, Vtiger V5

Once the call reach for the telephony server, I need to be able to do database query (read and write) and get a customer profile and sending the call to the proper queue based on the customer information (his language, class, status, address, ... etc). How I can do this?

Regards
Bilal

[mflorell]

What database is this information stored in? How do you connect to that database?

[bghayad]

Generally the databases are: oracle, MySQL, MSSQL and PostgreSQL.
As you know that these databases are possible to connect to it via ODBC or ADO or from php ...
What are the possible methods and scenarios to do this?

Regards
Bilal

[mflorell]

Custom AGI scripting.

[bghayad]

OK, custom AGI scripting for read/write from the database, but after getting and writing the data, I need to play menu that is configured in vicidial, also I need to route to the proper queue (based on the read data from the database), how this will be done? I will need to use the vicidial AGIs within my custom AGI or I need build complete custom AGI that includes even the routing for queue and playing the menus and in this case, I will write same as vicidial AGI scripts ! What will be the most practical and simple way?

Thanks for the help.

Regards
Bilal