ℹ️ This article is intended to help with the specific settings to SFTP, if you haven't read the native integration setup article yet, start with it by clicking here.
We offer a collaborator integration via SFTP. Through it, the base is updated on the Platform every time you send a single file in csv format (other formats are not accepted) with the information from your complete collaborator base that should be in Qulture.Rocks. Note that each synchronization understands that the source of truth of active users is this csv, that is, if you send John and Mary today and tomorrow you send only Mary, John will be inactivated. This integration runs at 12:30 and 02:00 daily (Brazil time).
This integration is a little different from the others because it does not directly integrate Qulture.Rocks platform with the source system, either because this system does not have a REST API that we can integrate, or because Qulture cannot have this access. As such, your company will create a program that puts a csv with the users in a folder on AWS and our sync will read from that folder.
In summary:
Your program reads from the SOURCE, prepares a csv and uploads it into the folder via SFTP
Qulture takes this file, creates an import and deletes the file
🤓 SFTP stands for Secure File Transfer Protocol
This protocol helps increase security when transferring this csv. With it your company generates a double password: one from you (secret) and one from us (public). We set up a folder with ours and your system can dump the file into it with the private password.
⚙️How to set it up?
We use the AWS Transfer for SFTP service (https://aws.amazon.com/pt/sftp/) for secure file transfer.
In order to set this up for your company, we need your help.
You: Create the csv template (read this article about mapping fields)
You: Generate an SSH key (https://docs.aws.amazon.com/pt_br/transfer/latest/userguide/key-management.html#sshkeygen)
You: Create a zip containing this information and send it securely to us at integrations@qulture.rocks by copying your account manager (CSM)
txt file with the public ke
II. csv file with the data of the collaborators you would like to synchronize
Qulture: Reply to this email after we have created a test environment so that we can test the flow with you and make any necessary adjustments.
You: Reply to this email when the test integration is approved.
Qulture: Migrate the environment to production and start the base integration effectively! 🤘
👀 Some important notes
The file name has to be the same for every import, so we need you to always send with the format users.csv
The encoding of the file must be UTF-8
The file separator must be a semicolon (";")
Put the column headers with words without special characters and separated by an underline, e.g. put "number_of_the_leader" instead of "Number of the leader".
The importation of data occurs twice a day (2:00 a.m. and noon - Brazil time). When the system finishes importing the data, it renames the file it used, adding the suffix "_backup".
What did you think of the article? Leave your feedback below 👇