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

[jaycss]

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. 

[DavidPope]

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.