Obj and RDB

General
, ,
1

Hi,

What is the difference between obj and RDB ?

Regards,

YerniKumar

2

@YERNIKUMARD

In terms of funcationality both Obj operations and RDB can achive the requirement almost.But performance wise, it’s not recommended to use RDB methosd unless we are using external Database to connect and/or we are writing complex data base queries which are not possible with Obj methods.

Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances.

Obj methods are meant for transactional ease as they have the option of deferred save, rollback etc whereas RDB methods are performed immediately with auto-commit

3

HI @YERNIKUMARD,

Please find difference between Obj and RDB methods below :

Feature OBJ Methods RDB Methods
Supported Table Internal and external tables External tables only
SQL Generation Automatic Explicit
Transaction Management Supported (deferred save, rollback) Not supported (auto-commit)
Complex Queries Limited to simple SQL Supports complex SQL
Stored Procedures Not possible Possible
DBMS Functions Not possible Possible

Note : It is recommended to use RDB on external table only but you can use them on internal table if your query contains complex DB CLAUSE.

Hope it Helps.

Thanks, Ankit

4

Hi @YERNIKUMARD,

Please refer the below link:

Difference between Obj methods and RDB methods ? | Support Center.

Regards,

Akshitha V

5

@YERNIKUMARD

RDB methods work only on flat tables and cannot fetch data from inside BLOB column whereas obj methods cab decrypt and fetch from inside BLOB

6

Hi @YERNIKUMARD,

Here you can go through, This Pega Discussion written by @KenshoTsuchihashi nice article.

When we should use RDB methods over Obj methods | Support Center

I hope this will help you

Thanks,

Ashok