Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

SQL Not a Connection Option in Data Page



In Pega 7.1.7 there is an option "SQL" in the dropdown as a type of connector for the data page. But this option is not available in Pega 7.1.9.

Error Messages

Not Applicable.

Steps to Reproduce

Not Applicable.

Root Cause

An issue in the custom application code. One should not use SQL connect for data page rules in Pega 7.


Here’s the explanation for the reported behavior:

Connect SQL has been deprecated in Pega 7.1.9, this is to encourage the use of report definitions instead of Connect SQL.

One should not be creating Connect SQL rules in the current application unless an edge case which cannot be covered by a Report Definition.
Therefore Connect SQL should not be shown as a top level data source option in the data pages as its presence can cause confusion.
Connect EJB also must be deprecated.

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration 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 Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us