FANCL continues to grow as a cosmetics and health food manufacturer, consistently managing everything from research to manufacturing, sales, and customer support. data integration platform that connects various systems plays a vital role in supporting the company's wide-ranging product development and sales strategies. Aiming to standardize this, the company adopted "DataSpider International" and "DataMagic." This has strengthened management and control of the entire platform, reducing development and operation man-hours by more than 50%. It has also enabled the company to respond more quickly to requests from business divisions, speeding up business operations.
Information Systems Department
Corporate Systems Group
Mr. Yumasa Yamanashi
assignment
- Individually optimized data integration leads to a mixture of different communication formats
- It is difficult to grasp the overall picture because an ETL tool is introduced for each individual system and an interface is created.
- Development and maintenance investigations take time, and costs and operational burdens remain high.
Key points of the solution
To break this "negative cycle," we revamped our data conversion tools, standardized our data integration platform, and strengthened overall management and control.
- For complex and difficult interfaces, use the highly functional and flexible "DataSpider International"
- "DataMagic" has a relatively simple and easy-to-use interface.
Communication between systems is unified with HULFT, and data conversion processing is performed using DataSpider International or DataMagic depending on the application.
All job management is done with JP1. By adopting DataSpider International and DataMagic as data conversion tools, the entire platform has become more standardized.
Not only did this make development and operation easier, but it also strengthened management and control.
FANCL Corporation
- Head office: 89-1 Yamashitacho, Naka-ku, Yokohama
- Established: August 18, 1981
- Capital: 10,795 million yen
- Number of employees: 703 (as of March 31, 2016)
- Business description: Developing a health food business that offers additive-free cosmetics, supplements, and other products through an integrated system from research and development to manufacturing and sales. They offer a number of innovative products, including "Mild Cleansing Oil," which sells one bottle every five seconds, and "Enkin," Japan's first functional food, an eye care supplement that focuses on the ability to focus on close objects.
- The content of this case study is current as of the time of the interview. The content of this case study may change without notice.