Data Connections

Re: DB2 Connection

rajkumar.bathula — Mon, 29 Oct 2012 09:01:37 GMT

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

Re: DB2 Connection

Patrick Halstead — Fri, 02 Feb 2007 03:45:28 GMT

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.

DB2 Connection

snufse — Thu, 01 Feb 2007 21:11:21 GMT

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