Rhode Island College is seeking a vendor to collaborate with us on our Data Infrastructure Enhancement/Decision Support System project. The primary goals of this partnership are to: • Develop SSIS integration to enable our new reporting database to deliver both live and static data. Some static data has been loaded but will need to be refreshed. o These are frozen views used for reporting purposes like enrollment head count and degrees awarded. o Also needed are periodic (sometimes daily) refreshes of existing tables from PeopleSoft (student information system). o There are currently 12 to 15 tables containing biodemographic data, enrollment data and admissions data. o There are no existing custom scripts or workflows in PeopleSoft that will need to be integrated or replaced during the SSIS development process. • Design and implement SSIS jobs for transferring data from PeopleSoft to the reporting database. • Ensure timely and reliable data transfers on a daily to weekly basis, handling file volumes from a few thousand to tens of thousands of rows with high performance, scalability, and data integrity. • Ensure the SSIS integration partner provides knowledge transfer and documentation to the relevant ITS staff, equipping them to maintain the integration in the future. The documentation should be detailed enough to allow ITS staff to be able to pull additional tables from PeopleSoft and continue to develop/modify the SSIS integrations as needed.
