Hello Vince!
We have an external system HMDM (Hyperion Master Datamart) that provides a Web Service with different services that we from the SAS side should be able to use.
E.g. When the HMDM needs input data from the Data Warehouse in SAS, it really would be nice if it was possible from SAS to have a job to be scheduled that exported the data from SAS, talked to the web services in HMDM system and then again used the web service available to addData to HMDM.
As for your suggestion with the pointer to the web service to execute that from a stored process this is something we was thinking about, but didn't quite get the syntax of. I know that we can setup a libname to a URL and from there sort of be a consumer, but this means I have to write all the XML syntax to make things happen?! Very hard I believe.
The implementation today is supported by exporting the data to SQL server and having the DTS to do the talking with the web service.
My whish list is filled up with the ability to both read and use external web services from the SAS Data Integration Studio. What plans are there here in SAS9.2? Heard in SUGI the Dan Jahn presentation, but I feel still a little confused here. Can you enlighten my knowledge a bit?
Best Regards
Ole-Martin Hafslund
... View more