The following is the list of widely used connectors and components for data integration in Talend Open Studio − tMysqlConnection − Connects to MySQL database defined in the component. tMysqlInput − Runs database query to read a database and extract fields (tables, views etc.) depending on the query. tMysqlOutput − Used to write, update, modify data in a MySQL database. tFileInputDelimited − Reads a delimited file row by row and divides them into separate fields and passes it to the next component. tFileInputExcel − Reads an excel file row by row and divides them into separate fields and passes it to the next component. tFileList − Gets all the files and directories from a given file mask pattern. tFileArchive − Compresses a set of files or folders in to zip, gzip or tar.gz archive file. tRowGenerator − Provides an editor where you can write functions or choose expressions to generate your sample data. tMsgBox − Returns a dialo...
Use below expressions in any of the talend job flow to get the formated date output, Expression can be applied in tMap, tJava,tJavaflex,tJavaRow etc... TalendDate.formatDate("hh:mm dd-MM-YY",TalendDate.parseDate("HHmmddMMyy",row1.newColumn))
It is based on the version what we are using. Talend Open Studio does not allow you to build jobs from the command line, that's a feature of the enterprise edition of Talend which has a commandline module. Alternatively you can export the job and execute .bat file from windows systems, .sh file is from linux systems
Comments
Post a Comment