Discussion

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

Comments

Keep up to date on this post and subscribe to comments