Question

3
Replies
362
Views
Elliott Davis (Elliott.Davis)
Crestone Technology
Certified Lead System Architect
Crestone Technology
MX
Elliott.Davis Member since 2013 27 posts
Crestone Technology
Posted: October 23, 2017
Last activity: June 26, 2018
Posted: 23 Oct 2017 11:19 EDT
Last activity: 26 Jun 2018 16:30 EDT
Closed
Solved

How to import a DB table with a Pega BLOB from Postgres to Oracle

Summary

I am migrating our Pega environments. Our work history table is far too large to migrate via the Migrate Work wizard (1.5 million records). I am hoping that someone may have done a similar export/conversion/import and may have advice and examples.

Source Environment: Pega 7.2.1 on Postgres (Pega Cloud)

Target Environment: Pega 7.2.1 on Oracle (On-Premise installation)

Process we expect to do the following, but we are open to suggestions.
- export from Postgres to CSV
-- (perform transformations on export as needed)

- import to Oracle via SQL*Loader
-- (perform transformations on import as needed)

Challenge: the BLOB. The most difficult piece seems to be how to handle the BLOB (pzPVStream)

In the CSV table dump we get from Postgres from the Cloud team, the BLOB column appears as a string of Hexadecimal text, always beginning with "\x5a6c423700000". I will freely confess my ignorance on the subject; I have never exported/imported BLOB DB data. Can anyone provide suggestions how I might approach this?

Attached is a small CSV file. It is an export of some sample records in the format we receive them from the Cloud team.

Cheers,
Elliott

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.