Four Stars

retrieve a parameter file from the internet

Hello,

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

 2.jpg

 

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

5 REPLIES
Fifteen Stars

Re: retrieve a parameter file from the internet

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.

Rilhia Solutions
Four Stars

Re: retrieve a parameter file from the internet

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

Fifteen Stars

Re: retrieve a parameter file from the internet

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.

Rilhia Solutions
Four Stars

Re: retrieve a parameter file from the internet

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

Four Stars

Re: retrieve a parameter file from the internet

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 ??

 


1_.jpg

 

 

 

Thank's