Hi All,
Wanted to understand what should be be the correct architecure for using live data in SAS VA.
I have data in SQL Server and wanted to have upto date data in SAS VA Report. If there is any change in SQL Server data it should be reflecting in SAS VA reports as well.
I know using CAS LIB we can connect SQL Server tables but whether that it will make sure that as soon as the data is updated in SQL server it will start reflecting in SAS VA reports.
Thanks,
Anurag Rai
The report will show whatever data is in the currently loaded table. Are you seeing something different?
If you are asking how Visual Analytics can read the SQL table direct, that is not possible. Visual Analytics uses data sources that are loaded into memory.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Hi Madelyn_SAS,
I am seeing the right data which is loaded in CAS server there is no discrepancies in data.
In my requirement am looking for a solution in which any update in SQL Server Tables should reflect in SAS VA reports. It is very simililar to Live data option which is being used in Tableau.
Hope my requirement is clear.
Regards,
Anurag Rai
You could only get this when any change on the database triggers a new CAS load in SAS. A "live" direct connection to a DB can only be done in SAS 9.4 or Viya with a SAS/ACCESS LIBNAME.
@anuragraishines - Check out these library articles about loading CAS in near real time with SingleStore. And this one.
With traditional databases like SQL Server, I suspect you will have to run regular load jobs in VA to stay up-to-date. How close to "real time" do you need to be? If being up to one hour behind is OK, then running a load job every hour would meet your needs.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.