Accessing Adabas through Microsoft InfoPath

This tutorial demonstrates how to invoke operations on an Adabas DataSource exposed as a "Web service" through Portus from Microsoft InfoPath.

1. From the InfoPath main menu bar, select File -> Design a Form.

   

2. A panel will appear on your right hand side - choose New from Data Connection

   This will start a dialog, first select Web Service, click Next

   

   Select Receive and submit data, click Next

   

   Enter the URL, the WSDL for the "Employees" demo file is exposed as:

   http://soagate:8885/adabas_Employees?WSDL

   Click Next

   

   Select the list method, click Next

   

   Assign a name to the response document, click Next

   

   Enter the same URL again, click Next

   

   Choose list and click Next

   

   Select "Entire form (XML document....", click Next

   

   Assign a name to the Send Connection, click Finish

   

3. You will now be presented with a form

   

   Do the following:

   • Enter a title "List Employees" for example
   • Expand the queryFields, drag them to the area "Drag query fields here"
   • Expand the dataFields, right-click on the adabasEmployee element. Now drag the adabasEmployee to the area "Drag data fields here", insert it as a Repeating table

     At this point, it might make sense to resize the table and the fields in the "repeating table"

     

   • Once you are happy with how your form looks like, select File -> Preview form -> Default

     

   • You will be presented with a form, enter 4000004* in the Personnel Id field and send the request to the server

     

   • Your table will now be populated with the data based on your request: