Question

6
Replies
1278
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:

https://pdn.pega.com/deploying-pega-platform-microsoft-azure/deploying-pega-platform-microsoft-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://pdn.pega.com/deploying-pega-platform-amazon-web-services/deploying-pega-platform-amazon-web-services :

" 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***

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.