Pentaho

 View Only

 What is the best way to read mysql's blob with UTF-8 values from database and insert into another database?

Abhishek Sawant's profile image
Abhishek Sawant posted 02-28-2024 03:40
Hello, I'm trying to setup and ETL(transformation)  where it reads data from source mysql database and write it to another mysql database, but one of the field is blob with UTF-8 values.
 
I'm using 'Table input' step to read data from source mysql database and using 'Insert/update' step to write it to Target mysql database.
 
Attached are the screenshots for more details.
Attachment  View in library