Built a data warehouse solution in a matter of weeks with Progress OpenEdge Pro2 data replication that enables the development team to create and modify reports in one-third of the time, while providing a replication solution that will meet the organization’s needs moving forward as BRAAS implements a new CRM system.
BRAAS is a large distributor of industrial automation products in the U.S., serving companies worldwide.
For Tim Bloudek, Director of Business Information Systems at BRAAS, keeping ERP data safely isolated yet readily accessible was a challenge. Millions of products, thousands of active customers and a need for near real-time analysis and reporting—that wouldn’t slow down the ERP system—drove Bloudek to seek a data replication solution.
The solution would have to be able to handle the massive data volume, keep information safe and, most importantly, enable the flexibility for Bloudek and his team to work with other data management tools.
Since 1961, BRAAS has been helping customers maintain, automate and improve manufacturing systems across industries ranging from food packaging to bio medical. For Bloudek and the BRAAS team, a smart approach to information management has always been a priority.
“We recognized about a decade ago that we were going to have to be pretty darn good at information,” Bloudek explains. Today, Bloudek’s definition of being “good at information” involves a pretty specific list of tasks. Over time, as processes evolve and change, Bloudek wants information management solutions capable of keeping up. To avoid potential limitations, he sought a solution that would help him get to information more efficiently and effectively and would integrate with third-party tools seamlessly.
Bloudek spent the better part of a year fine-tuning another data warehousing solution before he discovered Progress® OpenEdge® Pro2™ data replication. After nine months, the first solution still wasn’t enabling all of the functionality he was looking for. When he finally gave up on it and moved forward with implementing the OpenEdge Pro2 solution, he was up and running in a matter of weeks.
OpenEdge Pro2 data replication gave Bloudek everything he was looking for, starting with timely information. “Our previous replication solution required us to run a lot of batch loads and we needed information in real time,” he says. The real-time aspect of the replicated OpenEdge Pro2 data, used for reporting, protects the company from potentially expensive transactional errors. “We’ve set up alerts based on real-time information and we can automate searches to find and fix problems before they escalate into significant performance issues,” he explains.
With OpenEdge Pro2, accessing data doesn’t slow ERP performance. Bloudek and his team are able to separate their production environment from their reporting needs and keep data moving quickly and safely. “When we run massive reports, we’re not impacting our ERP system at all,” he says.
After the initial implementation, Bloudek and his team elected to make some adjustments to the solution with the help of the OpenEdge Pro2 support team. “When we needed the help, it was readily available and timely,” Bloudek says.
When it comes to analytics and third-party tools, Bloudek loves the flexibility OpenEdge Pro2 enables. “Pro2 data replication gives us a huge amount of flexibility to use the BI and analytic tools of our choice,” he says. “We’re not locked into any one.”