Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here




Hi All,

Has anyone of you had any kind of experience with Microsoft CRM and its integration with IPO. There is software “connector” for that but it provides only pop-up feature and outbound dialing from CRM tables.

The main customer requirement is to make SQL query into DBs of MS CRM but customer states that DBs of MS CRM is closed for queries from VM Pro and query only can be done through MS CRM platform. Is it valid or not?

I will appreciate any advice regarding this issue.

Thanks in advance.



What exactly are you trying to accomplish, papic?  That would help us give you better advice.

Off the top I would say it's the IVR licence you want, not the MS-CRM integration licence, but need to know more about your intentions.



First off all, I want to thank you for your intention to help me with this case.

I want to accomplish following:
Call is coming to IVR (VM Pro). The first point will be general voice announcement for the calling party, and while the caller is listening voice prompt, I want to make SQL inquiry to MS CRM date base regarding caller’s ID. If it is recognized (caller’s ID) in the DB, the inquiry will return back information from date base which level of customer it is and that would be criteria for further transfer.
-    If it is high level of customer, he/she will be transfer to specific agent. When call comes to agent, regarding caller’s ID it should be open (pop up) customer ticket from MS CRM (another SQL inquiry or may be something else).
-    If it is customer with other level of importance, the call will be transferred to correspondence agent following with pop up function of customer ticket.
-    If it is call without caller ID or unknown caller ID it will be transfer to operator or to someone else.

This is brief what I want to make. So, there are many SQL inquires from IVR system (VP Pro) to DBs of MS CRM. The main question is: Is it possible to make something like that apropos is it possible to make SQL inquiry from VM Pro (with necessary license for third party base integration) to MS CRM?

Is it MS CRM DBs are closed for such SQL inquires?

Thank you in advance for any kind of advice.

Best regards,



Ok, you will need BOTH the IVR and MS-CRM licences then.  As for the DB's being closed, I don't think that is a technical issue so much as the customers policies.  I see no reason technically you could not point the VMPro database tokens as the MS-CRM databases, although I confess I have not tried it personally.  I suspect it's more a case of the customers IT guys being terified you will mess up their DB, or leave a gaping security hole.  Get your own IT guys to discuss it with them and calm them down.



That is the main problem that neither customer IT guys neither my IT group doesn’t have enough experience with MS CRM. Customers’ IT guys don’t want to allow us to deal with their DBs and at the other side we cannot claim something in what we are not sure. So, spellbound circle!!!!!


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close