Updated 2 years, 1 month and 2 days ago
CSV Import in to DataBase(MySQL) :
Drag and drop tFileInputdelimited component from palette and provide the csv file path , columns details as shown in below ScreenShots:
Add CSV columns to tfileinputdelimited schema by clicking Button beside edit Schema ,which will open an tab as shown in below screen shot .
Here we can add new column by clicking on “+” button and edit the name , data type of column :
Extracting and validating the CSV Data using tJavarow component as shown in below ScreenShot . :
Below ScreenShot shows CSV columns mapping to Mysql Table fields for inserting CSV data to MySQL Table :
Talend job execution in talend studio syncing CSV data to MySQL table and logs showing the number of records inserted in to Mysql .
Talend job CSV data inserting in to Mysql database ScreenShot :
After that using Call method with parameters as