topic Re: Stored process integration with web server in Developers

Stored process integration with web server

sandeep_reddy — Fri, 13 Jan 2017 13:36:46 GMT

Dear Team,

I have created one stored process and i am trying to integrate with SAS web server. I have followed some sample steps in the following URL https://libraries.io/github/Boemska/sas-hot-editor.

Requirement is , a user needs to select the path of a .csv file and a column from csv file needs to be updated in a database table.

Thanks & Regards,

Sandeep

Re: Stored process integration with web server

Kurt_Bremser — Fri, 13 Jan 2017 13:53:26 GMT

So you need

- a prompt for a filename

- import that file to a SAS dataset

- update an existing dataset with data from the imported dataset

Re: Stored process integration with web server

sandeep_reddy — Fri, 13 Jan 2017 14:00:36 GMT

HI Bremser,

Thanks For your Reply,

I have tested from SAS E.G and my code is working fine by giving a location in prompt. I need to link this stored process with existing web server.

Thanks & Regards,

Sandeep

Re: Stored process integration with web server

Kurt_Bremser — Fri, 13 Jan 2017 14:04:40 GMT

Once you have converted your EG code into a stored process, your web application server can run it.

(http://servername/SASStoredProcess)

Re: Stored process integration with web server

sandeep_reddy — Fri, 13 Jan 2017 14:52:40 GMT

Hi Bremser,

AS in attached document i have followed the steps,but still i am not able to access. The mentioned code in the document is sample one.

Thanks & Regards,

Sandeep

Re: Stored process integration with web server

Kurt_Bremser — Fri, 13 Jan 2017 18:57:44 GMT

And what happens when you try to access the web service?

Re: Stored process integration with web server

sandeep_reddy — Thu, 19 Jan 2017 11:33:13 GMT

Hi Bremser,

When i hit the URL ,it is showing a blank page.

Thanks & Regards,

Sandeep.o

Re: Stored process integration with web server

boemskats — Mon, 30 Jan 2017 21:53:41 GMT

Sandeep,

What exactly are you trying to do? The link you pasted points to an app that we built, but the steps there are deployment steps specific to that app - you shouldn't have to create any more stored processes or do any further integration. Following just some steps from that page really won't get you very far.

The original app and instructions can be found at https://github.com/Boemska/sas-hot-editor, but you must either have your csv data already in a dataset, or point the editor to a database.

What I'm most curious to find out is.... how did you come across this project? We've barely advertised it to anyone...

Nik