This scenario retrieves data from a CSV file stored in an S3 bucket. This is achieved by first downloading the file using the tS3Get component and then reading data from the downloaded file using tFileInputDelimited.
For more technologies supported by Talend, see Talend components.
The following gives the Job for this purpose.
This scenario retrieves data from the file customers.csv. The following lists the data stored in the CSV file.
1;Griffith Paving and Sealcoatin;talend@apres91;03/11/2006
2;Bill's Dive Shop;511 Maple Ave. Apt.1B;19/11/2004
3;Childress Child Day Care;662 Lyons Circle;16/02/2005
4;Facelift Kitchen and Bath;220 Vine Ave.;22/08/2002
5;Terrinni & Son Auto and Truck;770 Exmoor Rd.;28/06/2001
6;Kermit the Pet Shop;1860 Parkside Ln.;17/08/2003
7;Tub's Furniture Store;807 Old Trail Rd.;27/08/2000
8;Toggle & Myerson Ltd;618 Sheriden rd.;24/03/2006
9;Childress Child Day Care;788 Tennyson Ave.;10/09/2001
10;Elle Hypnosis and Therapy Cent;2032 Northbrook Ct.;11/01/1977