(March 2016: Lab updated for IIB10003) In this lab, you create an integration service and all the IBM integration resources required to implement the service. You will define the service data model and the WSDL that describes the service. You will implement and test the service operation. The service accesses an external database and responds with data retrieved from the database.
- Lab instructions
- Lab file (118 KB). Download this Lab file, and then extract to C:\ to create or update the folder C:\student10.
- Creating schemas from a database
- Placing the schemas in a Shared Library
- Using the schemas in an Integration Service
- Placing a Mapping Node in a Shared Library
- Using the Mapping Node to read a database
- Introduction to the Flow Exerciser
You will need to configure IBM Integration Bus to work with an external database system, in this lab, DB2.
The lab makes use of the DB2 HRDB database, which contains two tables, EMPLOYEE and DEPARTMENT. These tables have been populated with data required for this lab. (The DDL for the HRDB is available in the student10 folder; we intend to provide corresponding DDL for Microsoft SQL/Server and Oracle over time). This is a change from earlier versions of this lab, which made use of the EMPLOYEE table of the DB2 SAMPLE database.
Related tutorial in the IIB V10 Integration Toolkit:
- Integration services (SOAP/HTTP inputs)
- Learn about integration services that use SOAP/HTTP inputs in IBM Integration Bus by exploring this simple example.