Hi, I cannot find a suitable post to this question, but would welcome any pointers if it already exists.... We have just started using VA (7.4) for some of our reporting requirements, and have so far used different methods to load our data into the LASR server. Each of these have some benefits and drawbacks but I was wondering if people had some good best practice (practical examples or just theoretical to start) for how to do this. Main problems: Server is a little unstable at the moment and often requires restarting and subsequent reloading of datasets Some data is specific to VA reports, while other tables are used across our SAS platform - data will be required from different libraries Options we have considered: Load the data as part of an ETL process (e.g. in the DI Studio job have a job which loads the table to LASR) Not all tables are created in DI Cannot easily reload just the required tables to LASR when the server restarts Manually load tables through VA Administrator Not practical in the future Write a script which checks and restarts the server and reloads the tables Not sure if this is possible Use an autoload library Currently not enabled/setup Use a combination of the above Try to minimize complexity so that if a reload is required we do not have to undertake any or at least different processes Any advice would be very welcome, as would any links to other ideas or practical solutions! Thanks!
... View more