Step 6-Create SFTP Connection (How To-Load Product)
Before we can begin to create data migrations using the integration templates within PlatformManager, we will need to create the connection to our SFTP server.
SFTP Folder Creation
Part of the SFTP connection is the file path for our customer's data. Therefore, we will need to create this folder before we actually build the connection.
Start the WinSCP FTP client and define a new FTP session using IM instance provided earlier when it was created:
Make sure the protocol type is set to SFTP.
Then, use the host name, port number, user name and password provided in your IM activation email and update the Login panel.
Click Login button.
Next, on the right-hand side is the FTP target path. We will need to drill down to /filearea/inbound/ path.
Then, click on the New option and choose the Directory option:
Define the directory name as products:
NOTE: With the addition of the product directory, the file path will match the FTP path that will be defined during the creation of CSV FTP integration template process.
7. Upon creation of the IntegrationManager instance, we would have received an email confirming access to our SFTP server:
8. We will use this information to create our connection. After selecting our Integration instance, click on the
Connections option:
9. To create our connection, click on the New Connection button.
Choose the SFTP connection type from the list.
10. Add the access information from the email for our SFTP server:
Best Practice: Be sure to incorporate some important attributes into your naming convention to provide pertinent meaning (ie. connection type, table type, etc).
11. Next, we define the file path. Since this connection will be for uploading Product master data we will define it as shown below:
We need to update FTP path to reflect the location on the FTP server where uploaded file will be stored. All IM servers have a default path of /filearea, we will append to this the folder. Thus, for our integration data and this will generate the SFTP path of /filearea/inbound.
12. Finally, we add the Port from the SFTP email:
NOTE: Your port address may be different than the value shown here, review the SFTP email to be sure you use the correct value.
13. Click Test Connection button.
14. Click Save & Deploy button.