Create an electronic form solution with DB2 pureXML and Lotus Forms

Electronic forms are an attractive way to automate paper-based processes and reduce material and personnel costs. This demo shows how to create an XML-based electronic form solution in three steps using Lotus Forms to capture and send the data, and DB2 pureXML to receive and store the data. The two are linked by a simple Web service that takes only minutes to create with Data Studio. This demo shows how to create the DB2 database and table to store the XML, how to create the Web service, and how to create the simple data capture and transmission form. It then shows you the running application, including how to query the data stored in DB2 pureXML and a Cognos report built from the data.

Bryan Patterson (bryanp@us.ibm.com), DB2 Data Server Solution Architect, IBM

Author Photo: Bryan PattersonBryan Patterson is a senior solutions architect at IBM's Silicon Valley Laboratory who specializes in database management. He has more than 20 years of software industry experience including management positions in development, quality assurance, and product planning. His email address is bryanp@us.ibm.com.



Zhang Terry Dexiong (dtzhang@us.ibm.com), Software Engineer (Co-op), IBM

Dexiong Terry Zhang photoDexiong Terry Zhang is a software engineer co-op at IBM's Silicon Valley Lab. He graduated from San Jose State University in Computer Science. He joined the DB2 pureXML Enablement team in 2008 and is working on solution integration of pureXML in various projects.



03 June 2009

Electronic forms are an attractive way to automate paper-based processes and reduce material and personnel costs. This demo shows how to create an XML-based electronic form solution in three steps using Lotus® Forms to capture and send the data, and DB2® pureXML® to receive and store the data. The two are linked by a simple Web service that takes only minutes to create with Data Studio. This demo shows how to create the DB2 database and table to store the XML, how to create the Web service, and how to create the simple data capture and transmission form. It then shows you the running application, including how to query the data stored in DB2 pureXML and a Cognos® report built from the data.

System requirements

You'll need JavaScript™ enabled in your browser.

Duration

8 minutes

Download

DescriptionNameSize
TranscriptCreate_eForm_Solution_script.pdf25KB

Resources

Learn

Discuss

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=394119
SummaryTitle=Create an electronic form solution with DB2 pureXML and Lotus Forms
publish-date=06032009