Following its move to the cloud, the Pacer Group looked to Progress® DataDirect® for its data integration needs.
Swiatkowski will be the first to tell you, “I’m not a programmer.” But in just a couple of months, he was able to set up DataDirect and use it to create time- and money-saving solutions for both Pacer Group and its customers.
It was a matter of getting “behind the user interface” of the cloud-based products in his configuration. Among the solutions were Salesforce and Rootstock along with Microsoft’s SQL Server. And although these products were all benefiting the company for various reasons, Swiatkowski felt blocked by the limited access to raw data with these tools. “If I could just get to the data,” he kept saying. “That’s how we’d be able to quickly produce labels and barcodes for the nearly 4,000 products in our inventory.”
DataDirect functionality gives Swiatkowski and the others at Pacer Group the ability to access data and use it in whatever way they choose. This year they use it for labels and barcodes, next year perhaps something else. The access to the raw data is what’s really exciting to someone like Swiatkowski. He recalls, “When I found your product, it was like gold.”
Customers get what they need—an easy-to-understand labeling system, so when they receive products they can get them into the system quickly.
There were other benefits to accessing product data using DataDirect.
“The problem with cloud solutions is they’re not that fast,” Swiatkowski says. “Some have limits on the amount of queries you can run at one time and the amount of throughput you can use.
“If we’re sitting with a customer and have 20 to 30 items that we need to process, there’s a latency issue,” he adds. “In some cases, you don’t want to wait five minutes to produce a report or a barcode packing slip for a customer.”
With DataDirect, Swiatkowski was able to get all the data out of his Microsoft Access databases and link it with his atomic systems and ERP systems to expedite label production, making life better for his customers.