web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Integration between Dynamics 365 online with SFTP Server

(0) ShareShare
ReportReport
Posted on by 256

Hi,

I want to connect Microsoft Dynamics 365 with HHA Exchange (SFTP Server). 

Please provide some solution or code for that.

Thanks in advance. 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    M I Mostafa Profile Picture
    4,257 on at

    Hi,

    I assume HHA Exchange is expecting a file to be placed in a secure FTP location on an SFTP server? If that's the case, then there are several ways to achieve this ranging from custom development to generate a file and place it in the SFTP location to using an add-on that generates the file and places it for you.

    My suggestion would be to use something like Scribe Insight (On-premise) or Scribe Online (Cloud). They both have connectors to SFTP and you can achieve your integration to generate the file and place it on the SFTP server without code. Scribe Online is the cloud version and may be a better match for you as you say you are using Dynamics CRM Online.

    Here is a link to Scribe SFTP connector:

    www.scribesoft.com/.../text

    Hope this helps

  • Verified answer
    AnkitSinghal Profile Picture
    256 on at

    Is it paid connector or Free?

  • Suggested answer
    M I Mostafa Profile Picture
    4,257 on at

    Scribe is an integration platform and it is not free. Your other option could be SSIS with Kingswaysoft connector but that's also not free.

  • Verified answer
    AnkitSinghal Profile Picture
    256 on at

    Please suggest any free solution.

  • Suggested answer
    M I Mostafa Profile Picture
    4,257 on at

    You will need to build something custom then. Consider writing a Windows Service or a Console application that reads data from Dynamics CRM and writes into a File then places this file on the SFTP location.

  • Verified answer
    AnkitSinghal Profile Picture
    256 on at

    I want to get data from SFTP server and store in dynamics 365 online.

  • Verified answer
    M I Mostafa Profile Picture
    4,257 on at

    The same applies. You can either use an integration middleware / tool or you can write a custom component to read batch files (flat files) from SFTP and then loop through the content to write to Dynamics 365 Online using the API.

    Hope this helps! Please click on "Yes" if you found this response has helped you.

  • AnkitSinghal Profile Picture
    256 on at

    Do u have any sample code or any tutorial for that.

  • Verified answer
    M I Mostafa Profile Picture
    4,257 on at

    Have a look at this:

    msdn.microsoft.com/.../gg328321.aspx

    There is also some sample code here:

    msdn.microsoft.com/.../hh547396.aspx

    Finally, you can also use the Bulk Data Loader but this is currently in preview only:

    www.microsoft.com/.../preview-feature-import-bulk-data-with-the-data-loader.aspx

    Hope this helps! Please click on "Yes" if you found this response has helped you.

  • Suggested answer
    M I Mostafa Profile Picture
    4,257 on at

    You can also see some sample code here:

    stackoverflow.com/.../import-accounts-and-contacts-zip-file-via-the-dynamics-crm-sdk

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans