none
Integrating Custom Client Application with DQS

    Question

  • Hi

    We have a custom CRM developed using .Net. Would like to enhance the customer search function to identify potential duplicates. Can the custom CRM be integrated with DQS so that when user enter new customer details to perform a search, it will call on the DQS (Knowledge Base) and return search result with the matching score to prevent setting up a duplicate?

    Thanks


    Alv

    Sunday, January 19, 2014 11:04 PM

Answers

  • Unfortunately DQS does not have any  API for remote access from your custom applications, but that is a popular feature request. So there isn't a clean easy way to call cleansing from an application.

    If you have an SSIS package that could do the DQS cleansing in an automated way using the SSIS API you may be able to get something working, but it would be a more cumbersome solution. SSIS packages can be designed on the fly, and run inside a .Net application, or called via a stored procedure http://technet.microsoft.com/en-us/library/jj820152.aspx 

    See Q12 in the FAQ here http://social.technet.microsoft.com/wiki/contents/articles/3919.data-quality-services-dqs-faq.aspx#Q_12_Will_DQS_provide_public_APIs

    Vote here https://connect.microsoft.com/SQLServer/feedback/details/696741/dqs-access-matching-cleaning-via-web-service-or-other-endpoint

    Thanks, Jason


    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

    Wednesday, January 29, 2014 5:15 AM
    Moderator

All replies

  • 1. For DQS i dont know.

    2. But you can index your specifics columns with (Full Text Index), to improve the performance and use the synomyme like :

    Casablanca = Casa

    Microsoft = MS

    Monday, January 20, 2014 12:46 AM
  • You can build a SSIS process and use DQS components to clean your data from your custom CRM system. As of this moment, SSIS does not have a native component for deduping but you can use this CodePlex component (search for ssisdqsmatching on codeplex). For both scenarios you need to create the corresponding KB and domains to support the cleanse and matching.

    After this process is completed you can integrate it with your CRM system but keep in mind that you need to constantly maintain you domains in DQS to get accurate results.

    Monday, January 20, 2014 1:57 AM
  • Hi Jose

    Thanks for the reply. 

    I understand that SSIS process can be use to find dupes in existing CRM system. But what I am trying to do here is the ability to create a search function on the custom app so that before a user set a new customer, they can enter first name, last name and DOB to do a search to see if it is an existing customer (utilising the KB and domains in DQS). I am hoping that the search result will return the absolute and fuzzy match with the respective match score which will enable users to make decision if it is a match.

    Cheers

    Alvin

    Monday, January 20, 2014 9:41 PM
  • Unfortunately DQS does not have any  API for remote access from your custom applications, but that is a popular feature request. So there isn't a clean easy way to call cleansing from an application.

    If you have an SSIS package that could do the DQS cleansing in an automated way using the SSIS API you may be able to get something working, but it would be a more cumbersome solution. SSIS packages can be designed on the fly, and run inside a .Net application, or called via a stored procedure http://technet.microsoft.com/en-us/library/jj820152.aspx 

    See Q12 in the FAQ here http://social.technet.microsoft.com/wiki/contents/articles/3919.data-quality-services-dqs-faq.aspx#Q_12_Will_DQS_provide_public_APIs

    Vote here https://connect.microsoft.com/SQLServer/feedback/details/696741/dqs-access-matching-cleaning-via-web-service-or-other-endpoint

    Thanks, Jason


    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

    Wednesday, January 29, 2014 5:15 AM
    Moderator