Customization of Data Loader CLI improves By and Large execution by enabling the seamless integration of new data into Salesforce and by eliminating redundant information
About the Client
Client is a leading distributor in facility, industrial packaging, and marketing solutions. They delivers expertise in supply chain, category management, forecasting and planning, product use, service and training.
Solution
- Created a validation rule in Salesforce to allow only the orders, which are dated less than two years to get uploaded into Salesforce.
- Analyzed their existing Data Loader CLI and incorporated a new logic to reduce the load and delete old data.
- Modified the query in Data Loader CLI and used a formula field which identified the date of the orders
- Placed a restriction on Salesforce and data Loader CLI query to limit the number of records being uploaded and deleted.
Benefits
- Reduced batch processing time by 50%.
- No recurring failures.
- Overall application performance improved by 40%.
- Storage space maintained at optimum level by prescheduled data deletion process
Salesforce: Sales Cloud
Technologies: Dataloader CLI, Manufactring, Packaging solutions