遗留系统到 ERP 的数据迁移解决方案
技术
- 应用基础设施与中间件 - 数据交换与集成
- 功能应用 - 企业资源规划系统 (ERP)
适用功能
- 质量保证
用例
- 人员跟踪与监控
- 视觉质量检测
服务
- 系统集成
- 测试与认证
关于客户
一家主要的金融和租赁提供商，其遗留系统包括 Microsoft Dynamics NAV（以前称为 Navision）和 Target。
挑战
该公司需要处理超过 2700 万条记录，需要解决主要问题——由于许多交叉因素导致管理成本增加。首先，客户记录等大量重复数据影响业务运营。由于流程最初的组织方式，一些条目包含在两个系统中，因此需要它们同时运行。这导致处理速度变慢并需要增加人员。此外，关键数据资产的日常管理经常遇到遗留系统、平台和数据库之间的兼容性问题。
解决方案
根据公司的要求，我们开发了详细的数据迁移解决方案，可以迁移所有数据，并整合重复记录并更新和清除过时或有缺陷的数据。此外，我们确保该项目在过渡期间对业务造成的影响最小。
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.
Case Study
Goldcorp: Internet of Things Enables the Mine of the Future
Goldcorp is committed to responsible mining practices and maintaining maximum safety for its workers. At the same time, the firm is constantly exploring ways to improve the efficiency of its operations, extend the life of its assets, and control costs. Goldcorp needed technology that can maximize production efficiency by tracking all mining operations, keep employees safe with remote operations and monitoring of hazardous work areas and control production costs through better asset and site management.
Case Study
Rapid and Simple Installation Provides Access to Critical Data
The customer needed to monitor non-contact alignment and non-contact process temperature in different positions along a 100-meter production line. Space around the line is tight and operators and forklift trucks are passing by constantly. Installation of correctly routed cables from sensors back to the control station would have been expensive and would have taken too long and caused too much disruption to ongoing operations.
Case Study
Cisco Kinetic for Oil and Gas: Refineries and Plants
The plant manager and safety teams needed a solution that provided near real-time visibility of gas detection and personnel location, with easy to understand visualization and alerting dashboards. This would enable them to improve productivity through decreasing the time taken to start work, optimize evacuation route planning, and to meet critical staff safety and compliance goals.
Case Study
Digital Transformation of Atlanta Grout & Tile: An IoT Case Study
Atlanta Grout & Tile, a Tile, Stone & Grout restoration company based in Woodstock, Georgia, was facing challenges with its traditional business model. Despite steady growth over the years, the company was falling behind the web revolution and missing out on the opportunity to tap into a new consumer base. They were using independent software from different vendors for each of their department information and workforce management. This resulted in a lot of manual work on excel and the need to export/import data between different systems. This not only increased overhead costs but also slowed down their response to clients. The company also had to prepare numerous reports manually and lacked access to customer trends for effective business decision-making.
Case Study
Industry 4.0 at ALPLA: Enhancing Factory Efficiency with IoT
ALPLA, a global leader in packaging solutions, faced several challenges as the complexity of their production machinery increased. The need for highly trained specialists in each factory led to higher personnel costs, difficulties in recruiting experienced talent at each location, and costly personnel turnover. Furthermore, less experienced operators running the machines sub-optimally impacted resource consumption and overall equipment effectiveness (OEE). ALPLA also faced the challenge of monitoring visual inspection systems in every line of their plants, which was almost impossible to do manually. In 2016, ALPLA decided to use data from the 900 different types of embedded sensors in each factory to address these issues. However, their initial choice of SQL Server as the data store for the sensor data proved inadequate, as it was unable to cope with their data requirements.
Case Study
Real-Time IoT Tracking and Visualization Improve Manufacturing
Shimane Fujitsu, a wholly-owned subsidiary of Fujitsu and a leading manufacturer of business notebooks and tablets, set out to improve processes where factory inspections found product errors. Prioritizing product rework based on shipping date was challenging, and it caused Shimane Fujitsu to incur additional shipping fees. The company needed a way to collect data to better track the location of products in the rework cycle as well as monitor progress in real time. The collected data would also help process analysis for future improvements.
