Configuring SFTP to Obtain Update Files Using the Revenera SFTP Server

To enable the Electronic Update to download update files from the Revenera SFTP server, the Code Insight database administrator must add the update.sftp.enable property to the pas_global_properties table, setting the property to true.

After SFTP is enabled, Code Insight will automatically retrieve the default information about the Revenera SFTP server to establish the necessary connection needed to download the update files, unpack them, and apply the data to the Code Insight database schema whenever a server Electronic Update occurs.

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

Execute this command against the Code Insight database:

INSERT INTO PAS_GLOBAL_PROPERTIES (SERVER_ID_, KEY_, VALUE_, ENCRYPTED_) VALUES ('0', 'update.sftp.enable', 'true', 0);