Data Quality Services and Lightswitch

Question

Hi everyone.

I´m working with DQS since the last week and i´m testing some things.

Now I´ve got the question:Is it possible to connect Lightswitch and a DQS Knowledge Base?

The reason why I´m asking this: I want to do an .csv-Upload with Lightswitch and validate the Data in this Process with the Knowledge out of a Knowledge Base.

Regards,

fab

Answer 1

I doubt there is a way to go directly from Lightswitch into DQS. If Lightswitch can insert into a SQL Server 2012 table, then DQS can pull in from there, or from a .csv file or Excel document.

The DQS API is not open for apps to interface with in SQL Server 2012, but it is a popular request.

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

Answer 2

Thanks for your answer.

But my purpose was it to check/validate the data before inserting into a SQL Server 2012 table - kind of "on the fly" cleansing.

In the moment the user wants to upload/insert the data, then the DQS should clean the data. So the user has no trouble with wrong data.

Answer 3

No, sorry. As I said there is currently no API to hook other apps up to talk to DQS to do cleansing with the workflow of the app. You can use SSIS, but you have to get the data out of Lightswitch to do that so its not what you want to do.

---

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

Answer 4

Okay :(

Thank you Jason