Connect SQL rules
1. We know that using Obj methods is always a good practice and using RDB methods is not a good practice? Is there any particular reason why using RDB methods is not a good practice?
2. In the below example, what happens if the data type of "Column1" and "Property1" doesn't match?
Select Column1 as ".Property1"
3. Is there any significance of Applies To class in which you write a Connect SQL?
For example, if I write a Connect SQL in class "Data-HR-KB-Employee" and my SQL uses the where clause "Data-Customer-Address-Details", what is the background algorithm PEGA uses to execute this CONNETC SQL rule?
Applies to : Data-HR-KB-Employee
where {class:Data-Customer-Address-Details}
Pegasystems Inc.
IN
Hi,
1)Obj-Methods, and RDB-Methods are used for different purposes. Obj-Methods generate their own sql , where as in RDB-Method, we write our custom queries.
RDB-Methods are used to connect to the external relational databases, using the connect SQL rules. RDB-Methods are best to avoid, when this can be solved with Obj-Methods, since RDB-methods doesn't provide greater performance.
2)Pega automatically creates a column with the appropriate datatype in the database, according the datatype of the property rule created.
We may other wise face the datatype mismatch error
3)Your class where you have written RDB method is Data-Customer-Address-Details and your Connect SQL in class "Data-HR-KB-Employee", then the query you wrote, will be executed on the dataset of the table associated to the class Data-HR-KB-Employee