Qlik > Case Studies > Gold Client drives Colmobil’s critical enterprise data initiative to ROI success

Gold Client drives Colmobil’s critical enterprise data initiative to ROI success

Company Size

1,000+

Region

Asia

Country

Israel

Product

Gold Client Solutions
Data Echo
Data Recast
Data Wave

Tech Stack

SAP
SAP ERP
SAP CRM
SAP BW

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Cost Savings
Productivity Improvements

Technology Category

Analytics & Modeling - Data-as-a-Service
Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Automotive

Applicable Functions

Discrete Manufacturing
Logistics & Transportation

Use Cases

Manufacturing System Automation
Supply Chain Visibility

Services

Software Design & Engineering Services
System Integration

About The Customer

Colmobil is Israel’s largest importer and distributor of passenger and commercial vehicles, trucks, and buses, and provides spare part logistics services. It is the sole distributor of Mercedes-Benz, Hyundai Motors, Mitsubishi Motors, and Smart. As part of the business, Colmobil has seven major vehicle service centers, a trade-in subsidiary, a large insurance agency and a leasing and financing subsidiary. The company operates a fully-computerized logistics center and distribution network, supplying over 75 service workshops each day. All operations run on an SAP platform.

The Challenge

Colmobil, Israel's largest importer and distributor of vehicles, was executing several SAP projects in parallel across the company’s SAP landscape. This included migrating two subsidiaries’ legacy systems to SAP, which required updating testing environments to develop new business logic and properly connect all the data. However, creating a new system or refreshing an existing one with updated data for a new project was extremely time-consuming. It could take up to a week of intensive work to complete these tasks. As a result, teams always questioned whether it was worth creating a fresh system or whether they could risk working on an outdated one. Dependence on the Basis team created bottlenecks. The Application team had to rely on the Basis team to refresh a QA or Dev environment. Bottlenecks inevitably led to long lead times to create new environments. It was difficult to recreate erroneous events or research bugs. Discrepancies between the production environment and Dev or QA limited the company’s ability to address issues when they arose. Issues usually appeared in the newest customizations or development work, where the gap between production and Dev or QA existed.

The Solution

Colmobil explored several different solutions to refresh the QA and Dev system data. Xact-Soft, a leading consulting company focused on SAP Technologies, introduced the Colmobil team to Attunity. They learned that Attunity Gold Client Solutions offered functionality across all the SAP components in Colmobil’s landscape. In addition, that functionality was superior to all the other solutions that Colmobil had evaluated and provided the best long-term return on investment. The team appreciated that Attunity Gold Client Solutions was a quick and flexible tool that SAP functional users or developers could use to get small, up-to-date subsets of relevant data. This would save time, labor and storage space. Another key feature was data security. Colmobil liked that sensitive data could be scrambled and deleted immediately after testing without compromising the QA environment’s data integrity. The team knew they needed Attunity Gold Client Solutions when they realized that the offering would make data refreshes a non-issue and would eliminate the dependency on the Basis team.

Operational Impact

Teams can solve more problems and execute more projects simultaneously with less worry about systems and data issues.
Work now gets done more easily, faster, and more accurately.
Using Attunity Gold Client Solutions, Colmobil’s SAP team can quickly select and copy subsets of only the relevant data needed from production or non-production sources to non-production targets for Dev and QA work.
The team particularly likes that the data is replicated with all the relevant information, exactly as it exists in the source, allowing them to create smaller, fully-functional clients.
This allows efficient troubleshooting of production problems outside the production environment.

Quantitative Benefit