Syncing user data to Opensense over SFTP

Overview

This article gives a high-level overview of how SFTP sync works with Opensense, to automate data transfer securely with .csv files.

Opensense supports integration with external systems through SFTP (Secure File Transfer Protocol), to deliver user data in .csv format. This automates secure syncing of directory information directly into the Opensense platform, which reduces manual effort and increases data accuracy.

How SFTP sync works

Purpose

A seamless, automated process for pushing user data into Opensense from your internal systems. When it's set up, user directory changes, such as new hires, updates, or removals, are reflected in Opensense.

How it works

Your system sends .csv files to a secure folder on the Opensense-hosted SFTP server. Opensense then processes those files automatically, and syncs the user data in them into your Opensense environment.

Connection details

You receive specific credentials and folder information from the Opensense team. You use them to configure your side of the connection.

Data format and mapping

The .csv file should include all the fields that your email signature and directory sync setup need. Opensense works with you to map each field to the correct attributes in the platform.

PGP decryption

Opensense supports PGP decryption, for customers who need an additional layer of data security.

Automation

When the sync is active, uploaded files are detected and processed automatically, user records are created or updated without manual intervention, and changes in your directory system are consistently reflected in Opensense.

Column names

Column names must be all lowercase, with no spaces. You can use underscores (_) in place of spaces.

What’s next

• Workday SFTP sync overview (change request)
• Setting up Workday SFTP sync with an EIB

For further help, contact Opensense Support at help@opensense.com.