As a part of the business process, Alhena receives the lists of leads, which should be contacted, on a daily basis from their customers - car dealerships of such well-known brands as Renault, Volkswagen, Fiat, Peugeot, etc. Every dealership may use its own data format, and all these lists must go to the Alhena's internally used CRM system – Salesforce.
While importing each list takes just 10 minutes, having multiple lists from various dealerships incoming, sometimes, every day from every dealership, makes this task rather time-consuming and increases probability of human errors. Besides, the data from different systems of different dealerships must be unified for import. So Alhena decided that this process definitely needed automation, and they needed a powerful ETL tool for it.
The main challenge is that every car manufacturer has its own system, so Renault has own system, Peugeot has own system, and so on, and before plugging the data to our system we need somehow to bring some clearance in terms of format, in terms of data structure, so it fits our system. That is why we needed to have an ETL."