News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum Synchronize data betwe...

Microsoft Dynamics GP forum

Suggested answer

Synchronize data between two completely different systems

(0) Share

Report

Report

Posted on by Richard Wheeler

75,730

Last year we had a client surprise us by deciding to outsource their warehouse management system. We had 6 months to write import/export routines before they went live. We are sending files to and from an SFTP server. Things work pretty well right now but now they are asking if there is a better way. In the remote warehouse is Oracle running SX so there is no way to have a direct connection between the two systems. What have others done to create a secure and stable connection between two systems that have nothing in common?

Categories:

All responses Img

All responses (3)

Answers Img

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: Synchronize data between two completely different systems

We currently have several eConnect applications bringing data into GP. They all work but sometimes the internet goes down and files can't go to and from the SFTP server. I wish they could have everything on one server.
Craig Fuller 409 on at

Like (1)

Report

RE: Synchronize data between two completely different systems

We use SSIS packages to "synchronize" between 2 different products on different SQL boxes...and I'm thinking this should work with Oracle db as well. Mind you we are not using Oracle but it may be worth looking into.
Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Synchronize data between two completely different systems

I looked but don't really have anything I can add here. The only questions I've seen close to this is more a migration from something like Oracle to Dynamics GP, not really a synchronization of data between the two platforms.

Hopefully the Community will have some ideas........

Thanks

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2

Martin Dráb 228,647 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans