Question3Replies1574Views voonkeongl Member since 2017 12 posts Kelly Services Malaysia Sdn. Bhd. Posted: April 10, 2018Last activity: April 12, 2018 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 agoSudhakarReddy 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 agovoonkeongl 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 agoRachit_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.