About this tutorial
WebSphere Lombardi Edition V7.2 (Author Environment) provides an Integrated Service to connect to the database management system (DBMS) that was specified during installation time – Microsoft® SQL server, DB2®, or Oracle®. This tutorial illustrates how to manipulate data in the DBMS using WebSphere Lombardi Edition (hereafter called Lombardi Edition) by using the Java Naming and Directory Interface (JNDI) in WebSphere Application Server. In this tutorial, we use DB2 Version 9.7 Fix Pack 1.
In this tutorial, you will learn how to:
- Work with the Authoring Environment in WebSphere Lombardi Edition.
- Create a Toolkit, a re-used library that can be used across numerous process applications.
- Create the following variables: input, output, private, and complex structure.
- Create an integrated service, interacting with the database by using the SQL integration.
- Use the parameter in the SQL integration.
- Debug a process application.
- Create a Human Service.
- Integrate the Human Service with the integration service.
- Create a database and table and configure access authority in DB2 for testing.
- Create a custom data source that you can use in Lombardi Edition.
- Test the custom data source.
You need to be familiar with WebSphere Lombardi Edition V7.2, WebSphere Application Server V7.0, and DB2 Version 9.7 Fix Pack 1.
You need WebSphere Lombardi Edition V7.2 running on Windows® XP or Windows 7 with access to DB2 V9.7.1.
This tutorial takes about 6 hours to complete.