Best practices on schema location for Clarity, DWH and Jaspersoft

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