2 Configure SFTP for File Transfers

Some of the Merchandising suite integrations involve flat files as inputs or outputs of the process. In order to support uploading files in a SaaS implementation, you must generate private and public keys and the public key must be associated with your SFTP account for the file uploads. A unique public key must be created for each of your environments (e.g. production, stage, and so on).

Adding Authorized Keys

The following is the process to generate a 2048 bit RSA key and add the same to the SFTP server. This is done with the help of WinSCP tool on Windows. However the same can be done using ssh-keygen on Linux as well.

1. Launch WinSCP and select Tools -> Run PuttyGen.

2. Select "SSH-2 RSA" for the type of key to generate and enter "2048" for the number of bits in a generated key field and click Generate.

   Figure 2-1 Key Generator

   
   

3. Move the mouse over the blank space in the window until the key is generated.

   Figure 2-2 Key Generator Progress

   
   

4. Once the key is generated, click the Save public key button to save the public key to a file.

5. Click the Save private key button to save the Private key to a file. Confirm to save it with/without a passphrase.

6. Open an SR with Oracle Support, to associate the Public half of the Key with your SFTP account (attach the Key with the SR).

Uploading Batch Files

The Upload steps use the private key generated in the earlier section.

1. Launch WinSCP and connect to <SFTP Server> using port 22.

2. Enter the username and click Advanced.

3. Click Authentication.

4. In the Private Key File field, click the Browse button and select the private key created in the earlier section.

   Figure 2-3 Advanced Site Settings Dialog

   
   

5. After loading the private key file, click OK.

   Figure 2-4 Private Key File Loaded

   
   

6. Click Login. The window does not prompt for a password and logs into the SFTP server. Provide a passphrase if one has been set up.

7. Transfer all data files to the directory /<SFTP User>.

8. For each data file transferred to /<SFTP User>, transfer a corresponding file <filename>.complete

   For example, if data_file1.dat, data_file2.dat, data_file3.dmp are the files to transfer, then transfer the below files to the /<SFTP User>/ directory.

   data_file1.dat.complete   
   data_file2.dat.complete
   data_file3.dmp.complete
   

Download Batch Files

1. Launch WinSCP and connect to <SFTP Server> using port 22.

2. Enter the username and click Advanced.

3. Click Authentication.

4. In the Private Key File field, click the Browse button and select the private key created in the earlier section.

   Figure 2-5 Advanced Site Settings Dialog

   
   

5. After loading the private key file, click OK.

   Figure 2-6 Private Key File Loaded

   
   

6. Click Login. The window does not prompt for a password and logs into the SFTP server. Provide a passphrase if one has been set up.

7. Change directory to /<SFTP User>/EXPORT.

8. Download all data files.