Avaya Support Forums  

Go Back   Avaya Support Forums > IP Office Contact Center

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 08-19-2015, 12:05 PM
vliegj vliegj is offline
Whiz
 
Join Date: Jun 2014
Location: Curacao
Posts: 42
vliegj has 10 reputation points
Default Connect to mysql and customer balance

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
Reply With Quote
  #2  
Old 08-21-2015, 08:45 AM
flaatten1 flaatten1 is offline
Member
 
Join Date: Mar 2012
Posts: 4
flaatten1 has 10 reputation points
Default

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.
Reply With Quote
  #3  
Old 08-21-2015, 11:53 PM
verma62 verma62 is offline
Brainiac
 
Join Date: Apr 2015
Posts: 59
verma62 has 10 reputation points
Default

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.
Reply With Quote
  #4  
Old 08-24-2015, 08:05 AM
vliegj vliegj is offline
Whiz
 
Join Date: Jun 2014
Location: Curacao
Posts: 42
vliegj has 10 reputation points
Default

Thnaks i will try it
Reply With Quote
  #5  
Old 08-25-2015, 03:01 AM
verma62 verma62 is offline
Brainiac
 
Join Date: Apr 2015
Posts: 59
verma62 has 10 reputation points
Default

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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 02:50 AM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.