The Progress® DataDirect® solution gave the CoffingDW team the functionality they’d been looking for.
Tom Coffing says it was either the DataDirect platform or nothing. “We talked to some of our Teradata counterparts and they said listen, you want to move data between Oracle, SQL Server and Teradata with the press of a button, DataDirect is the only way to do that.”
“Performance was huge for us,” says Coffing. To realize the dream of Nexus Query Chameleon, the CoffingDW team needed a solution for connection, security and rapid data movement. “To make all systems look like one, those DataDirect drivers make that possible.”
Not only was the DataDirect solution the only one of its kind, it enabled the Nexus Query Chameleon to function like nothing in history. When the CoffingDW team showed their solution to top cloud providers, the audience was in disbelief. “They said, that’s not possible,” recalls Coffing. “We said, well you’re seeing it,”
With DataDirect integration, Nexus Query Chameleon was able to do joins between Teradata, Oracle and
SQL Server.
The solution was 15 years in the making, but it only took two weeks to deploy the final piece of the puzzle, the DataDirect solution. “It just happened like magic,” explains Coffing. “And we were able to move data so unbelievably fast.”