User base integration types
      Back to home
      1. Knowledge Base
      2. Integrations
      3. User base integration types

      User Integration - SFTP

      ℹ️ 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:

      1. Your program reads from the SOURCE, prepares a csv and uploads it into the folder via SFTP

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

      1. You: Create the csv template (read the article about mapping fields)

      3. You: Create a zip containing this information and send it securely to us at integrations@qulture.rocks by copying your account manager (CSM)

        1. txt file with the public ke

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

      5. You: Reply to this email when the test integration is approved.

      6. 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".