topic How to develop web services in SAS data integration in SAS Programming

How to develop web services in SAS data integration

DiptiP — Thu, 27 Nov 2014 11:51:37 GMT

Hi, I am new in SAS. I want to develop webservice job in SAS with the following requirement:

allows the user to forward query to the Database (DB),
runs this query,
notifies the user that the execution is ended and so he

To achieve these results the two jobs must be implemented:

1. JOB1: WS that interacts with the user to receive the query

2. JOB2 : Job that executes the query

Thanks...

Re: How to develop web services in SAS data integration

Kurt_Bremser — Thu, 27 Nov 2014 12:56:27 GMT

If you want the user to actually specify the query, you're better off with SAS Enterprise Guide or SAS Studio.

If you only need the ability to specify parameters for the query, write a HTML form that gathers the data and then calls a SAS Stored Process that outputs another HTML that contains the notification.

Re: How to develop web services in SAS data integration

DiptiP — Fri, 28 Nov 2014 06:21:01 GMT

Hello Kurt,

Thanks for your reply.

I want to develop these jobs in SAS Data Integration Studio. The input would be an XML file in which the query would be stated. Example:

<?xml version="1.0"?>

-<TABLE> -<INTABLE> <SqlString> "select * from dual" </SqlString> <Email> test.test1@email.com </Email> </INTABLE> </TABLE>

JOB1: It will fetch this query and call another job-JOB2 which will connect to the database and execute the query(Select Query).

If the query runs without any error, the data is fetched from the db and populated in a csv file and the user is notified with response(Success/Error) through XML file output.

Thanks...

Re: How to develop web services in SAS data integration

jakarman — Fri, 28 Nov 2014 08:19:12 GMT

Normal operational processed (schedulers) have this kind op options in their tool. LSF is an example of that.

Would you state that your devlopment is also your production environment? No testing validation and segregation? What about CMM?

Re: How to develop web services in SAS data integration

DiptiP — Fri, 28 Nov 2014 09:34:23 GMT

Hello Jaap,

Here we are not suppose to use any scheduler. And its not in production. WE just have to develop the job for web services in SAS data integration.

Re: How to develop web services in SAS data integration

jakarman — Fri, 28 Nov 2014 10:30:54 GMT

In a webservices you are running java and with that having a scheduler. Never mind knowing everything is impossible.

You input XMLdata set should be easiluy read using the: libname xml way. Only in difficult situation needing a mapfile (xerces xmlmapper).

Having the data in a accessible table your emailing can start by using some code. The requirement is your machine has been set up/configured for that.

For email check the technical functionality using some code. You must be able to send email to somebody. Firewalls autorizations and mailserver(s). Ask your platform admin for help.

Having that you can extend that to some SAS code for bulkmail. Think you are some spammer or not is part of that mail settings.

The lat one is putting that code in some DI one and make is available for the webpart. The webpart is your production I assume.

For mailing there is also a publishing framework, it part of the SAS metadata.Publishing Framework