Sponsors and CROs know the value of having a consolidated and regulatory-compliant data warehouse, such as Oracle’s Life Sciences Data Hub (LSH), as well as the importance of consistently loading data into that warehouse quickly and accurately. However, as data structures from the source files change over time, it can be very time consuming to modify the data structure in the warehouse itself. Additionally, for the large groups of SAS datasets that are typical for a clinical trial, the out-of-the-box load times can be quite long, as the data is loaded one set at a time.
Perficient has the answer. In this webinar, we discussed and demonstrated an autoloader tool that greatly simplifies the data loading process for LSH. We showed how the autoloader can automatically load files, detect metadata changes, upgrade target structures, and load data, all with no human intervention. In addition, we demonstrated how Perficient’s autoloader tool can load multiple datasets in parallel to minimize load times.