Extract Mysql MEDIUMBLOB (Image) one by one

Five Stars

Extract Mysql MEDIUMBLOB (Image) one by one

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?


Accepted Solutions
Highlighted
Eight Stars

Re: Extract Mysql MEDIUMBLOB (Image) one by one

Hello,

 

Please check the component tLOBDownload:

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

 

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.

Výstřižek.PNG

 

View solution in original post


All Replies
Highlighted
Eight Stars

Re: Extract Mysql MEDIUMBLOB (Image) one by one

Hello,

 

Please check the component tLOBDownload:

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

 

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.

Výstřižek.PNG

 

View solution in original post

Highlighted
Five Stars

Re: Extract Mysql MEDIUMBLOB (Image) one by one

Thank you very much for your help!

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

Highlighted
Eight Stars

Re: Extract Mysql MEDIUMBLOB (Image) one by one

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog