Question3Replies1621Views×Close popovervoon keong lum (voonkeongl) Kelly Services Malaysia Sdn. Bhd. Kelly Services Malaysia Sdn. Bhd. MY View ProfileSend Message voonkeongl Member since 2017 12 posts Kelly Services Malaysia Sdn. Bhd. Posted: April 10, 2018Last activity: April 12, 2018Posted: 10 Apr 2018 4:16 EDTLast activity: 12 Apr 2018 1:39 EDT Closed When do I use a SQL Connector?I can't find a concrete answer to this question.Is it to execute a complex SQL statement like a stored proc, or to update a table in an external database?Coming from .NET background we use SQL connector to run SQL statements and stored proc, but in Pega is it the same? This is very confusing as the study materials do not help. Low-Code App Development ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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: 2 years agoPosted: 11 Apr 2018 2:47 EDT×Close popoverSudhakar Reddy Yaparla (SudhakarReddy) PEGA Principal Technical Solutions Engineer Pegasystems Inc. IN View ProfileSend MessageSudhakarReddy PEGA replied to voonkeonglHi, Use Connect SQL rules when your application needs to run complex Structured Query Language statements such as joins or stored procedures to update or extract information from an external database Posted: 2 years agoPosted: 12 Apr 2018 0:24 EDT×Close popovervoon keong lum (voonkeongl) Kelly Services Malaysia Sdn. Bhd. Kelly Services Malaysia Sdn. Bhd. MY View ProfileSend Messagevoonkeongl Kelly Services Malaysia Sdn. Bhd. replied to voonkeonglWhat if I can only choose one? Either 1. to execute a complex SQL statement like a stored proc 2. to update a table in an external database I know both are correct but this was asked in one of the mock exams. We are confused which is the best answer Posted: 2 years agoPosted: 12 Apr 2018 1:39 EDT×Close popoverRachit Agarwal (Rachit_Agarwal) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View ProfileSend MessageRachit_Agarwal PEGA replied to voonkeonglI think it should be 1 because to update a table from an external database in Pega, you would use Obj Methods shipped as part of the product. SQL Connect is used mainly when you want to execute a stored proc or vendor-specific syntax.