edi - Talend : Generate and populate txt file and put in on FTP -

-

i have question in talend :

i need create file name "file_" + talenddate.getdate("ccyy-mm-dd hh:mm:ss") + ".txt" , populate result of sql query , add "\t" separator on each column of each row.

after that, need connect ftp (through tftpconnection component), , put file on folder (through tftpput component)

the main problem encounter don't know composent should use when i'll create text file ? should use tfileoutputpositional ? tfileoutputdelimited ? component ?

moreover, have issue : when i'm connecting ftp, no worries when i'm on tftpput component, have issue :

java.net.sockettimeoutexception: accept timed out

enter image description here

any idea ?

thanks

first need execute sql query.

to generate file should use tfileoutputdelimited on row data , change field separator tab "\t".

set filename directly in tfileoutputdelimited component. keep in mind path contains forward slashes, e.g.:

"c:/my-folder/file_" + talenddate.getdate("ccyy-mm-dd hh:mm:ss") + ".txt"

depending on configuration might set ftp connection passive mode (see more here https://community.boomi.com/docs/doc-1643)


Comments

Post a Comment

Popular posts from this blog

ruby on rails - Permission denied @ sys_fail2 - (D:/RoR/projects/grp/public/uploads/ -

-
i trying rename upload image permission denied @ sys_fail2 - (d:/ror/projects/grp/public/uploads/gallery/test.jpg, d:/ror/projects/grp/public/uploads/gallery/qinsnvzicc20160509132021.jpg) my code : photo = params[:gallery][:gal_img] name = photo.original_filename directory = "#{rails.root}/public/uploads/gallery/" path = file.join(directory, name) uniq_name = (0...10).map { (65 + rand(26)).chr }.join time_footprint = time.now.to_formatted_s(:number) file.open(path, "wb") |file| new_file_name = uniq_name + time_footprint + file.extname(file) file.write(photo.read) @uniq_path = file.join(directory, new_file_name) file.rename(file, @uniq_path) end i have checked , giving privilege in ruby directory. please let me know why getting permission denied error?
Read more

c++ - nodejs socket.io closes connection before upgrading to websocket -

-
i'm trying write c++ client talk websocket server written using nodejs , socket.io. can't c++ client establish websocket connection; server drops connection right after client requests http connection upgraded websocket. i used tcpdump watch packets going , forth. when use websocket server browser, works great , tcpdump output shows packets going , forth. when try connect server using c++ client, websocket connection never gets established. output tcpdump shows upgrade request being sent server followed server dropping connection. i tried replicating sequence of events using nc . connected server (running on port 8080) , copy-pasted exact set of headers sent browser, captured tcpdump. duplicate of working headers, connection dropped. there no output on server end indicating why connection gets dropped. here headers sent: get /socket.io/?type=player&eio=3&transport=websocket&sid=7mdclht_8ctsd6f4aaac http/1.1 host: localhost:8080 connection: upgrade prag
Read more

java - What is the equivalent of @Value in CDI world? -

-
what way 1 inject property value property placeholder cdi bean? in spring 1 write: @org.springframework.beans.factory.annotation.value("${webservice.user}") private string webserviceuser; what sets webserviceuser field property webservice.user property file/property placeholder. how cdi? i've tried find answer, couldn't find equivalent. however, people write, can use cdi spring substitute on application servers, , use case basic, surely there must easy way, unfortunately i've failed find it. cdi specification dependecy injection , context doesn't have such configuration things out of box. provides powerful extension mechanism allows third party projects add new portable features (i.e works cdi implementation , not tied server). important project providing cdi extensions apache deltaspike , news, provides need. so need add deltaspike-core in project. if use maven, need add dependencies pom.xml <dependency> <group
Read more