11-27-2014 06:51 AM
Hi, I am new in SAS. I want to develop webservice job in SAS with the following requirement:
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
11-27-2014 07:56 AM
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.
11-28-2014 01:21 AM
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:
-<TABLE> -<INTABLE> <SqlString> "select * from dual" </SqlString> <Email> email@example.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.
11-28-2014 03:19 AM
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?
11-28-2014 04:34 AM
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.
11-28-2014 05:30 AM
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