Page 1 of 1
Webservices Client as data source-WSDL Import not available
Posted: Tue Aug 08, 2017 9:19 pm
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
Posted: Thu Aug 10, 2017 10:45 am
by Vrisha
I got the WSDL URL link and downloaded the metadata structure. Now the webservices explorer option is available
Posted: Thu Aug 10, 2017 1:13 pm
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
Posted: Fri Aug 11, 2017 6:11 am
by Vrisha
Thanks for your prompt response, Erni. I am not a premium member. I will take premium membership and go through your comments
Posted: Thu Aug 17, 2017 2:40 pm
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.
Posted: Thu Aug 17, 2017 3:13 pm
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
Posted: Fri Aug 18, 2017 7:03 am
by Vrisha
Thank you , Ernie. I will go through the articles posted here.
Posted: Tue Aug 22, 2017 8:22 am
by Vrisha
As I am unable to progress with webservices client stage, I used the Hierarchical stage to get the data from URL.
Posted: Wed Aug 23, 2017 5:45 am
by eostic
Great solution. REST is becoming more and more prevalent, one reason being is that it remains vastly simpler than SOAP.
Ernie