Infopath help

Posted on 2011-04-20
Last Modified: 2012-05-11

I have a requirement, where I need to surface SQL data in infopath form. The actual scenario is like we have some pre-recorded data in SQL database. The user will first enter an ID in the infopath form based on which it will retrieve some data from SQL database. The data that user enters in infopath form should perform some validations against the database and notify the user if validation fails.

My questions are:

What are the challenges involved with infopath integrated with SQL data source?
Is infopath a good fit for this? or a custom WPF application that can talk to and cache SQL data would be a good fit?

Any guidance/ best practices/examples will be helpful.

Thanks in advance,

Question by:Techsavy
    1 Comment
    LVL 28

    Accepted Solution

    InfoPath works well. It has native ODBC connectivity to SQL. If the client users have infopath and access tot he SQL DB via ODBC this is very quick and easy to setup.

    You can also use web services with InfoPath to interact with SQL if you want/need to do more setup or make the form web based in SharePoint.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
    It can often be challenging to stay relevant in the rapidly evolving world of technology. This can make recruiting talent difficult for companies of all sizes.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now