With OpenEdge 11.6 now running, Levin is looking forward to a number of enhancements to the organization’s business processes. His first priority is table partitioning.
“As the company’s only DBA, any tools that can help us better organize and improve access to data is huge,” he said. “Given the enormous sizes of our databases, table partitioning will enable us to not only better manage data and improve performance, but simplify access to our SQL and Oracle data warehouses, critical for reporting and analysis.”
Looking further ahead, Levin is considering Progress® OpenEdge® Pro2™ data replication for its ability to securely extract and replicate OpenEdge data in near real-time to SQL and Oracle without impacting the live database.
“We have lag time now in some of our sales and order processing reporting,” Levin said. “We expect Pro2 data replication will greatly enhance the speed and accuracy of those processes, getting business critical data to the people that need it—faster.”
Levin is also looking to continue deploying Progress® OpenEdge® Management to monitor database use in real-time, troubleshooting problems before they occur.
“For more than a decade, we have used OpenEdge Management to monitor CPU, disks, memory and file systems usage,” he said. “The capability to configure alerts and have dashboards to monitor resources safeguards our ability to keep our applications continuously available—and given the amount of data we handle, those capabilities give me one less thing I need to worry about.”
Levin is continually looking ahead of the technology curve, strengthening Alphabroder’s ability to provide expert customer service in the highly-competitive environment it operates in.
“The reliability and simplicity of OpenEdge has enabled us to keep pace with changing technologies and the changing needs of our customers through the years,” Levin said. “And now, with the performance and data management capabilities of Progress OpenEdge 11.6 and the continuous improvement and innovation to our ERP system from FDM4, alphabroder is in an excellent position to maintain and grow its leadership position in the industry.”