Pentaho

 View Only
Back to discussions
Expand all | Collapse all

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

This thread has been viewed 5 times

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

    Posted 02-28-2024 08:55
      |   view attached
    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.


    ------------------------------
    Abhishek Sawant
    Systems Engineer
    Boku Network Services In Private Limited
    ------------------------------

    Attachment(s)

    docx
    Issue_detail.docx   211 KB 1 version


Related Content