The new BizTalk 2013 release will have its own SFTP adapter to connect to SFTP Servers. This facility was not available in previous version and we need to use the third party SFTP adapter from Codeplex or nSoftware and cost $$. Microsoft had included SFTP adapter in the BizTalk 2013 release. I started using it for one of the client, though it has some limitation but going forward Microsoft might improve and add more features to SFTP Adapter.
Follow the below step to set up SFTP connection.
1- Open BizTalk admin console.
2- Browse to adapters – SFTP – Add receive/send handlers.
3- Add one way receive location. Select SFTP adapter from the type drop down.
4- Click on configuration.
5- The configuration window looks like the below.
Below is the description for each SFTP adapter property.
a- ConnectionLimit – Default set to 5. Maximum number of concurrent SFTP connections that can be opened to SFTP Server. A value of 0 means no limit and connection polling is turned on.
a-PollingInterval – 0 – specify the poll interval.
b-Unit – Seconds. Indicates the Unit Of Time of the poll interval.
This mean the adapter will poll the SFTP server at 0 seconds. You can limit the adapter polling by increasing the polling interval or changing the unit to Minutes/Hours/days.
a-AcceptAnySSHServerHostKey – “False/True”. Determines if any SSH public host key fingerprint from the server should have accepted.
b-ClientAuthenticationMode – Password/PublicKeyAuthentication. The Authentication method to be used for authenticating the client to the SSH Server. You can set either Password or Public key authentication.
c- Password – Specify the password for SFTP Server. This is required if you Password authentication is selected. (It can also be required when PublicKeyAuthentication is selected).
d-PrivateKey – Specify the private key of the user. Add the full path of the private key only when PublicKeyAuthentication is selected.
e-PrivateKeyPassword – Specify the password if the user’s private key is password protected. Add password for private key only when PublicKeyAuthentication is selected.
f-SSHServerHostKeyFingerPrint- Specify the fingerprint of the public host key for the SSH Server. Add the SSHServer Host Key FingerPrint generated while creating a private key, only when AcceptAnySSHServerHostKey is set to false.
g- UserName – Specify the user name to log into the SFTP Server.
a- FileMask – The file type to use when retrieving files.
b- FolderPath – Specify the folder on the SFTP server where the files get uploaded.
c- Port – 22 – Specify the port number for this SFTP Server.
d- ServerAddress – Specify the machine name or IP address of the SFTP Server.
I’m glad to use the SFTP adapter without worrying about the extra $$ and extra installation on the BizTalk server. There is known issue with the BizTalk 2013 out of box SFTP adapter. Please refer to the below post http://thoughtsofmarcus.blogspot.co.nz/2013/06/leaving-password-blank-in-biztalk-2013.html