I have a SQL Server table where one of the fields contains an encrypted PDF and another field contains a key. Is there any way in FME to read it, decrypt it and write it out to the file system as a PDF document?

Hi @dave29

Our development team has mentioned it may be possible to use an AttributeFileWriter (to write the PDF blob to disk) and then read the file using the PDF reader with the password parameter if the PDF is simply password-protected. Would you be able to try this approach?

If you can create a SQL statement to write the PDF to disk (and I think a SQL procedure to retrieve the file is available), you could use the SQLCreator or SQLExecutor transformers to do so.

Then follow by a FeatureReader to read the PDF in FME and continue the process.

Hope this helps.