Configuring JDBC data sources using JNDI

You can use WebSphere® Application Server scripting to configure JDBC providers and data sources for your reports, and to configure JNDI names for reports to use when accessing data sources. If you use this method, the data source properties for reports can access the data source using JNDI without directly specifying the JDBC information.

Before you begin

Data sources are configured in the WebSphere Application Server environment. To use scripting, you must start the WebSphere wsadmin tool. For more information, see the WebSphere Application Server documentation at http://pic.dhe.ibm.com/infocenter/wasinfo/v8r5/topic/com.ibm.websphere.nd.multiplatform.doc/ae/txml_script.html.

Any JDBC driver properties required by your database vendor must also be set as data source properties in the WebSphere Application Server configuration. For more information, see the WebSphere Application Server documentation and the documentation for your database software.

Procedure

  1. Configure a JDBC provider.
  2. Configure a JDBC data source and its JNDI name.