retrieve a parameter file from the internet

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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