Question
3
Replies
477
Views
Posted: April 10, 2018
Last activity: May 16, 2018
Closed
Pega marketing tables created under public schema
hi All,
We imported Pega marketing module 7.31. Our developers came back and advised that the tables related to this module will have to create under schema externalmktdata whereas they are created under public schema. I ran the import again and saved the DDL and can see it tries to create the tables under public.
Now I was wondering if this is correct behaviour or if I missed something during configuration-setup-deployment that caused such behaviour.
Hi Saman,
The below is the link for the installation guide for Pega Marketing:
https://pdn.pega.com/documents/pega-marketing-731-installation-guide
In this guide it is clearly mentioned that you need to create the externalMKTData and then you need to enter the data source in the respective configuration file or if using JDBC URL set the respective jdbc url.
Please follow the guide to do the installation and let us know if you still face the issue.
It would be better to remove these tables from public schema and then do a fresh installation.
Regards,
Vikash