WE Application data migration
We have a requirement to migrate data from pega database tables to external system. This data includes data from several application tables like work, attachment, data etc. Some of the properties are needed from blob column of pega tables which is pzpvstream.
Please suggest an approach where this pega application data can be accessible by outer application easily. The major challenge is in content specific properties like pyAttachStream for attachments.
Decision Consultant Solutions
GB
You can optimize the properties to have a separate column for the property which is in pzPVStream.
When you optimize the property, a separate column will be created in database column and the data will no longer be maintained in pzPVStream.
But it is not recommended to have more optimized properties which will impact the application performance.
Morgan Stanley
US
As I mentioned data is needed from multiple tables like PC_DATA_WORKATTACH. Can we create more than 1 blob column in custom table which can hold document streams to be used externally?