NetSuite OpenAir SFTP to SharePoint

Couchdrop
Couchdrop
Published in
3 min readMar 14, 2022

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).

openair backup sharepoint
Creating a Couchdrop account

Step 2. Connect your cloud storage

Connect your desired cloud storage, in this case we have opted for a SharePoint document library— configure cloud storage guides.

openair sharepoint sftp backup
Connecting SharePoint
openair netsuite sftp
Configuring a SharePoint Document Library for SFTP

Step 3. Create user to connect via SFTP

Next create an SFTP user. The minimum that is required for OpenAir is:

  • Username
  • Password
  • Specify the root directory of the user
netsuite openair sftp backup cloud
Creating an SFTP user for OpenAir SFTP

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
backup netsuite openair to box cloud storage
Snippet from OpenAir admin guide

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!

For more information or to get started jump across to couchdrop.io or for more guides see community.couchdrop.io

--

--