Chapter 8. Integration using WebSphere Business Integration Adapters 211
8. On the Business Object Wizard Step 2-Configure Agent, enter the database
username and password, database URL, and database driver in the
configuration property values. Figure 8-5 shows example properties.
Figure 8-5 Business Object Wizard -Configure Agent
9. On the Business Object Wizard Step 3-Select Source, expand the SCHEMA
that you used to create the STOCKINFO table then expand the Tables and
select the STOCKINFO table (Figure 8-6 on page 212).
Note: Firewalls sometimes cause problems when connecting to the ODA
agent . You can disable your firewall temporarily to allow the business object
designer to find and connect to the running ODA. Sometimes on Windows
systems, the default firewall is installed and running, so check that also.
212 Managing Information Access to an EIS Using J2EE and Services Oriented Architecture
Figure 8-6 Selecting STOCKINFO table
These steps introspected the database schema and the tables in that
schema. You are now ready to retrieve the table information and to generate
the business object with its associated application specific metadata.
10.Click Next to accept the defaults.
11.On the Business Object Properties table change Add Stored Procedures to
NO, and then click OK.
12.Save the Business Object to the JDBC ICL project that was created in system
manager.
Chapter 8. Integration using WebSphere Business Integration Adapters 213
Figure 8-7 is a view of the business object created by the ODA.
Figure 8-7 View of STOCKINFO business object
Creating the JDBC connector component
Next, you create the JDBC Adapter connector component, which represents the
adapter, and you configure the adapter properties.
1. Right-click the Connectors folder in the JDBC Component folder. Click New
Connector.
2. The Connector Configurator and the New Connector dialog box opens. Select
JDBCConnectorTemplate from the list of template names.
3. Name the Connector JDBCAdapter.
4. Select WAS as the Integration Broker.
214 Managing Information Access to an EIS Using J2EE and Services Oriented Architecture
Figure 8-8 shows the new connector configuration.
Figure 8-8 New connector using JDBC connector template
5. Click OK to create the connector file.
You now configure the standard and connector specific properties. The adapter
framework and the adapter use these properties for connecting to the EIS and to
control how the adapter communicates with the integration broker or clients.
Chapter 8. Integration using WebSphere Business Integration Adapters 215
Figure 8-9 shows the connector specific properties that you need to set for the
JDBC adapter for the adapter to connect to the underlying database.
Figure 8-9 JDBC adapter connector configuration
For more information about connector properties and their default behavior, see
the JDBC adapter guide at:
http://www.ibm.com/software/integration/adapters
To configure the standard and connector specific properties:
1. On the Standard Properties tab, enter the following:
– For BrokerType, choose WAS from the drop-down list.
– jms.MessageBrokerName, which is your WebSphere MQ queue manager.
If your queue manager is remote, then you need a URL in the form
queuemanager:channel:server:listenerport.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset