Adding external software dependencies

The external service wizard needs a copy of certain files from the database server to be able to communicate with it. Use the external service wizard to specify the location of the JAR files that contains the JDBC driver and any native system library files that are needed.

1. Obtain the JDBC driver-specific files or native libraries for your database software and operating system from your database administrator or from the database software website. The files that you need vary by database server. Ensure that the JDBC driver-specific files are compatible with JRE 1.6. The following table lists the JDBC driver files needed for common database software.

   Table 1. JDBC driver files for common database software

   Database software	Driver	JDBC driver files	Native System Libraries
   IBM DB2 Universal Database™ for Linux, UNIX, and Windows	IBM DB2® Universal (Type 4)	db2jcc.jar db2jcc_license_cu.jar	None
   IBM DB2 for z/OS	IBM DB2 Universal (Type 4)	db2jcc.jar db2jcc_license_cisuz.jar	None
   IBM DB2 for IBM i	IBM Toolbox for Java™ remote driver (Type 4)	jt400.jar db2jcc_license_cisuz.jar	None
   	IBM Toolkit for Java native driver* (Type 2)	db2_classes.jar	None
   IBM DB2 Universal Database for Linux, UNIX, and Windows	IBM DB2 Universal (Type 2)	db2java.zip	None
   Oracle	Thin driver	ojdbc6.jar In addition, the following additional libraries are required to handle the XML data type in the runtime environment: xdb.jar xmlparserv2.jar	None
   Microsoft SQL Server 2005	Microsoft SQL Server 2005 for JDBC	sqljdbc.jar	None
   Informix®	IBM Informix JDBC Driver	ifxjdbc.jar ifxjdbcx.jar plus several support .jar files For more information see, IBM Informix JDBC Driver Programmer's Guide	None
   * You can use the IBM Toolkit for Java native driver to connect to the database at adapter run time, but you cannot use it to connect while running the wizard. You must use either the IBM Toolbox for Java remote driver or the IBM DB2 Universal driver during the discovery process. However, you can configure the module to use the native driver at run time. Do this on the Specify the Service Generation and Deployment Properties window.

2. In the Locate the Required Files and Libraries window, specify the location of the JDBC driver-specific files that are required by the project.
   1. In the JDBC driver JAR files field, click Add and select the JDBC driver files. For more information about JDBC drivers for see, Frequently asked questions about JDBC drivers.
   2. If you use a JDBC type 2 driver, click Add in System libraries field to add the native system libraries that are required to access the database server. If you use only JDBC type 4 drivers, leave this field empty.
      
3. Click Next. The wizard displays the Select the Processing Direction window.