Installation Guides › WebSphere Version › Database Creation › 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.
2. Change the JndiName in the data source descriptor according to the following:
   • Task Persistence: jdbc/idm
   • Workflow: jdbc/WPDS
   • Auditing: auditDbDataSource
   • Snapshots: jdbc/reportsnapshot
   • Object Store: jdbc/objectstore
   • Archive: jdbc/archive
3. 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.

4. 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.