Implementing WebSphere Business Integration Express for Item Synchronization

182 Implementing WebSphere BI Express for Item Synchronization

Figure 9-17 Completed mapping

10.Save the map to the project and compile it. Then, you can close the Map

Designer tool.

9.5 Create the JDBC connector

Perform the following steps:

1. Switch back to the System Manager. Right-click the Connectors folder in the

ICL ItemSyncLibrary and select Create New Connector.

2. The Connector Configurator will start by presenting the New Connector

window, shown in Figure 9-18 on page 183.

3. Set the name to JDBCConnector and select the JDBC template. Click OK.

Chapter 9. Configuration for integration of back-end system 183

Figure 9-18 New connector

4. The Connector Configurator will now show the standard properties of the

connector. Change the values for AgentTraceLevel and ControllerTraceLevel.

Change the name of the MessageFileName, as shown in Figure 9-19 on

page 184. Also, change the value of LogAtInterchangeEnd to true.

184 Implementing WebSphere BI Express for Item Synchronization

Figure 9-19 Standard properties for the JDBCConnector

5. Select the tab Connector-specific properties. Complete the fields

ApplicationUserName and ApplicationPassword with the values smbadmin

and smbP4$$word respectively.

6. Fill in the field DatabaseURL with the value jdbc:db2:SUPPLIER.

7. Select the DB2 as the RDBMSVendor value from the drop-down listbox.

8. Set the attribute JDBCDriverClass to the value COM.ibm.db2.jdbc

.app.DB2Driver. See Figure 9-20 on page 185.

Chapter 9. Configuration for integration of back-end system 185

Figure 9-20 Connector-specific properties for the JDBC connector

9. Switch to the tab Supported Business Objects and add ItemBasic and

SUPPLIER_ITEM_CATALOG. Check Agent Support for the ASBO.

10.Save the connector to the project now before switching to the tab Associated

Maps. See Figure 9-21.

Figure 9-21 Supported business objects