https://community.blueprism.com/t5/Product-Forum/Use-of-DB-for-Reporting/m-p/71198#M23803 Thank you Tushar for sharing the tips.<BR /><BR />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.<BR /><BR />------------------------------<BR />Bruce Liu<BR />Senior Product Consultant, Professional Services<BR />Blue Prism<BR />Australia/Sydney<BR />------------------------------<BR /> Wed, 07 Apr 2021 01:20:00 GMT bruce.liu 2021-04-07T01:20:00Z https://community.blueprism.com/t5/Product-Forum/Use-of-DB-for-Reporting/m-p/71197#M23802 <EM><A data-tag-text="BPTechTips" data-sign="#" class="user-content-hashtag" href="https://community.blueprism.com/search?s=tags%3A%22BPTechTips%22&amp;executesearch=true" data-tag-key="96c6fa99-5a9a-4919-98a6-d9ce55afe99f">#BPTechTips</A>&nbsp; &nbsp;**TIP**&nbsp;<BR /><BR />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.<BR /><BR />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.&nbsp;</EM><BR /><BR />------------------------------<BR />Tushar Varshney<BR />Senior Consultant - Intelligent Automation<BR />Ernst &amp; Young India<BR />+91-9880188366<BR />------------------------------<BR /> Tue, 30 Mar 2021 11:07:00 GMT https://community.blueprism.com/t5/Product-Forum/Use-of-DB-for-Reporting/m-p/71197#M23802 TusharVarshney 2021-03-30T11:07:00Z https://community.blueprism.com/t5/Product-Forum/Use-of-DB-for-Reporting/m-p/71198#M23803 Thank you Tushar for sharing the tips.<BR /><BR />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.<BR /><BR />------------------------------<BR />Bruce Liu<BR />Senior Product Consultant, Professional Services<BR />Blue Prism<BR />Australia/Sydney<BR />------------------------------<BR /> Wed, 07 Apr 2021 01:20:00 GMT https://community.blueprism.com/t5/Product-Forum/Use-of-DB-for-Reporting/m-p/71198#M23803 bruce.liu 2021-04-07T01:20:00Z