Question
5
Replies
219
Views
PEGA
Posted: March 13, 2017
Last activity: March 14, 2017
Closed
Benefits of using Report Definition against writing Connect SQL
What are the benefits of using Report Definition against writing Connect SQL
Posted: 3 years ago
What are the benefits from an architectural point of view and from performance point of view
Posted: 3 years ago
Hi Nishant,
Please find the requested benefits as follows:
- A Report Definition is better because it will work on any database platform, in any environment.
- We strongly encourage the use of the Report Definitions over Connect-SQL unless it's just not possible.
- Not sure if there is a big performance difference either way.
Hope this information might be helpful to you.
Regards
Mahesh
Posted: 3 years ago
Additionally:
1. Report Definitions can be used as inputs for Data Pages
2. Report Definitions can be created and maintained by end-users; rather than Administrators.
Posted: 3 years ago
What are the benefits from an architectural point of view and from performance point of view
Hi Nishant,
This is the main benefit of RD over Connect-SQL functionality. Hope this might be helpful to you.
Regards
Mahesh