Webservices Client as data source-WSDL Import not available

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Vrisha
Premium Member
Premium Member
Posts: 60
Joined: Sat Jul 15, 2017 9:32 pm
Location: Texas,USA

Webservices Client as data source-WSDL Import not available

Post by Vrisha »

I am using 'Web services Client' as a data source to get the data from URL.
1) When I click Import--> Table Definition --> Web Services WSDL Definition---> typed the URL---> Asking to open / save the file.

2) I opened the file ---> Selected all the contents -->' Import' is disabled and nothing appearing in the right hand side (Web services explorer)

Please let me know what could the reason for 'Import' button being greyed out and nothing appearing in right hand side (Web service explorer).

Thank you
Suja
Vrisha
Premium Member
Premium Member
Posts: 60
Joined: Sat Jul 15, 2017 9:32 pm
Location: Texas,USA

Post by Vrisha »

I got the WSDL URL link and downloaded the metadata structure. Now the webservices explorer option is available
Suja
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

I've seen this on several occasions when the WSDL url site itself was protected by https security or other similar protocols. The metadata importer doesn't have any sophisticated credential mapping features, so usually quits or displays nothing. ...but once you have the wsdl already downloaded hopefully it will be fine.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Vrisha
Premium Member
Premium Member
Posts: 60
Joined: Sat Jul 15, 2017 9:32 pm
Location: Texas,USA

Post by Vrisha »

Thanks for your prompt response, Erni. I am not a premium member. I will take premium membership and go through your comments
Suja
Vrisha
Premium Member
Premium Member
Posts: 60
Joined: Sat Jul 15, 2017 9:32 pm
Location: Texas,USA

Post by Vrisha »

Eventhough I downloaded the WSDL file to my desktop, I am unable to get the data from the URL provided (to pull the data.)

Don't understand the root cause for this problem. Do we need to give hostname, portname in the Proxy for web client services stage? Please let me know.
Suja
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Ultimately, be sure that you can run the service successfully from any kind of external testing tool...preferably one that runs on the platform where the DataStage engine is running. Some of these are tools like SOAPui. It's important that you know everything about the Web Service. The Stage can handle very simple web services, not complex ones. It is possible you might need to code java to do the web services calls.

Do a LOT of searching in this forum. Web Services have been reviewed here for many years, with lots of thoughts on structure, complexity, security, setup, debugging and more.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Vrisha
Premium Member
Premium Member
Posts: 60
Joined: Sat Jul 15, 2017 9:32 pm
Location: Texas,USA

Post by Vrisha »

Thank you , Ernie. I will go through the articles posted here.
Suja
Vrisha
Premium Member
Premium Member
Posts: 60
Joined: Sat Jul 15, 2017 9:32 pm
Location: Texas,USA

Post by Vrisha »

As I am unable to progress with webservices client stage, I used the Hierarchical stage to get the data from URL.
Suja
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Great solution. REST is becoming more and more prevalent, one reason being is that it remains vastly simpler than SOAP.

Ernie
Ernie Ostic

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