Convert from SQL Database BLOB field to PDF

ladazhome

Good morning,

I have a database connection that includes a BLOB field containing either .JPG or .PDF files.

My goal is to export the files from this field back to their original formats.

For the JPG files, I’ve used the Blob Convert function, and the export is working correctly.

However, I’m having trouble with the PDF files and am unsure of the correct process. Any guidance on how to properly convert a PDF binary BLOB back into a usable PDF file would be greatly appreciated.

Thank you in advance for your help.

OTrieger

@ladazhome 
As per what I know PDF stored as a binary BLOB is already the complete raw PDF data. There's no real conversion needed as with images, you only need to write those exact bytes to a file with a .pdf extension, you can use formula tool to do just that, renaming the path so it will be "\\...\...\....file.pdf" You will need to use a Blob output tool.