Live data connection to Postgres from SAS VA 7.4

[ADN]

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.

[SASKiwi]

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.

[ADN]

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?

[SASKiwi · Accepted solution]

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.