Skip to main content

Configuring SFTP to Obtain Update Files Using Your Own SFTP Server

To configure the use of your own SFTP server for Electronic Updates communications, the Code Insight database administrator needs to insert new rows in the pas_global_properties table that both enable SFTP and identify the SFTP server and its credentials to Code Insight.

After SFTP is configured, Code Insight automatically retrieves information about your SFTP server from the database to establish the connections needed to download the update files, unpack them, and apply the data to the Code Insight database schema whenever Electronic Update occurs.

As a prerequisite step for the use of a local SFTP server, ensure that the update files (update_manifest.txt and update.zip) are downloaded from Revenera to the SFTP server before each Electronic Update. This step can either be done manually or, for example, using a script to automate the download of the update files based on your update schedule.

To configure the use of SFTP for Electronic Updates using your own SFTP server, do the following:

Execute this command against the Code Insight database, replacing variables with information about your SFTP server:

INSERT INTO PAS_GLOBAL_PROPERTIES
(SERVER_ID_, KEY_, VALUE_, ENCRYPTED_) VALUES
('0', 'update.sftp.enable', 'true', 0),
('0', 'sftp.server.url', '<hostname>', 0),
('0', 'sftp.server.port', '<port>', 0),
('0', 'sftp.server.username', '<username>', 0),
('0', 'sftp.server.password', '<password>', 0),
('0', 'update.file.name', '<path_to_update.zip>', 0),
('0', 'update.manifest.file.name', '<path_to_manifest.txt>', 0);

The following describes the variables that the database administrator needs to define in the command:

  • hostname—The IP address or URL of the SFTP server.

  • port—The port used for the SFTP server

  • username—The username used to authenticate the SFTP server.

  • password—The password used to authenticate the SFTP server.

  • path_to_update.zip—The path of the update.zip file on your SFTP server.

  • path_to_manifest.txt—The path of the manifest.txt file on your SFTP server.