topic Re: Instructions for using SAS/ACCESS to read from Sql Server and load them in VA in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Instructions-for-using-SAS-ACCESS-to-read-from-Sql-Server-and/m-p/273395#M4403 No need to read 1000 pages, use content navigation or the search facility in the online doc...<BR /><BR />For 1, check with the SAS Admin. Will also be verified when you try no 2. Just issue a libname to your SQL Server according to the doc and the settings at your site.<BR /><BR />3 will be discussed in the VA documentation. Thu, 26 May 2016 20:54:09 GMT LinusH 2016-05-26T20:54:09Z Instructions for using SAS/ACCESS to read from Sql Server and load them in VA https://communities.sas.com/t5/SAS-Visual-Analytics/Instructions-for-using-SAS-ACCESS-to-read-from-Sql-Server-and/m-p/273248#M4395 <P>Once again for my next project assignment on SAS VA, I am lost in an ocean of documents.</P><P>We have SAS VA on a Windows Server 2012 x64 server. Our license includes SAS/ACCESS.</P><P>Our database is Sql Server.&nbsp;</P><P>&nbsp;</P><P>Here is what I want to do:</P><OL><LI>Make sure if SAS/ACCESS is installed and is ready to use.</LI><LI>Set up a connection to the database</LI><LI>Using a simple query to load the data into SAS VA as a <EM>Data Source.</EM></LI></OL><P>&nbsp;</P><P>Please let me know if there is a good walkthrough other than SAS/ACESS' 1000-page manual.</P> Thu, 26 May 2016 13:06:38 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Instructions-for-using-SAS-ACCESS-to-read-from-Sql-Server-and/m-p/273248#M4395 pedrammobedi 2016-05-26T13:06:38Z Re: Instructions for using SAS/ACCESS to read from Sql Server and load them in VA https://communities.sas.com/t5/SAS-Visual-Analytics/Instructions-for-using-SAS-ACCESS-to-read-from-Sql-Server-and/m-p/273395#M4403 No need to read 1000 pages, use content navigation or the search facility in the online doc...<BR /><BR />For 1, check with the SAS Admin. Will also be verified when you try no 2. Just issue a libname to your SQL Server according to the doc and the settings at your site.<BR /><BR />3 will be discussed in the VA documentation. Thu, 26 May 2016 20:54:09 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Instructions-for-using-SAS-ACCESS-to-read-from-Sql-Server-and/m-p/273395#M4403 LinusH 2016-05-26T20:54:09Z