いくかのETL製品を検討しましたが、限りある予算の中で、オープンソースソフトウェアである Talend Open Studio をダウンロードして試してみる事にしました。驚いたことに、基幹系システムとパッケージソフトがその日の内に接続できてしまったのです。これは大きなインパクトでした。情報システム室, 主事
Occupies over half of worldwide market share of the small direct current electric motors
Mabuchi Motor Company Limited is a large Japanese manufacturer of electronics parts which owns over half of worldwide market share of the small DC Electric Motors. Its products work behind the scenes as important components in a multitude of electronic equipment for Automotive Products such as door miler and door lock, Audio & Visual Equipment such as CD/DVD, Optical and Precision Instruments such as Printers and Digital Cameras. Mabuchi's products are essential and supporting today's High-Tech Industrial market. Mabuchi is a global company and manufactures 100% of its products in factories in varieties of Asian countries.
Mabuchi Motor has been maintaining and enhancing its in-house Production Core System (AS/400) which was implemented more than a decade ago. According to the increasing complexity of the internal structure, more dedicated skill was required to add new features to the Production Core System. Number of independent systems employed by individual departments tended to increase, because the emerging business requirements were unable to be absorbed by the existing Production Core System. IT Department of Mabuchi tried to understand and take over such departmental systems as much as possible for the future maintenance purpose, however, those systems were beginning to be "black box" and the enterprise data began to be scattered. Furthermore, interfacing requirement between the Production Core System and newly hired software packages aim to substitute part of the features of the Production Core System, were emerging.
Discovery of Talend Open Studio for Data Integration
"I discovered Talend Open Studio for Data Integration after we started implementation of the BOM Management software package. Parts-List Management function on the Production Core System was already reached to its limit. We tried to pre-process the parts database extracted from BOM Management System, and we realized that ETL function connecting it to the Production Core System was mandatory," said Mr. Jin Nozawa, IT Department of Mabuchi Motor, "I decided to download and deploy Talend Open Studio for Data Integration chosen among several alternative ETL products, due to our limited budget and resources. It was really amazing that I could connect the Production Core System and the package system using Talend Open Studio for Data Integration in the same day I downloaded it. It was really a great impact."
It was 2007 when Mabuchi Motor down loaded the Talend Open Studio for Data Integration from Talend's website and it was only one year after its official release. Few Japanese companies intended to deploy Open Source Software to their production environment at that time, thus Mr. Nozawa recalled, "I was really wondering if we can support Talend Open Studio for Data Integration by ourselves, cope with system failure, or no idea how we shall keep dealing with it if Talend stopped product enhancement." However, he confessed the reason he adopted Talend Solution, "Talend Open Studio for Data Integration is not an "ETL Engine" like other vendors solutions, but it is a "Java Code Generator", so we are sure to control and respond to unexpected matters at any time."
Expanding range of application
Currently, over 30 jobs are operational based on Talend Open Studio for Data Integration, including; daily data transformation of 95,000 articles / 1,800,000 components from BOM Management System to the Production Core System, monthly 300,000 transaction transformation from the Production Management System to the Production Core System, data mining/presentation feature on the Production Management System, and so on.
Mr. Nozawa sets a high valuation on Talend Open Studio for Data Integration, "Only 20 seconds is required to complete search and extract about 3,000 records from about 1,250,000 transactions in the Production Management System which took more than 5 minutes in the past. Moreover, the old system unexpectedly extracted more than 100,000 records and it might not be loaded into a spreadsheet, while Talend Open Studio for Data Integration solved this issue since it can find and de-duplicate data."
The value of Talend Open Studio for Data Integration
Adding to the above, Mr. Nozawa pointed out the value of Talend Open Studio for Data Integration as follows:
- About 500 components are available without fee and user can add/create own component if no relevant component is found (rare case, though).
- Automatically capture the data schema of existing database.
- Visual development environment allows you to develop jobs with minimum Java knowledge. Productivity is extremely high. You can play with it within 5 minutes.
- Since deliverables are Java source code, Batch and sh files, they are analyzable, amendable, and easily transferrable to and executable at other environments as well.
Mabuchi Motor is now evaluating Talend Enterprise Data Integration, the subscription version of Talend Enterprise Data Integration, aiming at expanding the deployment of Talend Solutions and more enhancement of development and maintenance productivity of the support team.