Configuring an SFTP integration

SFTP is a file transfer protocol. Configuring an SFTP integration will allow you to export data to or import data from a variety of sources.

Before you begin

StandardPremium This feature is available only in the Standard and Premium editions of Guardium® Insights SaaS.

To see the various settings, open the main menu. Open this menu by clicking the main menu icon ()) After opening the menu, choose Integrations, and then choose the Secure File Transfer Protocol (SFTP) card.

1. After reading the About information, click Next.
2. Enter a unique name for the integration in the Integration name field.
3. Host: Enter the SFTP host name.
4. Port: Enter the port for the SFTP host.
5. Username: Enter the username for the SFTP host.
6. User Public SSH key: Enter the public SSH key details for the user account.
7. User Private SSH key: Enter the private SSH key details for the user account.
8. Host key: SFTP uses SSH to connect to the SFTP server. Host keys are .pub files usually stored in the /etc/ssh directory. They are used for authenticating computers over the SSH protocol. Open the .pub file. Copy the key for this SFTP server.
9. After completing the configuration settings, click Test connection to ensure that the Guardium Insights SaaS can connect to the SFTP server.
10. Click Next.
11. The next page provides instructions for next steps: You can create import and export configurations for the connection and then Create scheduled and audited jobs.
12. After completing the configuration settings, click Finish to save them and create the integration.
13. The integration opens after it is created, with actions for creating import and export configurations:
14. To create an export, click Create export. Then provide a unique name for the export, along with the Folder to export to.
15. To create an import, click Create import:
    1. Provide a unique Name for the import.
    2. The Folder menu lists all of the folders that are available on the file integration server. Select one of these folders or create a new folder by entering a unique name in the Folder field.
    3. Enter the Character separator to use. By default, the comma symbol (,) is used.
    4. To import in a zip archive file, select the Compressed (zipped) check box.
    5. Select the Source of the data for the import.
    6. Depending on the data source that you choose, different data sets are available. Choose the data set for the import.
    7. The available fields are listed. To remove any of the fields, use the delete action. To remove all of the fields, click Clear fields. To add fields, use the New source and New destination fields and then click Add.
    8. Click Finish to create the import.

Results

After the export and import have been created, you can schedule them when scheduling and auditing jobs.

After creating an SFTP integration, you can select it in the Integrations page to edit it. You can also select its menu to Disable or Delete the integration.