SAS Visual Analytics (On SAS Viya) Custom query retrieve data from Hive or RDBMS

jaycss — Mon, 26 Feb 2018 06:24:58 GMT

Hi,
I am new to SAS. Now i come to know about SAS Viya to generate visual reports so I want to generate report using SAS Viya. I have done many demonstration with local files.(i.e. excel files, csv files, etc.) Now I want to retrieve data from Database using custom query and generate report. Is it possible ? How ? Give me some suggestion. Thank you.

Re: SAS Visual Analytics Custom query retrieve data from Hive or RDBMS

DavidPope — Thu, 22 Feb 2018 20:21:33 GMT

Yes, it is very possible. You will need to setup a SAS library using the a libname statement to Hadoop or the RDBMS.

To do this you may need to have a specific SAS/ACCESS engine licensed. For example you may already have a SAS/ACCESS engine for ODBC which can be used to connect to any ODBC compliant source. You will need to have the proper userid/password permissions on the source setup by the Hadoop or database DBA in order for the libname statement to be successful.

topic Re: SAS Visual Analytics Custom query retrieve data from Hive or RDBMS in Developers

SAS Visual Analytics (On SAS Viya) Custom query retrieve data from Hive or RDBMS

Re: SAS Visual Analytics Custom query retrieve data from Hive or RDBMS