NetSuite OpenAir SFTP to SharePoint
NetSuite’s OpenAir allows you to backup files and attachments to an SFTP server. However, no one wants to host or manage an SFTP server these days, especially with everything moving to the cloud. Not to mention, backing up or getting files to a platform such as SharePoint or Box would make the content more usable and increase productivity.
Using Couchdrop’s Cloud SFTP platform, you can bring your own cloud storage (such as SharePoint, Box, Google Drive, Amazon S3, Azure, etc.) and interact with specific directories or folders using the industry standard SFTP. Through using Couchdrop as a medium, you can send your OpenAir data to SharePoint or any other cloud platform in real-time for backup or to ingest into an ETL pipeline.
How to get started
- Create a Couchdrop account
- Connect your cloud storage
- Create an SFTP user
- Configure OpenAir
Step 1. Create a Couchdrop account
Navigate to Couchdrop and create an account (14-day free trial, no credit card required either).
Step 2. Connect your cloud storage
Step 3. Create user to connect via SFTP
Next create an SFTP user. The minimum that is required for OpenAir is:
- Specify the root directory of the user
Step 4. Configure OpenAir to backup via SFTP
OpenAir requires the following information to connect (Found here on page 383 — https://www.openair.com/download/OpenAirAdminGuide.pdf).
- Address — In this case it will be your Couchdrop Primary Domain
- Directory — Leave this as the root (or ‘/’)
- Username & Password— The username and password of the SFTP use you created in step 3
Once you have configured the above, your OpenAir files will be sent directly to your cloud storage in real-time, and without skipping a beat!