When data is being collected from multiple touchpoints and in different formats, the data transformation process can be tedious, expensive, and time-consuming.
Retailer X, a world leader in luxury retail faced exactly this problem. With a wide range of products in clothing, leather goods, shoes, perfumes, cosmetics, watches and jewelry, Retailer X operates over 500 retail outlets around the world and processes thousands of credit card transactions on a daily basis.
However, they were unable to integrate the incoming data to a single format -- in real time -- without external technical support
Web Application for Insurance Company
Here’s how CloudNow’s solutions benefited Retailer X
Data Transformation Costs
Retailer X was in need of a solution that would help them to compile, convert and upload data from business transactions made through credit cards at various touch points across the world - in real time. A typical ETL solution provisions such a data transformation only in batches.
The incoming data was, by and large, received in the CSV format from the payment processor. For the account reconciliation process, Retailer X was using Cybersource -- and this platform requires files to be uploaded in the XML format.
Through the use of CloudNow’s proprietary iPaaS, Data Prime, we were able to provide Retailer X with the ability to integrate incoming files from all retail locations around the world into the format required. The entire process of data transformation was automated, so that they could be processed continuously, and without any delay.
Typically, most ETL solutions are technology heavy and not very user-friendly when it comes to non-technical users. The handling of exceptions, in such solutions, requires code-level action and IT intervention.
Retailer X, however, needed such a solution wherein exceptions could be handled by business analysts - with their understanding of the business logic, a business analyst would be better placed to address integration exceptions at a lower cost, without the additional expense of an additional IT resource.
CloudNow provided training to business analysts at the enterprise in such a way that they could apply their knowledge of the required business logic to handle exceptions seamlessly. Moreover, functionalities like substrings, simple defaulting, truncation, and changes mapping were enabled for effective exception handling.
In the process, the need for an IT developer to handle ETL exceptions has been completely eliminated.
CloudNow helped Retailer X handle the real-time transformation of data using Data Prime, our highly customizable, proprietary iPaaS solution.
What’s more, with its service-oriented architecture (SOA), Data Prime offered a platform which made sharing, development and delivery more efficient and user-friendly.