topic Re: VA Dashboad via DB in SAS Visual Analytics

VA Dashboad via DB

ZulfiqarMemon — Wed, 25 Aug 2021 13:37:24 GMT

Hi All,

Is there is option available in SAS to create Dashboards in VA which uses direct DB tables. I mean no dataset to be involved as dataset hold storage on the server.

Regards,

Zulfiqar

Re: VA Dashboad via DB

Madelyn_SAS — Wed, 25 Aug 2021 13:41:26 GMT

Visual Analytics uses either LASR tables (7.x) or CAS tables (8.x and higher).

Re: VA Dashboad via DB

ZulfiqarMemon — Wed, 25 Aug 2021 13:51:10 GMT

Does LASR Table stores data in any File/DataSet.

Re: VA Dashboad via DB

Madelyn_SAS — Wed, 25 Aug 2021 14:12:58 GMT

You can import a variety of data files to the LASR Analytic Server. Specific to databases, you can import database tables from Aster, DB2, Greenplum, MySQL, Netezza, ODBC, Oracle, PostgreSQL, Salesforce, SAP HANA, SQL Server, Teradata, and Vertica. The SAS/ACCESS product for the database must be licensed and configured for the SAS Workspace Server.

Importing Data from Servers

Re: VA Dashboad via DB

ZulfiqarMemon — Wed, 25 Aug 2021 14:21:40 GMT

Thanks for guidance. Is import of tables necessary. Will only successful connection with DB not be sufficient. Please correct me that If understand correctly that its possible.

Re: VA Dashboad via DB

Madelyn_SAS — Wed, 25 Aug 2021 14:37:39 GMT

The data must be loaded to the LASR server in order for Visual Analytics to use it.

Re: VA Dashboad via DB

ZulfiqarMemon — Wed, 25 Aug 2021 17:24:11 GMT

Then what is Data Server? I have searched SAS site. What does it contain? In my case it can be DB Server or not, from there data can be loaded into VA. However, any possibility to load data on runtime?

Re: VA Dashboad via DB

SASKiwi — Wed, 25 Aug 2021 21:55:56 GMT

AFAIK, loading VA data at run time isn't possible and is not feasible as it would cause a huge performance hit. VA relies exclusively on in-memory data storage to provide the necessary performance.