Hi @PoojaPalla : In Pega, Report Definitions are the preferred standard for retrieving data because they are easier to maintain and leverage Pega’s built-in optimizations. However, RDB methods (Connect-SQL) are necessary in specific scenarios like executing stored procedures. Please do also note that this is not supported in Pega Cloud.
Though you have this option to use RDB methods, the trade-offs are -
- Reduced Portability because the SQL you write will be database-specific
- High chances of introducing SQL Injection
- Issues with transaction handling because RDB methods will use auto-commit
Thanks.