topic Re: Extract Mysql MEDIUMBLOB (Image) one by one in Talend Studio

Extract Mysql MEDIUMBLOB (Image) one by one

Anonymous — Sat, 16 Nov 2024 08:53:39 GMT

Hi everyone, I am new to Talend.

Now I am working on a Mysql database which have a field containing images in the data type of MEDIUMBLOB.

I know that I have to set the date type to byte[] in the schema of the Mysql table, the output is tFileOutputRaw and also need to set the dynamic file name.

But what should be the set-up so that it can export the cells (the MEDIUMBLOB field) one by one to the tFileOutputRaw?

Re: Extract Mysql MEDIUMBLOB (Image) one by one

lojdr — Sat, 06 Jan 2018 01:45:19 GMT

Hello,

Please check the component tLOBDownload:

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F559&pi=marketplace%252F1%252Fproducts%252F559%252Fitems%252F838

It should help you with your task, but be aware, that MySQL returns BLOB as byte [], so you need to convert it to BLOB data type.

Re: Extract Mysql MEDIUMBLOB (Image) one by one

Anonymous — Sat, 06 Jan 2018 10:53:19 GMT

Thank you very much for your help!

This is very tricky, in the future better just save the image path in the database.

Re: Extract Mysql MEDIUMBLOB (Image) one by one

lojdr — Sun, 07 Jan 2018 13:35:28 GMT

You are welcome.

Saving pictures in RDBMS is not a good idea generally. There are better options where to store (e.g. some kind of Object Store).

Regards

Lojdr