Our Work

CSV Import in to DataBase(MySQL)

Updated 1 year, 6 months and 30 days ago

CSV Import in to DataBase(MySQL) :

 

  1. 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 .

 

  1. Here we can add new column by clicking on “+” button and edit the name , data type of column :
     

 

 

 

  1. Extracting and validating the CSV Data using tJavarow component as shown in below ScreenShot . :

 

 

 

  1. Below ScreenShot shows CSV columns mapping to Mysql Table fields for inserting CSV data to MySQL Table :

 


 

  1. Talend job execution in talend studio syncing CSV data to MySQL table and logs showing the number of records inserted in to Mysql .

 

 

 

 

  1. Talend job CSV data inserting in to Mysql database ScreenShot :

 

  • After that using Call method with parameters as

Tags

    No tag results found for this post