Talend File Upload Strategy

I want to know which of the best strategies to solve the following problem in Talend:

  • I need to load data from a set of delimited files that are stored in a directory with these names (SAMPLE1.DAT, SAMPLE2.DAT, ..., SAMPLEX.DAT)
  • The goal will be a table in a MySQL database.
  • I need to download all the data at once, because after this task I need to work with all the records in the same table

I'm a bit confused because I don't know if this is possible in Talend. I saw the tFileInputDelimited component, but I did not find a way to solve it.

thank

+3
source share
2 answers

, tFileList. . , , .

"Iterate" tFileList , , . tFileInputDelimited ( ) tMysqlOutput. MySQL , .

tFileInputDelimited , , tFileList (, ). "" , .

+5

tFileInputDelimited tMap () tmysqlOutput

1: , , , : Step 1

2: , : Step 2

3: , Db , : Step 3

4: "" > "" > "" .

5: tMap .

6: , , , , , . , .

7:, , , tfiledelimited , , , "" > "" , , tmap.

+1

All Articles