Reading serialized Blobs & Deserialize the blob

pankajg · Post by **pankajg** » Fri May 31, 2013 5:49 am

We are reading a blob from Microsoft SQL Server which has serialized information. I need to read this blob - de-serialize this blob ( I have the schema for the serialized blob) and store this into Netezza DB. At a conceptual level - i understand that I would need to read this blob, de-serialize the same using some program/script and possibly send it to database tables. Since we are using DS to read the blob, i wanted to know if DS has any capabilities to help me execute this.

Thanks
Pankaj

ray.wurlod · Post by **ray.wurlod** » Fri May 31, 2013 4:22 pm

DataStage has no in-built capacity for dealing in any way with BLOBs.

If you have a command-line utility for de-serializing the BLOB then, since you have a Windows server for DataStage, you may be able to invoke that utility through a Command stage.