Skip to main content

SQL Components and Properties

Suggest edit 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.

Did you find this content helpful? YesNo

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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