About the Historical Data Snapshot

Just prior to the implementation of the FOLIO system in July 2021, Library Systems made a copy of selected data tables from the Voyager ILS. This data was transformed into postgres format so that staff in the Cornell Library could reference this legacy data as needed. The historical snapshot is stored on an AWS RDS database instance called "VTEST." The data can be accessed via applications that support postgres data tables, such as the DBeaver reporting application.


Working with data tables on the Voyager Historical Data Snapshot requires specialized skills. Rather than accessing the system directly, most users may find it easier to make a request for a report that contains historical data from the legacy system, Voyager. If you would like the reporting team to generate a report using Voyager Historical data for you, please submit a request through the Requesting Reporting Help form. 


If you are comfortable writing SQL queries against Voyager tables, you may request access to VTEST through the Requesting Reporting Help form.


Getting an Account on VTEST

These are instructions for connecting to and using the Voyager Historical Snapshot reporting database which includes select data tables from the Cornell Library Voyager database system frozen in June 2021, just prior to the cutover to the CUL FOLIO system. The Voyager Legacy snapshot database is on RDS (Reporting Database Service) under AWS (Amazon Web Services) and is maintained by the Library Systems department. Please note that the configurations below do not work with the Virtual DBeaver web-based reporting environment.


Connecting to VTEST from the Library Subnet

If you are connecting from a computer on a library subnet that is not on VPN (like you are sitting at your desk in Olin or remoting into a machine that is on a library subnet) use the hostname voyager-legacy-rds.library.cornell.edu. 


Connecting to VTEST from VPN  

If you are using VPN, connect using the hostname voyager-legacy-rds.internal.library.cornell.edu 





  • No labels