Installation Guides › WebSphere Version › Separate Database Configuration › 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 on 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 for the data source descriptors are as follows:

   • Task Persistence: jdbc/idm
   • Workflow: jdbc/WPDS
   • Auditing: auditDbDataSource
   • Snapshots: jdbc/reportsnapshot
   • Object Store: jdbc/objectstore
   • Archive: 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: Ensure that the JDBC provider is created as XA.

The database schema (SQL scripts) are automatically applied when you restart CA Identity Manager or you can run the scripts to apply the changes now.