topic Visual Analytics web interface to run an ETL process in Developers

Visual Analytics web interface to run an ETL process

AsSASsin — Mon, 03 Dec 2018 18:56:32 GMT

Hello!!

I’m trying to develop a web app that is opened in the Sas Visual Analytics viewer.

Basically my problem is this:

I have a form with a button that submit the action to call the stored process.

Everything works well but it is submitted in another page.

I need to stay on the same page and change the “innerHTML” value of a dom object to comunicate the status with the user.

How could I do that?

Thanks.

Re: Visual Analytics web interface to run an ETL process

boemskats — Mon, 03 Dec 2018 19:48:39 GMT

I'd need to see your code, but I imagine you're doing HTML form submits rather than anything AJAXy. You need to use Javascript and an XMLHttpRequest to interact with a server without having to do a full page refresh. We maintain a library that facilitates this with SAS that may save you a lot of time.

Have a look at the following link on XMLHttpRequests: https://developer.mozilla.org/en-US/docs/Web/API/XMLHttpRequest

And the following for H54S (the lib I mentioned): https://github.com/boemska/h54s

Nik

Re: Visual Analytics web interface to run an ETL process

AsSASsin — Mon, 03 Dec 2018 22:24:35 GMT

Thank you very much.

Yes it is html form.

I looked the links, but I can’t find examples.

My application is very simple...just modify a <p> text object in the page if a SAS script is gone well.

Have you any link with some examples to understand how it works?

Re: Visual Analytics web interface to run an ETL process

AsSASsin — Tue, 04 Dec 2018 12:59:05 GMT

Today I tried to use the xmlhttprequest and in seems to work like a charm.
I haven’t used h54s but the xmlhrrequest works well with JavaScript and the standard w3school code just modified for my purposes.
Thank you for the help!