Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

SQL Components and Properties

Updated on November 10, 2021

Use SQL components and their properties to issue ODBC, OLE, Oracle, and SQL queries and commands in your automations.

SQL components are found under the External data sources tab of the Toolbox.

SQL Components

Properties are defined in the Property Grid, to the right of the Automation Surface. Methods are defined directly in the Connection Block on the Automation Surface.

Properties and methods
  • ODBCQuery

    Use the ODBCQuery when connecting to an ODBC provider. ODBC (Open Database Connectivity) is a standard software API designed to connect to database management systems. It is designed to be independent of any specific language or operating system.

  • OleDbQuery

    Use the OleDbQuery when connecting to an OLE database provider (such as Access).

  • OracleQuery

    Use the OracleQuery when the data source you want to use in your automation resides in an Oracle database.

  • SqlCommand

    Use SQLCommand when the data source resides in a Microsoft SQL Server database and you want to perform update, insert, or delete commands on the database.

  • SQLQuery

    Use the SQLQuery when the data source resides in a MS SQL Server database.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us