Accessing Adabas through Microsoft InfoPath

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

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

    graphics/msip01.jpg

  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

    graphics/msip02.jpg

    Select Receive and submit data, click Next

    graphics/msip03.jpg

    Enter the URL the WSDL for the "Employees" demo file is exposed as: http://soagate:8885/adabas_Employees?WSDL

    Click Next

    graphics/msip04.jpg

    Select the list method, click Next

    graphics/msip05.jpg

    Assign a name to the response document, click Next

    graphics/msip06.jpg

    Enter the same URL again, click Next

    graphics/msip07.jpg

    Choose list and click Next

    graphics/msip08.jpg

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

    graphics/msip09.jpg

    Assign a name to the Send Connection, click Finish

    graphics/msip10.jpg

  3. You will now be presented with a form

    graphics/msip11.jpg

    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"

    graphics/msip12.jpg

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

    graphics/msip13.jpg

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

    graphics/msip14.jpg

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

    graphics/msip15.jpg