ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to add a new database schema to a new Clarity install

book

Article ID: 198947

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

We have installed a new Clarity 15.8.1, and would like to set up a MSSQL schema. How will we proceed about this

Environment

Release : 15.8.1

Component : CA PPM APPLICATION

Resolution

To set this up with a blank schema on a new install of 15.8.1, do the following:

1. On the 15.8.1 new install, go to $clarity/database/backups, it will contain the blank schema database dumps for MSSQL and Oracle

2. Ask the DBA to restore the appropriate for your vendor backups for Clarity and DWH (total of two)

3. Once the restores are done, get the connection details from the DBA and enter it in CSA:

-Clarity connection on page Database

Hit Save and ensure the connection is Available

-Data Warehouse on page Data Warehouse

Hit Save twice and ensure the connection is Available

4. Restart the services 

This should ensure that you're connecting to the new vanilla schema.