BookmarkSubscribeRSS Feed
DiptiP
Calcite | Level 5

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...

5 REPLIES 5
Kurt_Bremser
Super User

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.

DiptiP
Calcite | Level 5

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...

jakarman
Barite | Level 11

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?

---->-- ja karman --<-----
DiptiP
Calcite | Level 5

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.

jakarman
Barite | Level 11

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

---->-- ja karman --<-----

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 730 views
  • 0 likes
  • 3 in conversation