can we use obj metods for external relational database?
i heard few things about obj methods and rdb methods
1 obj ,methods for pega rules database and rdb methods for external relational database if we use rdb methods for pegarules database we lost the data.because pega rules database is distinct rules and data and while we r using rdb methods the apllication performance also decrease.
2 obj methods retrieve data from BLOB column and ave data into the BLOB.but RDB methods cannot read and save the data to the table,if we have a BLOB column in table.
please clarify these doubts about obj methods and rdb methods and why we use obj methods for pega database and rdb for external relatonal database.
***Updated by moderator: Lochan to add Categories***
Share this page
Moderation Team has archived post,
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 5 Jan 2017 23:41 EST
Gisela Rodrigues (rodrg)
Senior Principal Engineer, Technical Support
Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances. Unless there is a need for custom SQL which cannot be solved by Obj- operations, RDB- operations are best avoided. That said, in situations where you need to insert using a select statement or delete multiple records based on a filter criteria, equivalent Obj- operations are currently not available and thus RDB- operations are useful.
Generally all queries should be through the use of Obj methods. If you use RDB methods, you will not be able to access BLOBs. However, RDB methods are necessary if you want to execute stored procedures.
RDB methods would be considered in the below factors
1) stored procedure
2) custom or complex query
3) SQL function
Hope this helps!
Posted: 5 years ago
Posted: 6 Jan 2017 4:28 EST
Prashant Shukla (PRASHANTS-1)
Managing Application Consultant