Integration Server 10.7 | WmDB User’s Guide | Determining Whether to Use the WmDB Package or the Adapter for JDBC | When to Use the WmDB Package
 
When to Use the WmDB Package
There are cases when it is more appropriate to use the WmDB package rather than the Adapter for JDBC. Use the WmDB package when:
*You need immediate results from the execution of an SQL query. The WmDB package allows you to run quick SQL queries directly from the Integration Server Administrator or DSP pages.
*You have a need for ad hoc introspection of database objects, such as tables, views, aliases, synonyms, or stored procedures.
*You want to customize management of the database connection pool.
*You have a limited number of tasks that need to access a database.
*You are required to integrate with a proprietary or a non-mainstream database, and you want to perform a quick, easy compatibility test before exploring an implementation that uses the Adapter for JDBC. The Adapter for JDBC supports all JDBC-compliant database implementations.
*You are developing a throw-away test scenario.