In which of the following situations would you use a SQL connector?
In which of the following situations would you use a SQL connector?
You would use a SQL connector to execute a complex SQL statement such as a stored procedure. SQL connectors are specifically designed to handle complex queries and interactions like joins or stored procedures with an external database, which are beyond simple data retrieval or updates.
D. 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. As an alternative, if your application needs to perform a simple browse, open, delete, or update operation against an external database, use the Connector and Metadata Accelerator to configure external table access. When external table access is configured for an external table, you can use the Obj-Open, Obj-Browse, and other Obj- methods to interact with that table through a class that represents it and you do not need to create SQL connector rules. https://community.pega.com/sites/default/files/help_v718/rule-/rule-connect-/rule-connect-sql/main.htm