topic Re: Live data connection to Postgres from SAS VA 7.4 in SAS Visual Analytics

Live data connection to Postgres from SAS VA 7.4

ADN — Wed, 31 Jul 2019 11:26:47 GMT

Hi,

I am trying to create a report in SAS VA 7.4 and my data resides in a Postgres Database. I want to have a live connection to the database. Is it possible to do it without importing the table everytime into SAS Visual Analytics Public LASR library?

Thanks.

Re: Live data connection to Postgres from SAS VA 7.4

SASKiwi — Thu, 01 Aug 2019 06:47:24 GMT

What do you mean by a "live connection to a database"? How often is your Postgres database updated and how often do you want to update your VA 7.4 LASR server data? You could easily have a scheduled job which runs at a frequency of your choosing to update LASR data from Postgres.

Re: Live data connection to Postgres from SAS VA 7.4

ADN — Thu, 01 Aug 2019 08:07:37 GMT

By a live connection, I mean the VA report should show exactly what is in the database table at that point of time.

The data in my Postgres database is updated 3-4 times a day. Is there any other way of doing this other than running a scheduled job?

Re: Live data connection to Postgres from SAS VA 7.4

SASKiwi — Thu, 01 Aug 2019 20:07:30 GMT

I guess you are talking about a view of the Postgres table in LASR. Unfortunately views are not supported in SAS VA so scheduled updates are the way to go.