Challenge
The client’s data ecosystem includes Salesforce CRM for data storing and management and a Salesforce Marketing Cloud where all the communication is happening. Since the beginning, the organization collected a huge amount of data, and it became too expensive to store all the data in Salesforce CRM. They also faced some performance issues and were looking forward to finding the solution for cost-effective data storage, management and analytics.
At the beginning of the project, all data was supposed to be stored in Salesforce, but some critical problems arose then - Data Storage in Salesforce was very expensive and the general performance of Salesforce for huge quantities of data is not very good. We decided to store a relatively small quantity of data in Salesforce (3 years + current year), and the rest to replicate to Amazon Redshift for storage and analysis."