update sql database using infopath - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

update sql database using infopath

Last post 03-24-2013 11:34 AM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-23-2013 02:02 PM

    update sql database using infopath


    I have the following business requirement:

    We have an InfoPath form published to a SharePoint library, and when this form is submitted to the library (after going through an approval workflow), it needs to create a new record in a table in a backend database.

    the table at the backdend database has some fields that are lookups to other tables so I assume this further complicates the task.

    is this possible with DBXL?

    thank you.

    Luis Carvalho

    Filed under: , ,
  • 03-24-2013 11:34 AM In reply to

    Re: update sql database using infopath

    Hi, Luis Carvalho!


    Yes, there are two ways to accomplish this:

    1)      Install DBXL Server and add the special Event Receiver to synchronize your forms

    ·        The XML to SQL mapping will be conditional based on the workflow state

    ·        No changes to the form are required

    ·        The Event Receiver is in beta, but will ship in v2.8 (in the next month)

    2)      Configure the workflow to call DBXL Server’s SubmitDocument Web method

    ·        Requires a custom workflow to call the Web method (or out-of-box Nintex, K2, ShP 2013)

    ·        No changes to the form are required

    ·        Works fine with DBXL v2.7 (no additional tools needed)


    For the lookups, you just need to add a query to your form that calls QueryDB Web method to get the correct value from the DB. If the fields already have the correct value no change is needed.


    I hope this answers your question.


    Please let us know if you would like to see a demo of the above techniques. Our support lead, Ernesto Machado, is a fluent Portuguese speaker.




    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.