Home Services Partners Company
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

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Read next Connect Microsoft Power BI to OpenEdge via ODBC Driver
Comments are disabled in preview mode.