Details regarding deprecation of UDFs

General
, , , ,
1

As stated in the last CAD (“Third Party Vendor Platform – Quarterly Communication”)

Changes in Pega Platform ‘25 supported platforms

User Defined Functions (UDFs) for Reporting and Connect SQL capabilities willno longer be supported in Staging (Production Level – 4) andProduction (Production Level – 5) environments. However, application developers can continue leveraging them in Development (Production Level – 2) and Quality Assurance (Product Level – 3) environments to expedite development processes.

Since this was only targeted at the Reporting and Connect SQL capabilities in higher environments, does that mean, that the pr_read_from_stream functions will still be available in the DB in all Production Levels (via the Query Runner in Pega Cloud and also for custom SELECTs which target the DB directly in an on Prem environment)?

Currently we are using the pr_read_from_stream in the following scenarios (also in PROD):

  • Reports that are running directly against the Pega DB
  • Quickly get all needed information for an object in the context of debugging

Would this support be deprecated and removed as well in the future? What would be alternative approaches?

Regards

Florian

2

@redds19 would you be able to provide some input on this question?

This is similar to the questions raised in Details on upcoming Opensearch support for SRS

cc @GabeEdwards

3

@MarijeSchillern

Yes, pr_read_from_stream functions will still be available in production environments and can continue using them for the diagnostic purposes through the Query Runner utility or database direct SELECT queries. Currently, Pega has no plans to remove them in future.

Thank you.