The data is populated from a SQL Server varbinary column into a BLOB profile field. The data appears to be Base64 encoded already. After decoding the data is a binary string 0x[...].
I have tried:
- Inserting the Base64 and Binary strings into a Message Shape and Document Cache.
- Using Groovy to create an InputStream from the bytes.
The result is always the same: Boomi essentially treats the binary string as plain text that gets inserted into a file. I have tried this with a text file, jpg, and pdf (sending to disk or as a mail attachment).