Accurate data for improved reporting and decision making

Pervasive’s integration solution allows us to merge all the data despite its location into a centralized repository for more in-depth reports.

Automation

The automation reduces the risk for human error and saves Patient Care valuable time and resources.

Professional support

The company has high praise for Pervasive personnel, especially its dedicated account executive who provided tremendous assistance.

Printable Format

Home health company connects legacy systems to CRM with Pervasive Data Integrator

Patient Care, one of the largest privately held home health companies in the U.S., wanted to achieve comprehensive business intelligence and reporting by creating a data warehouse and needed a way to link data from disparate sources. It chose Pervasive Data Integrator to connect its legacy systems and its online Customer Relationship Management (CRM) system into a central database in order to enable this. With a timeframe of less than two weeks, Pervasive was able to offer a scalable, affordable solution that was easy to implement and use. Management at Patient Care now receives accurate, comprehensive reports faster, enabling them to make critical business decisions with confidence.

To merge data for better business overview

Patient Care had critical data housed on its legacy systems and its online CRM, Salesforce, but didn’t have a tool to efficiently merge all of the data together. Data was segregated among its five servers without a central repository necessitating the time-consuming task of logging on to each server to extract data and manually loading that data into other applications. Gaining a complete overview for business intelligence was virtually impossible.

A tough deadline

The decision was made to implement a reliable solution that would enable Patient Care to extract data from Salesforce and legacy systems into a single data warehouse for an aggregated view of information for better decision-making capabilities. With a tight timeframe and hundreds of reports to be generated, Patient Care needed a quick, affordable and dependable solution that would be easy to implement and use.

Pervasive value: affordability, great support and scalability

Patient Care investigated several solutions and chose Pervasive to help with its project. “Pervasive offered us the most value by giving us an affordable tool to meet our needs, coupled with great support,” explains Kaitlin Kossakowski, database administrator at Patient Care. “Pervasive was able to implement the solution within our internal deadline and showed us ways to automate many of our operations, saving us time in the long run as well.”

During the rapid trial period, select Patient Care staff were introduced to Pervasive Data Integrator through a Web-based demonstration that allowed them to see its capabilities and experiment with its functionality firsthand. According to Kossakowski, “It took only a couple of hours for Patient Care to install the Pervasive software, and data transfers were initiated that same day. Queries were written and reports were being generated within a day.”

Ms. Kossakowski found the ease of use was a powerful, positive surprise. Pervasive enables Patient Care to move data between Salesforce, its data warehouse, and home healthcare software. The scalability of Pervasive also gives Patient Care the capability to easily and automatically run standard management reports by extracting data directly into spreadsheets. The automation reduces the risk for human error and saves Patient Care valuable time and resources.

Better reporting comes with Pervasive integration; Queries now easily written

Patient Care runs several reports overnight and others are refreshed every few hours, around the clock. Queries that used to take up to a full day to write, now only take 30 minutes, thanks to Pervasive Integration. Further, updates, edits or additions to reports no longer require laborious rewriting of the query. Because the Pervasive solution is automated and event-driven, it allows Patient Care to make changes to single fields in a query rather than rewriting the entire script. “We have complex reports requiring data from multiple sources,” explains Kossakowski. “Pervasive’s integration solution allows us to merge all the data despite its location into a centralized repository for more in-depth reports. These reports are the foundation of many of the business decisions made at Patient Care. The faster and more accurately we can generate a report for management, the faster they can make critical business decisions. It’s that simple.”

The sales and technical support that Patient Care has received from Pervasive has impressed Kossakowski and others at the company. “Our programmers and technical staff were pleased with the fast and easy implementation and are confident that Pervasive’s integration solution is powerful enough to do what we need it to do. We appreciate having a dedicated Pervasive sales executive who delivered what was promised and who was always there for us during the trial version.”

Fast, accurate data integration speeds better decision making

Patient Care to make changes to single fields in a query rather than rewriting the entire script. Pervasive  allows the company to merge all its data despite its location into a centralized repository for more in-depth reports. The faster and more accurately Patient Care can generate a report for management, the faster they can make critical business decisions.