Marius Tankeu (tankm)
Senior Technical Architect
Pegasystems Inc.
tankm Member since 2019 4 posts
Posted: September 13, 2019
Last activity: September 13, 2019
Posted: 13 Sep 2019 11:15 EDT
Last activity: 13 Sep 2019 15:58 EDT

Pega Marketing 8.3 Installation - Download manual DDL SQL requests

When Installing of Pega Marketing 8.3, the import PegaMarketing_Core_0803.zip step is suppose to give the choice to create either manually or automatically PEGA Marketing tables in PEGA Marketing dedicated schema (mkt_paidmedia* tables for example).

In prior versions, it was possible to download all DDL sql requests in 1 sql file. In version 8.3, you will need to click on each request and copy the SQL requests if you want to execute manually.

A workaround is to use the prpcUtils in <PEGA_Plaform_Distrib>/scripts/utils/ directory with the operation generateDDL.

You will need to configure the prprcUtils.properties file and also put in this directory a dedicated prconfig.xml. I attached the files in my case, fell free to customize according to your environment.

Then launch: ./prpcUtils generateDDL (I tested on CentoS 7)

This will generate in the folder specified in prpcUtils.properties a zip files with 2 files containing all the SQL requests needed to install Pega Marketing 8.3.

Hope this helps!

***Edited by Moderator Marissa to update SR Details***

Pega Marketing Support Case Exists Developer Knowledge Share