png image to SQL databse

[benja123]

how do I save a png image on a SQL databse ? and after that how do I load my png image into an other alteryx workflow ?

[BrianR · Accepted solution]

Hi @benja123, you can use something like this - the family of Blob tools, located in the Developer tab. The attached workflow illustrates how to read in a given png image, convert it to a Base64 encoded field, then write to a SQL Table. In my test case, I wrote it to SQL Server. The 2nd container shows how to read in that blob, convert it back to an image, and then write it to a folder. Also in this test case, I used SQL Server, but assuming other databases should work similar.

Brian

If this solves your issue, please consider marking this as Complete so others can find this as well.