Connect to mysql and customer balance

[vliegj]

A customers wants the ability when a user calls in to enter their account number.
IPOCC will connect to their database and the customer will hear ""your balance is .....""

Is this possibel in IPOCC 9.07 and how?..

Thank you

[flaatten1]

Yes it's possible and you would use the IPOCC IVR with the ODBC connector. You would prompt and collect the account number and store it in a variable. Then pass that account number in the SQL query using the ODBC tools and get back the balance and store in a return variable. Then use the text to speech block and speak the balance to the caller.

[verma62]

Hi,
Database integration functionality is possible and I have tested the same with MSSQL database. IPOCC IVR document specifies the database connectivity limited to MSSQL, MSACCESS and Posgres database only.

I haven't tested with other database yet.

[vliegj]

Thnaks i will try it

[verma62]

Were you able to test it with MYSQL. I don't have mysql setup at my end so not able to test it.