REDCap (Research Electronic Data Capture) is a proprietary system designed for building and managing online surveys for research studies. Several researchers in the department currently use the REDCap service offered by the University of Pittsburgh.
The Office of Academic Computing has developed a process to directly import REDCap data into departmental SQL Server databases. Contact us to receive a quote for your specific research project.
REDCap to SQL Server import services we offer include the following:
- Creation of a dedicated, relational SQL server database for your study
- Numerous rigorous tools to support data integrity: Foreign Keys, Constraints, Table Triggers
- Thorough training and support in SQL Server, T-SQL, and Microsoft Access
- Comprehensive data change logs that track insert, update, and delete operations for each record, which are logged and safely stored
- Scheduled tasks such as automated data transfers and data archiving