Installation Guides › WebSphere Version › Database Creation › How to Create a Database Instance
How to Create a Database Instance
CA Identity Manager requires a relational database to store objects and data for auditing, snapshots (reporting), workflow, and task persistence. When installing CA Identity Manager, all of the database schemas are created automatically when the application server is started.
Also, for scalability purposes, you may want to create a separate database to replace any one of the existing database schemas initially created by CA Identity Manager during installation.
You can create a new database instance for the following:
- Workflow
- Auditing
- Task Persistence
- Object Store
- Snapshots (reporting)
- Archive (task persistence archive)
Perform the following steps to create a new database.
- Create a new MS SQL Server or Oracle database instance for CA Identity Manager.
- Edit the data source.
- (Optional) Run the SQL scripts.
Important! The Windows default locations for CA Identity Manager database schema files are the following:
- Workflow: run the CreateDatabase script
- Auditing: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db
- Task Persistence: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db
- Object Store: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db
- Snapshots (reporting): C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\imrexport\tools\db
- Archive (task persistence archive): C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db
