BDC as a Dataconnection for InfoPath Development

16 Jun

One of my customer wanted to create a BDC application definition file for Oracle 11g database Entity. Also, they wanted to use an InfoPath to leverage or pre-populate the dropdown list from Oracle database entity. Due to the budget cut, they are not willing to spend money/hours to create a seperate webservice wrapper for an oracle entity to pre-populate the dropdowns(in InfoPath) and they would like to use BDC application definition file as a datasource for an InfoPath(sounds crazy  here? [:)] ). They had raised a valid question to me that “Why don’t to use BDC as a Data Connection for Infopath? – BDC application definition file has connection string and method instance, blah, blah… so why we can not re-use this application definition file as a datasource for InfoPath Developement?”- Pretty good question, isit? [;)] – Conceptual Design diagram attaced. 

Conceptual Design

But unfortunately, InfoPath data connection wizard doesn’t support BDC application definition file as a Datas ource and it does supports the following options.

InfoPath Options

We can not use BDC application definition file as an XML form or anyother options. So, I suggested to them to create a simple webmethod(i.e, 4 hours effort) to pre-populate the lookup values from LOB Instances, and make use of this webservice as a datasource in infopath form. So that you can re-use the same application definition file for both BDC application & InfoPath form.


They were really happy to use this technology to satisfy their technical issue as well as save cost [:)] – Using this approach we can able to use Business Data Catalog as a DataConnection for an InfoPath development.

Hope this helps!

Leave a comment

Posted by on June 16, 2009 in Uncategorized



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: