Support Article
What do all the "Select SQL Operations" mean in SQL connector?
SA-3654
Summary
From the course "DSM: Decisioning Simulations for System Architects (v7.1)" in Pega Academy, and following the instructions the first step is create a new SQL conector:
Designer Studio > Integration > Connectors > Create Other Integration > New Connector Data Source.
From there, user selects SQL connector, and in next steps (a and b) I select the Database Name, Schema, Table and the table columns, but in step "c" user don't know which option/s to check.
Option "c" is "Select SQL Operations". User doesn't know what consequence could have select each option.
Resolution
Browse the database
this creates a Obj-Browse method - to search instances of one class and copy the entire instances, or specified properties, to the clipboard as an array of embedded pages. more information https://pdn.pega.com/sites/default/files/help_v71/procomhelpmain.htm#methods/obj-browse/obj-browse.htm
Open a single record
this creates Obj-Open method - to open an instance stored in the PegaRULES database or in an external database linked to an external class, and save it as a clipboard page. more information https://pdn.pega.com/sites/default/files/help_v71/procomhelpmain.htm#methods/obj-open/obj-open.htm
Update and save records
this creates Obj-Save method - uses properties on the page to derive the internal key under which it will be saved. This method can create a new database instance or overwrite a previous instance with that key. more information
https://pdn.pega.com/sites/default/files/help_v71/procomhelpmain.htm#methods/obj-save/obj-save.htm
Delete records
this creates a Obj-Delete method - delete a database instance corresponding to a clipboard page. more information can be found at https://pdn.pega.com/sites/default/files/help_v71/procomhelpmain.htm#methods/obj-delete/obj-delete.htm
More generic information can be found at
https://pdn.pega.com/sites/default/files/help_v71/procomhelpmain.htm#tools/integrationaccelerator/aboutgenerateconnectrules.htm
Published February 18, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.