Cremica Case Studies

About

The Cremica Group has established itself as a huge food products conglomerate, leading the food processing business through its range of products, innovative flavours and fillings, it’s internationally certified production facilities, the consistency of its quality, and its unmatched expertise in the industry.

Objective

Cremica manufactures high quality condiments, Indian Gravies/Curries, Tomato Ketchup, Sauces, Sandwich Spreads, Mayonnaise, Sandwich Mayonnaise, Syrups, Toppings, Salad Dressings, Indian Snack dips, Fruit fillings for cakes, pastries, and Desserts for retail and food service customers.

Challenges

Collaboration of data from two different transactional applications, One ERP Navision and BeatRoute CRM Integration using API suite services.
Handling of huge data.

Solutions

Created ETL scripts to fetch the data from both the sources using direct connection with ERP Navision and API services foe CRM BeatRoute database. Transform and dump the data into one database to minimize the data load.