Planning for adapter implementation

Before using IBM® WebSphere® Adapter for JDBC, make sure that you understand the experience you need and the server environment in which it runs. Learn the considerations for deploying the adapter in your server environment, and find out how to improve the performance and availability of the adapter by using a clustered server environment.

Before you begin
Before you begin to configure and deploy the module, you must possess a thorough understanding of the business integration concepts, Java™ Database Connectivity (JDBC), the database products in your environment, and the features and capabilities of IBM Integration Designer and IBM Business Process Manager or WebSphere Enterprise Service Bus.
Security
The adapter uses the J2C authentication data entry, or the authentication alias feature of Java EE security to provide secure user name and password authentication. For more information about security features, see the documentation for IBM Business Process Manager or WebSphere Enterprise Service Bus.
Support for protecting sensitive user data in log and trace files
You can configure the adapter to prevent sensitive or confidential data, in the log and trace files, from being viewed by users without authorization.
User authentication
The adapter supports several methods for supplying the user name and password that are needed to connect to the database. By understanding the features and limitations of each method, you can pick a method that provides the appropriate level of security and convenience for your application.
Deployment options
There are two ways to deploy the adapter. You can either embed it as part of the deployed application, or you can deploy it as a stand-alone RAR file. The requirements of your environment affect the type of deployment option you choose.
WebSphere Adapters in clustered environments
You can improve adapter performance and availability by deploying a module on a clustered server environment. Clusters are groups of servers that are managed together to balance workloads and to provide high availability and scalability.
Support for prepared statement caching
IBM WebSphere Adapter for JDBC supports prepared statement caching by the server, which can reduce the time required to perform an outbound or inbound operation or a batch of operations.
Enabling IBM WebSphere Adapter for JDBC to connect to a new schema at run time
You can dynamically connect to a new schema when moving from one environment to another, by enabling IBM WebSphere Adapter for JDBC to pick up the database schema name for tables, views, and synonyms at run time.
Migrating to version 7.5.0.3 of WebSphere Adapter for JDBC
By migrating to version 7.5.0.3 of WebSphere Adapter for JDBC, you automatically upgrade from the previous version of the adapter. Additionally, you can migrate your applications that embed an earlier version of the adapter, so that the applications can use features and capabilities present in version 7.5.0.3.
Migrating WebSphere Business Integration applications
You need to migrate the WebSphere Business Integration applications so that they become compatible with Version 7.5.0.3 of your adapter.