SFTP Integration Method – An Option to Consider in SAP ERP Integration Projects
  IJCTT-book-cover
 		          
 
© 2024 by IJCTT Journal
Volume-72 Issue-8
Year of Publication : 2024
Authors : Shyam Patel,Vishal Palaskar
DOI :  10.14445/22312803/IJCTT-V72I8P129

How to Cite?

Shyam Patel,Vishal Palaskar, "SFTP Integration Method – An Option to Consider in SAP ERP Integration Projects ," International Journal of Computer Trends and Technology, vol. 72, no. 8, pp. 203-207, 2024. Crossref, https://doi.org/10.14445/22312803/IJCTT-V72I8P129

Abstract
Purpose: Systems Integration is most important in today’s competitive world to ensure that all systems work together in harmony to boost productivity and enhance the quality of day-to-day operations. The goal of system integration is to streamline and simplify communication between not only the organization’s internal systems but also the third parties the organization works with. System integration helps accelerate the outflow of information and cut back on operational costs. [1] [16]. This research paper aims to assist organizations in making informed decisions regarding the adoption of Secure Shell File Transfer Protocol (SFTP) as an integration method in SAP (Systems, Applications and Products in Data Processing) ERP application when it comes to the transfer of data between two applications through an untrusted network, as opposed to navigating through multiple integration layer. The exchange of data should always be done securely; once it leaves one application and until it reaches another application, itshould be humanly unreadable, and this is where SFTP plays a significant role. The most common use case for the SFTP integration method in SAP ERP is when transferring bank information, accounts receivable data, accounts payable data, and customer or Vendor information. Data transfer through to the SFTP server is most common nowadays, in most cases, in integration, thus helping big organizations eliminate data breach risk. In this paper, an analysis of SFTP and its value when it comes to integration with SAP ERP or any other ERPs will prove to be a hidden gem for companies considering this method as a mode of integration. This paper will also give a different view on how companies can enable integration with SFTP servers by eliminating dependency on middleware or third-party FTP clients. It will also help companies be more sustainable by significantly reducing their carbon footprint. Fewer applications involved means fewer resources consumed. Data is the new oil, and when transferred securely, it can provide a company with a competitive advantage in making crucial decisions.[7]. Design/Methodology/Approach: This study is based on the author's own experience, having worked on 4 major ERP implementations and upgrades and worked on multiple integration projects, with each project having different flavors of integration approach depending on 3rd party application limitations or following best practices. Here, the primary focus is on SFTP, a secure file transfer protocol, which is one of the many ways in which SAP ERP can be integrated. The communication between client and server is encrypted, and authentication is based on passwords or public/private key authentication. Findings: Project management and its approach from the initial discussion play a crucial role in determining an approach to integration, especially when it comes to SFTP integration between client and server. The lack of an appropriate culture and organizational readiness, not adopting new methods or doing enough research on capabilities, and insufficient support from third-party applications are the primary reasons SFTP integrations end up going through multiple applications, such as middleware, before landing in end-client applications instead of having point to point connections. Research Limitations/Implications: The data analyzed is from secondary sources published in the press. Secondary reporting could increase objectivity; however, the weakness is that not all the factors might have been reported. Originality/Value: This paper identifies factors critical to the success of enabling SFTP integration between SAP and 3rd party clients without involving middleware or 3rd Party SFTP tools such as FileZilla or WINSCP.

Keywords
SAP ERP, Systems, Applications, and Products in data processing, SFTP, Secure file transfer protocol, SSH, IETF, SFTP client.

Reference

[1] Ben Spicer, SAP Integration Made Easy with MuleSoft Accelerator for SAP, MuleSoft Blog, 2021. [Online]. Available: https://blogs.mulesoft.com/dev-guides/api-connectors-templates/sap-integration-accelerator/
[2] SFTP vs API : Which Integration Method Is Best?. [Online]. Available: https://www.providertrust.com/blog/sftp-vs-api-which-integration-method-is-best/
[3] Help SAP.com, SAP Cloud Integration. [Online]. Available: https://help.sap.com/docs/cloud-integration?locale=en-US
[4] London’s Global University, What is SSH and how do I use It?. [Online]. Available: https://www.ucl.ac.uk/isd/research-data-repository/what-ssh-and-how-do-i-use-it#:~:text=SSH%20or%20Secure%20Shell%20is,web%20pages)%20and%20share%20data.
[5] SAP Community, Technology Blogs by SAP. [Online]. Available: https://community.sap.com/t5/technology-blogs-by-sap/update-on-sap-s-integration-strategy-sap-teched-2022-highlights/ba-p/13548648
[6] Mark Smallcombe, What Is Needed for an SFTP Connection?, 2023. [Online]. Available: https://www.integrate.io/blog/what-is-needed-for-an-sftp-connection/
[7] Nisha Talagala, Data as The New Oil is not Enough: Four Principles for Avoiding Data Fires, 2022. [Online]. Available: https://www.forbes.com/sites/nishatalagala/2022/03/02/data-as-the-new-oil-is-not-enough-four-principles-for-avoiding-data-fires/?sh=2ff6afa6c208
[8] University of Pittsburgh Website, Understanding and Using Secure Shell (SSH) and Secure File Transfer Protocol (SFTP), 2023. [Online]. Available: https://services.pitt.edu/TDClient/33/Portal/KB/ArticleDet?ID=43#%3A~%3Atext%3DSecure%20Shell%20(SSH)%20creates%20 a%2Cto%20transfer%20files%20between%20computers
[9] SAP Help Portal, SFTP Adaptor. [Online]. Available: https://help.sap.com/docs/cloud-integration/sap-cloud-integration/sftp-adapter
[10] Robert Sheldon, and Gavin Wright, Raw Data (Source Data or Atomic Data). [Online]. Available: https://www.techtarget.com/searchdatamanagement/definition/raw-data
[11] SAP What and Why?. [Online]. Available: https://www.salisbury.edu/academic-offices/business/information-systems-and-operations-management/sap/
[12] Priya Pedmakar, What is SFTP?, 2023. [Online]. Available: https://www.educba.com/what-is-sftp/
[13] Najam Ahmed, Google Drive SFTP Integration: 2 Easy Methods, 2021. [Online]. Available: https://hevodata.com/learn/google-drive-sftp/
[14] Kaseya, System Integration: Purpose, Types, Methods & Benefits, 2022. [Online]. Available: https://www.kaseya.com/blog/system-integration/
[15] Bryce Leo, FTP vs SFTP: Key Difference Between Them, 2024. [Online]. Available: https://www.guru99.com/ftp-vs-sftp.html
[16] V. Kanada, SFTP vs. FTP: What’s the Best Protocol and Why?. [Online]. Available: https://www.ipswitch.com/blog/sftp-vs-ftp-%20what-best-protocol-why
[17] F. Fahim, What is the Difference Between FTP and SFTP?. [Online]. Available: https://serverguy.com/security/difference- %20between-ftp-and-sftp/
[18] Pros and cons of SFTP. [Online]. Available: https://www.ecstuff4u.com/2023/01/pros-and-cons-of-sftp.html