Skip to main content
Contact a Moderator

Question

6
Replies
1443
Views
 olivier K (olivierK7667) Personal and Business Computers
Personal and Business Computers
FR
olivierK7667 Member since 2017 2 posts
Personal and Business Computers
Posted: January 8, 2018
Last activity: February 6, 2018
Posted: 8 Jan 2018 6:40 EST
Last activity: 6 Feb 2018 11:26 EST
Closed
Solved

UDF and SQLJ SCHEMA inevitably for pega Install ?

Hi,

What is User Defined Functions (UDF) ? What is SQLJ Schema ? We must inevitably install these for the Pega platform Database ?

Can we use Azure PostgreSql Database for Pega install ( without blocked by installing PL:Java for java user-defined fonctions : UDF and execute also install.sql requete to create SQLJ schema ?

I asked these questions because , I want to use Azure PostgreSql Database servers . This permit me to avoid to install virtual servers on azure cloud , and install after community postgresql database server . which saves me time and does not take care of managing database servers .

- On Pega 7.3.1 Install Tomcat PostGreSql guide , it's written :

" Installing PL/Java for Java user-defined functions :

The Pega Platform requires Java user-defined functions (UDFs). To work with PostgreSQL, UDFs
require the PL/Java add-on for PostgreSQL and a new dedicated schema. The new schema, called
SQLJ, is defined for the Pega Platform database.
For PostgreSQL 9.3 and later, the PL/Java module is included in the Pega Platform resource kit.
Before you install the Pega Platform, install the version of PL/JAVA included in your resource kit. If
you do not install and configure PL/Java before you attempt to install the Pega Platform, the Pega
Platform installation fails. Follow the instructions for your platform."

- On this link Deploying Pega Platform on Microsoft Azure:

Show More

Hi,

What is User Defined Functions (UDF) ? What is SQLJ Schema ? We must inevitably install these for the Pega platform Database ?

Can we use Azure PostgreSql Database for Pega install ( without blocked by installing PL:Java for java user-defined fonctions : UDF and execute also install.sql requete to create SQLJ schema ?

I asked these questions because , I want to use Azure PostgreSql Database servers . This permit me to avoid to install virtual servers on azure cloud , and install after community postgresql database server . which saves me time and does not take care of managing database servers .

- On Pega 7.3.1 Install Tomcat PostGreSql guide , it's written :

" Installing PL/Java for Java user-defined functions :

The Pega Platform requires Java user-defined functions (UDFs). To work with PostgreSQL, UDFs
require the PL/Java add-on for PostgreSQL and a new dedicated schema. The new schema, called
SQLJ, is defined for the Pega Platform database.
For PostgreSQL 9.3 and later, the PL/Java module is included in the Pega Platform resource kit.
Before you install the Pega Platform, install the version of PL/JAVA included in your resource kit. If
you do not install and configure PL/Java before you attempt to install the Pega Platform, the Pega
Platform installation fails. Follow the instructions for your platform."

- On this link Deploying Pega Platform on Microsoft Azure:

https://docs.pega.com/client-managed-cloud-deployments-prior-pega-platform-82/deploying-pega-platform-ms-azure , it's mentionned :

" Note : The Azure SQL Database service does not allow installation of user-defined functions (UDFs). Therefore, before you install Pega Platform, set bypass.udf.generation=true in the setupDatabase.properties file. For more information, see your Pega Platform Installation Guide. "

- On this link also Deploying Pega Platform on Amazon Web Services : https://docs.pega.com/client-managed-cloud-deployments-prior-pega-platform-82/deploying-pega-platform-aws :

" The Amazon RDS service does not allow installation of user-defined functions (UDFs). Therefore, before you install Pega Platform, set bypass.udf.generation=true in the setupDatabase.properties file. For more information, see your Pega Platform Installation Guide. "

Thank you for yor help

***Edited by Moderator Marissa to update categories***


Show Less
System Administration Installation and Deployment Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 8 Jan 2018 15:52 EST
Mohammad Asif Hasan (Asif Hasan) PEGA Senior Technical Solutions Engineer
Pegasystems Inc.
IN
I too have faced this question and problem during installation with postgres database. It's tedious and time taking. But to answer your questions, as per my knowledge and experience you have to install. These are necessite for execution of complex Pega's OOTB procedures and functions. Though, i dont have exact knowledge about Azure product and it's restriction. I could only say, if it's mentioned in the user guide then you have to follow the step by step process. Let us know, if you could tweak something and able to install and build. And execute application smoothly.
Posted: 4 years ago
Posted: 8 Jan 2018 16:35 EST
olivier K (olivierK7667) Personal and Business Computers
Personal and Business Computers
FR

 

Thank you for your response , please can you give me an example of complex Pega's OOTB procedures and functions tha you know ?

- ------------------------------------------------------

About Azure Cloud Pega deployment : https://docs.pega.com/client-managed-cloud-deployments-prior-pega-platform-82/deploying-pega-platform-ms-azure

Show More

 

Thank you for your response , please can you give me an example of complex Pega's OOTB procedures and functions tha you know ?

- ------------------------------------------------------

About Azure Cloud Pega deployment : https://docs.pega.com/client-managed-cloud-deployments-prior-pega-platform-82/deploying-pega-platform-ms-azure

" Note :The Azure SQL Database service does not allow installation of user-defined functions (UDFs). Therefore, before you install Pega Platform, set bypass.udf.generation=true in the setupDatabase.properties file. For more information, see your Pega Platform Installation Guide."

 

- --------------------------------------------------

About Amazon Cloud AWS Pega deployment : https://docs.pega.com/client-managed-cloud-deployments-prior-pega-platform-82/deploying-pega-platform-aws

"Note : The Amazon RDS service does not allow installation of user-defined functions (UDFs). Therefore, before you install Pega Platform, set bypass.udf.generation=true in the setupDatabase.properties file. For more information, see your Pega Platform Installation Guide."

 

------------------- 

I am not developper and rather someone of the infrastructure, I ask the question to known if it is the obligation to have this functionality installed and activated for Pega Platform.

If these functionalities (UDF) are not important , then I choose Azure Cloud PostgreSqlDatabase servers and set bypass.udf.generation = true in the setupDatabase.properties file to avoid the installation and management of database servers after

 

 


Show Less
Posted: 4 years ago
Posted: 8 Jan 2018 17:08 EST
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US

The installation of UDF functions is NOT required.  Nothing within the pega platform or any strategic apps should require the use of the UDFs.  They are useful to have during development  when you are still deciding on what properties are needed in reports.  If you are not able to install the UDFs then you will need to expose any property that you want to include in a report.  It is not recommended to install UDFs in production as the use of UDFs can cause a performance issue. 

https://docs.pega.com/when-use-and-when-not-use-unoptimized-properties-reports

 
Posted: 4 years ago
Posted: 10 Jan 2018 6:48 EST
olivier K (olivierK7667) Personal and Business Computers
Personal and Business Computers
FR

Thank you for your feedbacks,tomorow I will try to install pega platform by using Azure Database Server and setting bypass.udf.generation=true  .

we will try this experience and come back to you as possible .

Thanks !

 

 

Accepted Solution

Posted: 4 years ago
Posted: 25 Jan 2018 4:54 EST
olivier K (olivierK7667) Personal and Business Computers
Personal and Business Computers
FR

I installed pega platform by using Azure Database Server and setting bypass.udf.generation=true  .

It worked,we continuing our test and development 
Posted: 4 years ago
Posted: 6 Feb 2018 11:26 EST
olivier K (olivierK7667) Personal and Business Computers
Personal and Business Computers
FR

I confirm you , it work fine . Thank you for your help

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

Pega Collaboration Center 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