I'm a new bee to Talend. I'm asked to do a POC on Talend. Please help me with your suggestions.
The requirement follows like below.
Once the .CSV files(multiple files)are detected in SFTP Server, A control file is created as a file event file event for a polling mechanism in Talend. A Talend job, once triggered by the polling event, compresses the exported data, transports them to another S-FTP CN file loaction. From this new SFTP location,I have to use Talend to load the data to SQL server database.If successful it moves csv-files to a backup share and deletes the control.csv file from the old SFTP Loaction.
Now I need to prepare a Design document for this whole process.
Where will the job be execute? remote server (Linux box) or local machine? if the files are on SFTP server and you can only access the files through FTP protocol, the answer is yes, you have to get the files to local machine where the job is executed, and read the file using the tFileInputDelimited component.
