Download Data from http source

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rsunny
Participant
Posts: 223
Joined: Sat Jul 03, 2010 10:22 pm

Download Data from http source

Post by rsunny »

Hi ,

I have a scenario where i need to download the data from http server(www.abc.com) into a flat file. Can anyone tell me what are the stages that i need to use in order to get the data into a file.As i tried using with xml stages and i couldn't able to succeed.

Any help is really appreciated.

Thanks in adance
rsunny
Participant
Posts: 223
Joined: Sat Jul 03, 2010 10:22 pm

Post by rsunny »

Hi ,

Can any one tell me how to get the data or is it not possible to get the data from http to file. Is thee any specific format that datastage is going to accept. I herd that we can get it through Java stages but other than that is there any other option available.

Any help is really appreciated

Thanks in advance
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As far as I know, the Java Pack is the only way to go.
-craig

"You can never have too many knives" -- Logan Nine Fingers
rsunny
Participant
Posts: 223
Joined: Sat Jul 03, 2010 10:22 pm

Post by rsunny »

Hi craig,

Cant we use any of the Real time stages to get the data from http to file. If we are getting the data from http server, does this server should be having any specific format to load to file either with java pack or with any other.

Any help is really appreciated.

Thanks in advance
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If the website has a service you can leverage, then the "real time" stages could be used. Never made any attempt to use the Java pack or source from an HTTP server so can't really answer the other question.
-craig

"You can never have too many knives" -- Logan Nine Fingers
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

I haven't tried it in awhile, but assuming that the data is a stand-alone xml document, the xmlInput Stage could take a url for retrieval of the document. I can't promise it will work, but it's worth a try.

If it's not xml, then it will have to be data that is delivered via a formal Web Service, with WSDL, and then you would use Web Services Pack.....

or.... use JavaPack and write your own http call. I did one years ago --- it wasn't that difficult, but you do need to have at least a little bit of java experience to understand how to build and compile your java code and do to the http bits inside of it.

...years ago people used the Perl Stage, but that no longer exists.....

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

eostic wrote:...years ago people used the Perl Stage, but that no longer exists.....
Sniff... now that I've used. Too bad it be dead.
-craig

"You can never have too many knives" -- Logan Nine Fingers
rsunny
Participant
Posts: 223
Joined: Sat Jul 03, 2010 10:22 pm

Post by rsunny »

Hi Ernie,

i tried with xml stages but for xml input stage we have two options either xml document or URL/FIle path. But if we check the option URL/FIle path where can we give the url path as the input doent have anything to specify the url path and so i couldnt able to work out wih that.

And Do we need to purchase Webservices pack seperately ?Can you explain me how we can deliver the data via web sevice using WSDL.

Thanks craig and ernie for your replies


Any help is really appreciated

Thanks in adance
shukla_krishna
Premium Member
Premium Member
Posts: 28
Joined: Mon Apr 20, 2009 11:27 pm
Location: san antonio

Post by shukla_krishna »

Have you got solution for this issue
Krishna Shukla
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

The best solution for "some data" (not xml) is to use JavaPack. Code your own HTTP retrieval and then parse it as you wish and write it to an output link.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply