BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ADN
Fluorite | Level 6 ADN
Fluorite | Level 6

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.

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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.

View solution in original post

3 REPLIES 3
SASKiwi
PROC Star

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
Fluorite | Level 6 ADN
Fluorite | Level 6

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
PROC Star

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.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 1015 views
  • 0 likes
  • 2 in conversation