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?
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.
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?
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.