InfoPath Dev

My company just installed InfoPath 2007. My initial question is as follows: As we start development of forms there will be a need to connect to the back end system which is db2 based (AS/400). We will need to validate entries (example employee code), retrieve employee name, customer name etc and also evetually update the back end system. What is the best approach?
1 Use web services? if so can we use multiple services in the same form (example one service that GetEmployee, GetCustomer etc etc)
2.Write managed code in VB for the different events?
Thanks

Hi Rolf and welcome to our forum!
Someone asked me the same question during a presentation today at a conference in Orlando. Unfortunately, I don't know much about DB2 but there must be a way to get the data out of it. Certainly Web services would be one way. Multiple Web services are supported from the same form. Most of our forms call 10-20 methods each. If you write a Web service (or leverage ours) it's better since you don't have to duplicate code across multiple projects and that means lower maintenance. I recommend against writing code in the InfoPath client. If DB2 is ODBC compliant, you may be able to use our Web service to do this. I need to check. Send me e-mail if you are interested in pursuing this.

 Hi Patrick.

I too have a requirement of populating data on infopath 2010 Form from db2 database. could you please provide more information or articles which i can refer? 

 

thank you before hand.

raj