SFDC Integration with SFTP Server

[softectonic]

Hello,

Not sure this is the right forum for this topic, if not please kindly suggest alternative forum.

Looking for information on how to setup the mechanism to pull/decrypt and load in Salesforce objects encrypted CSV files containing customers information and hosted on SFTP server. 

Would be glad to receive suggections on recommended procedures, tools and best practices.

Thanks,

S

[Navatar_DbSup]

Hi,

For SFDC Integration with SFTP Server you will have to create a tool in any languge like,java ,c#  that will fetch you csv files from the SFTP server and pull into the your object of the salesforce.

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

[emadari]

You don't need to write any code - there are dozens of applications available that you can automate to do the polling via SFTP.  

In fact, take a look at the AS2 Connector (supports SFTP) at http://www.rssbus.com/solutions/as2/.  It is completely free for connecting with one host and has simple scheduling capabilities so that you can automate the file transfer. Versions are natively available for Window and Linux/Unix (Java) so it works pretty much everywhere.  

Once you have those files downloaded you can tie into the applications 'events' and automate the process of pushing to salesforce.  If you need help, I am sure the support team can assist you in getting setup.

[spaxi]

Hello,

i was looking for something similar.

Emadari, how much  As2 connector Costs. Can you give me more info regarding AS2?

thanks

--silvano 

[anshu]

you can use informatica data loader

[emadari]

The RSSBus Secure Managed File Transfer Connectors that I mentioned previously have been released from beta:

• AS2 Connector - A Drummond certified solution for secure AS2 messaging, the leading standard for secure Internet EDI.
• OFTP Connector - An OFTP2 compliant secure file transfer solution. 
• SFTP Connector - Advanced SSH-Enabled SFTP File Transfer with automation. 
• FTP/S Connector - Plain-text or SSL-Enabled FTP connectivity. 

Each of these connectors is completely free for use with a single trading partner/host.  

-Eric