Connecting Infopath to both SQL and AD. - InfoPath Dev
in

InfoPath Dev

Connecting Infopath to both SQL and AD.

Last post 07-18-2011 05:25 AM by user007. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 07-15-2011 11:15 AM

    Connecting Infopath to both SQL and AD.

    Hi, 

    I am new to InfoPath. Trying to create a form. Need the form to connect both to SQL and AD. Based on the username entered, should put some info + Employee Number form SQL. After that based on the Employee Number populate rest of the fields form AD. How do I do this?

    Thanks,

  • 07-15-2011 12:22 PM In reply to

    Re: Connecting Infopath to both SQL and AD.

    Hi 007 and welcome!

    InfoPath out-of-box gives you the username of the person logged into the machine. If all users are logged in to domain accounts, that may be sufficient, but in order to get more info from Active Directory, you will need to a) write some code, or b) use a product like Qdabra's Active Directory Web Service which lets you pull AD info (like first/last name, emp#, groups, etc.). SharePoint's UserProfileService also includes first/lastname but doesn't give you all of the AD properties.

    InfoPath out-of-box lets you link your forms to SQL but we don't recommend using that because a) you can't convert forms to be browser later, and b) it creates a tight coupling with your SQL tables which means that changes down the road (inevitable) will create lots of migration headaches. We recommend creating a web service or using a third party Web Service like Qdabra's DBXL which lets you map all of your XSNs without having to create a separate web service for each. Bonus: it also includes ADWS and is way cheaper than if you had to have someone create a web service from scratch.

    We're here to help you do what you want, so if you don't have the ability to use a third party tool, please search the forum. Many people have posted code snippets for how to query AD/SQL. With a Web service in place, you will have a very powerful data entry solution.

    Best of luck,

    Patrick Halstead
    Project Manager at Qdabra
  • 07-15-2011 01:05 PM In reply to

    Re: Connecting Infopath to both SQL and AD.

    Is there any other option besides InfoPath to do forms and workflows with SharePoint?

  • 07-15-2011 02:07 PM In reply to

    Re: Connecting Infopath to both SQL and AD.

    I forgot one more option: you can use InfoPath and BCS to get data in and out of SQL. If they are simple tables, should work easily enough. SharePoint List forms work great for that. For more complex forms, you'll want InfoPath XML-based forms.

    Patrick Halstead
    Project Manager at Qdabra
  • 07-18-2011 05:25 AM In reply to

    Re: Connecting Infopath to both SQL and AD.

    Thanks for your help Patrick. I am assuming that WCF would work too, right?
    I am using SharePoint and InfoPath 2007. Could I use Visual Studio 2008? Or should it be 2005?

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.