topic Re: retrieve a parameter file from the internet in Talend Studio

retrieve a parameter file from the internet

Anonymous — Sat, 16 Nov 2024 08:36:57 GMT

Hello,

I work on a job that works well, you find attached the diagram explaining the job :

Now I wonder if there's a possibility to indicate only an address from the internet (ip, host ...),
to recover the file that contains the parameters of the source and destination database.

Do you have an idea about the component to do this job?

Thanks for your help

Re: retrieve a parameter file from the internet

Anonymous — Fri, 02 Mar 2018 14:44:52 GMT

Use a tFileFetch.

Put the URL in the URI, deselect "POST" and tick "Use cache to save the resource".

Link it to the tFileInputDelimited via an OnSubJobOK.

Add the following to your tFileInputDelimited's "File name/Stream"....

((java.io.InputStream)globalMap.get("tFileFetch_1_INPUT_STREAM"))

....tFileFetch_1 is the name of my tFileFetch component there, you may need to change this to match.

Once you've done that it will stream the file from your internet source.

Re: retrieve a parameter file from the internet

Anonymous — Fri, 02 Mar 2018 15:52:43 GMT

I try this solution, do you have a concrete example ??

Re: retrieve a parameter file from the internet

Anonymous — Fri, 02 Mar 2018 18:51:33 GMT

Leave your job as it is, add a tFileFetch and set it up as I described. Join it to the tFileOutputDelimited using a SubjobOk link. Then change the URI of the tFileOutputDelimited as I suggested. It is that simple, I promise.

Re: retrieve a parameter file from the internet

Anonymous — Mon, 05 Mar 2018 08:39:04 GMT

You have to indicate that I have to join it with tFileInputDelimited in your first answer, then in the last moment you said tFileOutPutDelimited !!!!

Re: retrieve a parameter file from the internet

Anonymous — Tue, 06 Mar 2018 09:15:14 GMT

Hello,

i tried what you have suggest, and i have always the same error, do some one have any idea about how to solve this error ??

Thank's