Creating a Job to insert BLOB data into a MySQL table - 8.0

Data Integration Job Examples

Version
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development > Designing Jobs
Last publication date
2024-02-06
Create a Job to iterate over the picture files in the "C:/Talend/images" folder and insert each one into the blobdemo table.
Screenshot of the Job in the Designer.
  • The tFileList iterates all pictures in the "C:/Talend/images" folder.
  • The tFixedFlowInput gets the current file path and outputs it.
  • The tMap calls the routine to read the files as byte array.
  • The tMysqlOutput inserts the BLOB data into the target table.