Define other directory for Pega generated batch output file
Hi all,
Does anyone know if I can define another DB directory to store the batch files generated automatically by Pega, after i.e. Audience segmentation or a campaign run? Any advice would be great!
-Shi Hui
Pegasystems Inc.
GB
Hi, the batch output tables are generated in the schema described by the ExternalMKTData Db-admin-database instance. This instance setting is yours to set but it should be on the same DB instance as the pega data schema.
Hope this helps
Accenture
SG
Thanks Nigel! I have setup a few schema under the same ExternalMKTData DB instance, so is it possible to have my customer records table in schemaA, but to direct those batch output tables generated into schemaB? Where can i go set this configuration?
Currently my customer records table is in schemaA, and the batchoutput tables are also generated under schemaA which is not ideal, since tablespace maintaince would be very tough.
Thanks again!
Pegasystems Inc.
GB
Hi, slightly unsure about your point about 'further schema' under ExternalMKTData. This DB instance definition describes the default schema for that connection. The Batchoutput tables will be created in this default schema. The product also expects to find the customer data in this schema too, but as these are not dynamically created you could use synonyms as a way to host these ables in other schema ( if your DB supports synonyms ).
The only configuration available here is the specification of ExternalMKTData.
Hope this helps.