Installation Guide › WebSphere Version › Separate Database Configuration › How to Create Separate Databases › Edit the Data Source

Edit the Data Source

Important!When using WebSphere with Microsoft SQL Server, enable XA transactions. CA Identity Manager needs an XA data source for the database transactions to work properly. For more information about enabling XA transactions on Microsoft SQL Server, go to http://msdn.microsoft.com/en-us/library/aa342335.aspx. Be sure to use JDBC driver version 1.2 compatible DLL files when enabling XA transactions.

To edit the data source

1. Within the WebSphere Administrative Console, open the appropriate data source descriptor.

   The JNDI names in the data source descriptor are as follows:

   • Task Persistence: iam/im/jdbc/jdbc/idm
   • Workflow: iam/im/jdbc/jdbc/WPDS 
   • Auditing: iam/im/jdbc/auditDbDataSource
   • Snapshots: iam/im/jdbc/jdbc/reportsnapshot
   • Object Store: iam/im/jdbc/jdbc/objectstore
   • Archive: iam/im/jdbc/jdbc/archive  
2. Change the DatabaseName, User, and Password in the data source descriptor to the appropriate values for the new database.

   The database schema (SQL scripts) are automatically applied when you restart CA Identity Manager.

3. Depending on your database, add the following to Custom Properties:
   • SQL: user=<username>, password=<password>, enable2Phase=true, selectMethod=cursor
   • Oracle: user=<username>, password=<password>

     Note: Be sure that the JDBC provider is created as XA.