CASE STUDY 05
- Professional
- Data Engineering
Cutting 45 minutes to 4
Optimising a process from SQL Server to the OpenFlex CRM.
Tressol-Chabrier · Work-study placement
The project, step by step
−91%processing time per run
- 01
SQL Server
The source data
- 02
Automate the transfer
An optimised process
- 03
OpenFlex CRM
Data transferred to the business tool
Context
Automation of a process linking SQL Server to the OpenFlex CRM at Tressol-Chabrier.
Problem
Reduce the initial processing time of 45 minutes per run.
Data
Data transferred from SQL Server to OpenFlex. Its nature and volume remain to be specified.
Approach
I optimised the automated process between SQL Server and the OpenFlex CRM.
Method
The technical changes behind the optimisation are not detailed in the available information.
Results
Processing time was reduced from 45 to 4 minutes per run, a 91% reduction.
Technologies
SQL Server and OpenFlex CRM.
Lessons and limitations
The improvement relates to this specific automation. The bottlenecks identified and measurement conditions remain to be documented.