Optimizing Cloud Data Integration between Salesforce and AWS
Kengne, Paul Arol (2025)
2025
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2025052616311
https://urn.fi/URN:NBN:fi:amk-2025052616311
Tiivistelmä
This thesis explores the challenges and opportunities associated with optimizing cloud-based data integration between Salesforce and Amazon Web Services (AWS) within the case company. The goal of this study is to uncover the potential arising from Salesforce and AWS strategic partnership and to propose a cost-effective integration architecture leveraging AWS-native integration tools such as Amazon AppFlow.
This study utilized an action research methodology to explore practical solutions design to decrease IT infrastructure related costs and optimize existing data integration processes. The data collection involved stakeholder interviews, notes from group discussions, and extracts from the established knowledge base within the case company.
The study begins with an analysis of the current data integration practices in the case company, identifying limitations such as reliance on legacy data transfer protocols, fragmented responsibilities across teams, and the underutilization of native integration services offered by major cloud providers today. The theoretical framework focused on the key components and benefits of cloud computing, identifying cloud data integration’s best practice and finally, exploring the potential emerging from native integration capabilities between Salesforce and AWS platforms.
The outcome of this thesis is a proposal for the reference architecture to optimize the data transfer between Salesforce to AWS for archiving purpose. This proposal leverages AWS-native integration tools to reduce complexity, enhance efficiency and scalability. Additionally, it identifies potential cost-saving opportunities for the organization. This initiative aims to reduce complexity, lower maintenance costs, and harness the data transfer potentials in line with the company’s cloud strategy including the continuous cost efficiency of IT infrastructure to ensure competitiveness.
This study utilized an action research methodology to explore practical solutions design to decrease IT infrastructure related costs and optimize existing data integration processes. The data collection involved stakeholder interviews, notes from group discussions, and extracts from the established knowledge base within the case company.
The study begins with an analysis of the current data integration practices in the case company, identifying limitations such as reliance on legacy data transfer protocols, fragmented responsibilities across teams, and the underutilization of native integration services offered by major cloud providers today. The theoretical framework focused on the key components and benefits of cloud computing, identifying cloud data integration’s best practice and finally, exploring the potential emerging from native integration capabilities between Salesforce and AWS platforms.
The outcome of this thesis is a proposal for the reference architecture to optimize the data transfer between Salesforce to AWS for archiving purpose. This proposal leverages AWS-native integration tools to reduce complexity, enhance efficiency and scalability. Additionally, it identifies potential cost-saving opportunities for the organization. This initiative aims to reduce complexity, lower maintenance costs, and harness the data transfer potentials in line with the company’s cloud strategy including the continuous cost efficiency of IT infrastructure to ensure competitiveness.