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 any application that supports postgres data tables, such as the DBeaver reporting application. Cornell Library staff members who would like access to to the Voyager historical snapshot legacy "VTEST" database may submit a request for an account and connect to this system using the instructions below.
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.
- Host: voyager-legacy-rds.library.cornell.edu
- Database: vtest
- Username: your NetID
- Password: sent to you by Library Systems
- SSL: Use SSL checked
- SSL Mode: prefer
Connecting from VPN
If you are using VPN, connect using the hostname voyager-legacy-rds.internal.library.cornell.edu
- Host: voyager-legacy-rds.internal.library.cornell.edu
- Database: vtest
- Username: your NetID
- Password: sent to you by Library Systems
- SSL: Use SSL checked
- SSL Mode: prefer