Telephone to and from SQL Database

Question
What would I research for a Telephone application that would read and write to a SQL Database or similar.

The Telephone application would
Read Telephone # from the incoming phone call and check it with the database
      Recognize it or not Recognize
      
Telephone Ask --> What is the property ID
   User Responds-> 1234

Telephone Ask --> Was it finished with no problems?
   User Responds-> Yes/No
      If No --> What is the problems?
            User Responds-> xxxxx
            
and so on             

I'm not sure what to research, but I believe there is such a thing - when I call my credit card company they ask for my info so they can give me my balance

Thanks in advance for any help you can give.
LJG
LVL 2
LJGAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
SQL database is just a small portion of the whole system in this case. If you are developing such system then the data storage is something invisible in the backoffice and you should rather focus on the hardware and technology which you are planning to use.

You'll need good and reliable internet connection, VoIP PBX, and the software to handle all your needs. The database itself is almost irrelevant. Do you plan to write everything yourself or are you looking for the solution in a box?

I would recommend to start here: https://toughnickel.com/business/auto-attendant-guidelines
And you may look e.g. here how such business can grow: http://www.messagingservice.com/business-phone-answering-systems/
0
LJGAuthor Commented:
Thanks pcelba

I'm Looking for a Solution in a box - but easy to program

So have the Telephone Ask -->     What is the property ID
          when the User Responds-> 1234
                            The program looks up Property ID ---> 1234
                                     * If it finds the Property ID the telephone tells the user "Jones Dept Store 123 Main, Kansas City, MO"
                                     * If it can't find it, the telephone tells the user "Can't find  Property ID ---> 1234"  
                                       Do you want to disconnect or enter another number

I could see 20 questions like this most of them veering off in different directions

Any thoughts
0
Bernard S.CTOCommented:
Note that on any mobile phone you get a recognition if the incoming calk...
So your problem is really a platform problem.-
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

pcelbaCommented:
So your research should start with existing software providers. You may look at these applications at the beginning:
https://virtuatell.com/omnichannel-surveys/post-call-telephone-surveys/
http://www.voxco.com/survey-software/cati/
https://www.voicent.com/phone-survey/
https://www.surveysystem.com/interviewing-cati.htm
http://www.survoxinc.com/phone-survey-software/

Some of them are offering trial versions so try them. But remember the above list cannot be complete and if you start searching web then you will find many more companies providing this kind of software.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pcelbaCommented:
BTW, why should you restrict the application to phones? It becomes obsolete and you should provide more channels.
Look here for survey software comparison: https://survey.financesonline.com/
1
LJGAuthor Commented:
Thanks pcelba!  I think your comments gave me what I needed to move forward.

CATI (Computer-Assisted Telephone Interviewing) Software
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.