Bangkok-based Olympus (Thailand) Co., Ltd. was established in 1999 as a subsidiary of Olympus Group. Its core businesses are the manufacturing and servicing of medical, industrial, and imaging products. Headquartered in Hong Kong, Olympus Group has seven branches across the Asia-Pacific region
“With Informatica Intelligent Cloud Services, we found a next-generation iPaaS tool that could resolve our data issues.”
Business Needs
- Automate data mappings and integrations from all seven Asia-Pacific branches
- Refresh regional sales data nightly
- Translate common terms into English to facilitate communication among country managers
Challenges
- Enable top management at Hong Kong-based headquarters to easily track sales activity across the Asia-Pacific region
- Avoid hitting timeout limits for transactions in Salesforce when working with large formula fields and roll-up summaries
- Consolidate sales data from seven branches in multiple countries into SAP on a nightly basis
Solutions & Results
- Use Informatica Intelligent Cloud Services, a next-generation iPaaS solution, to power dashboards of sales activity across Asia-Pacific
- Stay within Salesforce CPU limits by using Informatica to summarize data and enforce rules before loading it into Salesforce
- Reduces the time it takes to get regional sales data into SAP, enabling decision-makers to work with fresh data
- Bring sales data from Salesforce and spreadsheets into SAP using Informatica Cloud Data Integration for automated, nightly batch integrations
- Improves timeliness and accuracy of sales tracking, allowing headquarters to take immediate action and better drive strategy
- Overcomes CPU limitations when loading data into Salesforce, avoiding the need to manually truncate and re-load data
Products & Services