Best practices on schema location for Clarity, DWH and Jaspersoft

book

Article ID: 145838

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Currently Clarity (niku) and ppm_jaspersoft schemas are in one database server and the DWH (ppm_dwh) in another DB. Is this better for performance? 

Why should not all be moved into one database server?

Environment

Release : All Supported Clarity releases with Data Warehouse

Resolution

  • You may or may not use the same database server for Clarity, Data Warehouse and Jaspersoft
  • The only reason not to would be to add yourself some CPU/database bandwidth
  • Keeping DWH separate can alleviate the load on the transaction database by directing the reports to be ran on a separate schema/database/tablespace etc. provided you have a significant report usage
  • If your server is big enough and you have an efficient maintenance schedule you should be not having any problems with keeping them all on the same database