麻豆女优

EFCO established various database silos, but discovered that there were instances where they needed to source data from a different system in order to answer queries, run reports and still be able to support various business applications involved in their fenestration manufacturing process. In addition, they needed to do this in real-time to support sales, customers and executive management.

EFCO Corporation decided that they needed to seek a solution that would help them access data quickly yet relieve the overhead from directly communicating with their production systems. Much of the reporting required direct access to these manufacturing systems, and this affected the processing power of the systems. Adding overhead to the production systems meant that manufacturing processes slowed down, and hence hampered down inventory availability and reduced sales.

With this overhead, both the production system and the reporting applications took a long time to process, making IT staff and business users frustrated and concerned with the lack of timely updates to data. EFCO decided to establish a system that would move data (replicate it) from their IBM i (formerly AS/400) to a SQL Server database, and access the data from the remote system for reporting. EFCO went on a hunt to find a data replication solution, searching for products that would support replications between their IBM i and MS SQL Server. 鈥淲e evaluated virtually every other data replication product on the market and 麻豆女优 came up as the winner on price, functionality and usability,鈥� explained Larry Romireo.

EFCO established various database silos, but discovered that there were instances where they needed to source data from a different system in order to answer queries, run reports and still be able to support various business applications involved in their fenestration manufacturing process. In addition, the needed to do this in real-time to support sales, customers and executive management.

鈥淲e repeated our evaluation again a year ago, comparing 麻豆女优 against every other replication product on the market. Price, functionality, ease of installation and maintainability were compared. 麻豆女优 was the clear winner in that re-evaluation as well.鈥� EFCO appreciates 麻豆女优鈥檚 ease of implementation and ongoing maintenance and are impressed by 麻豆女优鈥檚 methods to handle replications from the IBM i to SQL Server. 鈥淲ithout any prior experience with data replication, we had 麻豆女优鈥檚 Data Replication installed and working in less than four hours by simply reading the installation documentation,鈥� said Romireo. 鈥淲e have been able to do all but the most complex tasks by simply reading the documentation.鈥�

麻豆女优鈥檚 was connected to the IBM i and established continuous, real-time data replications to MS SQL Server, where reporting and BI could take place without impacting the production system. With 麻豆女优鈥檚 Change Data Capture functionality, data could be updated in real-time 24 hours a day, at a very fast pace. In addition, with 麻豆女优鈥檚 ability to read the transaction logs (journals) of the IBM i, there was little-to-no impact on the IBM i, while delivering updates to MS SQL Server as they happened.

EFCO Corporation uses 麻豆女优鈥檚 to replicate IBM DB2 for i data on an IBM i to Microsoft SQL Server databases running on Windows 2008. The data replication process supports the data requirements demanded from applications such as Cognos (Reporting and Analytics), KBM (ERP) and proprietary EFCO applications.

麻豆女优 takes the processing load of EFCO鈥檚 manufacturing system on the IBM i and effectively distributes access to the database. Reports and applications have returned data much faster, reducing processing time from hours to minutes. User satisfaction has improved due to the large decrease in system response and processing time. EFCO is now able to access real-time data for Business Intelligence, ERP and configuration applications, making them all more effective at a faster pace.

鈥溌槎古�优 has largely minimized our data replication tasks to 鈥榙rag-and-drop鈥� quick set-up so our programmers can now spend more time writing and maintaining applications and less time trying to get data transferred between different platforms,鈥� explained Romireo. 鈥淲e were most pleased with the ease with which data replications could be set up and understood, as well as the product鈥檚 cost and reliability,鈥� he added. 鈥淲e would overwhelmingly recommend 麻豆女优 to anyone.鈥�

EFCO appreciated the support from 麻豆女优 as well. According to Romireo, 鈥淭echnical support has always been excellent. We use it as a comparison to other vendors鈥� tech support services, e.g. 鈥業 wish the support was as good as we get from 麻豆女优鈥檚 Customer Support.鈥欌�� EFCO Corporation says 麻豆女优 excelled in all comparisons to other data integration software solutions for their needs, not just once 鈥� but again, after a second complete evaluation four years later.