Use of DB for Reporting

[TusharVarshney]

#BPTechTips   **TIP** 

BP Database can be used to create various type of reports either by connecting using Connection String. SQL views can be used with DB tables to provide any information required.

Replica of DB is recommended in order to avoid load on Prod DB directly and a sync can be scheduled once or twice in a day to get the data from Prod DB. 

------------------------------
Tushar Varshney
Senior Consultant - Intelligent Automation
Ernst & Young India
+91-9880188366
------------------------------

[bruce.liu]

Thank you Tushar for sharing the tips.

Indeed as you said, Blue Prism database is an operational database. To ensure its maximum efficiency, it is best to avoid performing extensive reporting on it on a constant basis. Reporting workloads can either be shifted towards off-peak time or performed on a replica of Blue Prism database. The replica may be a mirrored Blue Prism database. In a SQL Server Availability Group context, it can be run on a read only replica.

------------------------------
Bruce Liu
Senior Product Consultant, Professional Services
Blue Prism
Australia/Sydney
------------------------------