We are newcomers to SAS VA, and have a single Windows Server based SAS VA installation - SAS 9.4_M3 and VA Server 7.3. Our database servers are MS SQL and I have successfully connected to the required database and tables using ODBC. First record set is imported into LASR and queryable etc, but these SQL databases are bulk updated on a daily basis and so I need to now the steps involved in grabbing the newly updated data, preferably on a daily basis. I can manually upload the tables each day, but this is not really what I'm looking for. Any help or suggestions would be very much appreciated. If these involve 'work' at the SQL Server end then this is just as accessible to me as I have good SQL and developer availability. Many thanks
... View more