IDEX
SERVICES
National deployment within Must, a subsidiary of the IDEX group, of the Salesforce Field Service solution. Need to facilitate data migration by setting up an automatic import system managed by an ETL tool.
Industry:
Facility Maintenance
Technology:
Salesforce Sales Cloud, Field Service Cloud, Talend
Duration:
6 Months
NEED
For each contract won, the team gathers all the data from the field: sites, buildings, equipment, types of work, etc. On an Excel file.
These thousands of values must then be injected into Salesforce as quickly as possible. Manually, this work is time-consuming and can cause several injection errors, which cannot be directly identified.
SOLUTION
Design and development on TALEND of a Java application, executable on a virtual machine.
It will be composed of several JOBS: data quality control, integrity control, mapping and injection into Salesforce, error management and success logs.
RESULTS
- Mass injection of new customer contracts (+100,000 records per file)
- Mass data update
- Quality control, data integrity
- Automation of injection at an adjustable
- frequency
