The university admission process included a lot of document management routines. The department needed to pull the online applications from Dynamics CRM and transfer the data into the dedicated internal system for further processing. At some stage, the admission office had to export all PDFs manually and then upload them into the document management system, every day.
After searching on the Internet, the IT team of Viterbo University chose Devart’s product – ODBC Driver for Dynamics 365. The primary reason was the overall user-friendliness of this solution – it is easy to install, connect, query, and extract the data.
The company uses Devart ODBC Driver for Dynamics 365 to pull data from the Microsoft Dynamics CRM and then push it into the Document Management System for the university applications, letters of recommendations, signups for on-campus visits, and supplemental items for the application. This ODBC driver ensures a secure connection, which is a requirement for the university data handling procedures.
They use both the local ODBC connection for development and the server connection for the SSIS – SQL Server Integration Services package that runs automatically to pull data. As a result, the manual operations that demanded a lot of human operators’ time and concentration became automated. This allowed the company to save time and effort significantly, focusing on more essential jobs instead.