CHG Healthcare Services is the nation’s largest privately held healthcare staffing company, providing recruitment, temporary placement and permanent employment of health professionals in all fifty states as well as internationally.
Like many companies that have been operating for decades, CHG Healthcare found itself with different generations of IT and data warehouse solutions. Moving data to and from modern cloud-based CRM platforms to local SQL- based data warehouses and even into, and out of, legacy AS/400 servers was proving to be a growing challenge.
“When we started working with Salesforce we realized we needed an integration process because we had a backend process that we ran on an AS/400, which was really an old application,” says Steven Keiser, a CHG Healthcare Services Engineering Manager. “We had actually worked on building the integration ourselves and it was just taking a really long time.”
After spending countless hours on an internal software solution, CHG Healthcare turned to Silicon-Valley based Sesame Software and its Relational Junction suite of replication, recovery and integration tools.
“Rather than having to write the Java code for the integration–to reach out and call the Salesforce APIs to download into the database–we were able to use Relational Junction,” Keiser says. “Without having to write any code, Relational Junction quickly speeded up our integration.”
Keiser explains Relational Junction now pulls the information from Salesforce to the local SQL database and then from the local SQL database to the AS/400 database.
“Using Relational Junction, we were able to download the data into the SQL servers and then set up what we call ‘getters and setters’ to get data to and from the SQL server and the AS/400 database in a bi-directional flow,” he says.
Keiser estimated that as many as 1,000 employees across the country are now using reports generated from that integrated data.
He adds that CHG Healthcare continues to rely on Relational Junction for integration, adding that the company is also benefiting from the veteran support team behind Relational Junction. “The support from Sesame Software has always been ready anytime we need help,” Keiser says.
“Rather than having to write the Java code for the integration–to reach out and call the Salesforce APIs to download into the database–we were able to use Relational Junction. Without having to write any Java code, Relational Junction; quickly speeded up our integration.”
– Steven Keiser, a CHG Healthcare Services Engineering Manager
Founded in 1979, CHG Healthcare is a leader in healthcare staffing and is the nation’s largest provider of locum tenens services. CHG prides itself on having a values-driven culture that focuses on Putting People First. The company is known for its award-winning culture and benefits and has been named one of Fortune magazine’s “100 Best Companies to Work For” each of the past nine years.