Educators Resource Increases Speeds 80-90%

Educators Resource Increases Speeds 80-90%

January 13, 2016 0 Comments
Educators Resource Increases Speeds 870x220

When leading a $500 million industry, you don’t have time to wait around. That’s why Educators Resource turned to DataDirect to upgrade their data organization, leading to an 80-90% increase in screen refresh speeds within its key applications.

Educators resourceEducators Resource is North America’s leading wholesale distributor of K-8 supplemental teaching materials, a $500 million market. With clients including some of the country’s largest retailers, they don’t have time to wait around for sluggish software to catch up with their rapid pace of business.

With that in mind, when Educators Resource was looking for a new SQL connectivity solution after moving from their UNIX-based system to Windows Server 2012 with Microsoft SQL Server 2012, they turned to Progress® DataDirect®.

The Challenge

In April 2015, Educators Resource made the decision to move from UNIX to Windows Server 2012 with Microsoft SQL Server 2012. This meant that Colin Stewart, IT Team Leader at Educators Resource, needed to find a good SQL connector.

“We were using the basic SQL client-supplied connectors, but we were having serious performance issues,” he said. XP uses Microsoft Data Access Components (MDACs) to connect to databases, and these components become unusable after some time. “There’s no way to recover MDACs on the XP Service Pack 3, short of reinstalling XP on your system,” said Stewart.

The Solution

The relationship between Progress and Educators Resource began when they purchased our DataDirect connectors to connect their HP UNIX-based ERP system with a legacy Oracle 8 database. Based on that relationship, they knew where to turn after making the move to SQL Server. Educators Resource purchased DataDirect SQL Server ODBC connectors for 50 workstations and implemented them prior to the start of the 2015-16 school year. The connectors create ODBC connections between the SQL database server and the company’s order management and warehouse management systems, which are used to track and maintain all inventory and purchasing data, manage and handle customer sales orders and perform accounting functions, among other business-critical tasks.

Although alternative options were considered, the value and easy implementation of the Progress solution made the choice easy. According to Stewart, “Progress provided a good per-license quote and the right technology. We also liked having direct access to a Progress engineer to help our staff tweak the solution and get things working optimally.”

Implementation took only one day. “You simply install the DataDirect connector on the endpoints and create the ODBC connection,” Stewart said. “It’s fast and easy.”

The Results

The results of the migration have been significant, thanks to the help of the Progress DataDirect. Stewart’s team has noticed an 80-90 percent increase in screen refresh speeds within one of its key applications.

“We have a screen that is part of the purchasing process containing all information a buyer needs to complete the work,” said Stewart. “Prior to implementing Progress DataDirect, the screen would take up to six minutes to refresh. Now, the same screen loads within 1-6 seconds. This enables our users to be far more productive and efficient, and reduces frustration.”

Simply upgrading the legacy ERP has increased reporting efficiency, but Progress DataDirect pushes speedups to new levels. “The new SQL database is super-fast,” said Stewart. “For example, pulling shipping and tracking numbers to generate reports for a customer used to take about 45 minutes; now we can run the report in about a minute. Our main ERP is just a simple GUI that runs on the client side, but most of the work is handled on the backend over an ODBC connection—DataDirect has really sped it up,” said Stewart.

Stewart said adopting the DataDirect connectors was a much faster, more economical solution than building a solution from scratch. “We probably saved at least 12 months in development time using DataDirect,” he said. “In man-hours and general aggravation, I’d say we save close to $25K per year, considering it takes someone just 10 percent of the time to do their work.” By providing such efficiency and time savings, the image of Stewart’s team among sales reps has improved significantly.

Stewart said his team will be looking into connecting the SQL database to its SAP BI system over the next year, and will likely turn to Progress for help with that project, as well.

Your Turn

To see what DataDirect can do for you and replicate the success of Educators Resource in your own organization, contact us or grab a free trial of our DataDirect connectors today!

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments
Comments are disabled in preview mode.
Topics
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
232x131_resourceimage
Getting Ahead of the Hybrid Data Curve
Read More
 
autonomousrest
Creating Quick, Codeless Connectivity with Autonomous REST Connector
Read More
 
whats-new-thumb_210x120
What’s New in OpenEdge 12.1
Read More