DATABASE INTEGRATION

IVR Database Integration



Inform caller of his/her account status, last payment date and pending balance (if any) based on the account number collected from the caller.

databaseintegration

Step 1: Similar to Hello Date example, collect the account number from the caller and store it as accountnumber variable.

Step 2: Query your database and retrieve status, last payment and pending balance.

Table Schema:

Field Type Key
AccountID long PK (Primary Key)
status enum('inactive','active');
lastpayment Date
pendingbalance double

Select status, lastpayment, pendingbalance from billing Where AccountID = '$accountnumber'.

databaseintegration

Store the required results into variables in the Result Tab. Each column from the query resultset is assigned one by one to the variables in the result tab.

databaseintegration

Step 3: Play the information (variables) retrieved from your database (IVR Database Integration)

databaseintegration
 
Play Message
Invox will conveniently charge the callers for the time they have spent speaking with you or your angents.
Get Input Node
Caller's credit card is first validated before the call is forwarded to the agent.
Variable Node
Invox will automatically compute the price real-time based on call duration and conveniently charge the caller's credit or debit card.