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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer Service forum

db2 and dynamics 365 architecture advice

(0) ShareShare
ReportReport
Posted on by 65

hi need some advice how to design this .

lets say i  some data in db2 db on premise .what should i do to send all this data to d365 crm cloud and do some workflows in d365 with this data and do UPDATE to tables back on the db2 on premise .

Categories:
I have the same question (0)
  • Suggested answer
    blackfincloud Profile Picture
    566 on at

    Hi Tarun -

    I don't have much experience specifically with DB2, but in general, when we face requirements like this,  in the past, the method has been to create console applications using Visual Studio or whatever platform you use that supports both systems.  I mention Visual Studio because there is a lot of support for Microsoft Dynamics 365 using that tool, and there is also support to write to DB2, as evidenced by this article.  The console application is then scheduled to run at intervals using Windows task scheduler, usually on a server. 

    The application would periodically query Microsoft Dynamics 365 for changes, and when it found them, it would capture those changes and update the tables in DB2. 

    I have been on projects where this method was used to create two-way integrations between Microsoft Dynamics and on-premise applications.

    Hope this helps.

    Best,

    Owen

  • Suggested answer
    Adrian Begovich Profile Picture
    1,027 Moderator on at

    Hi tarunnyc,

    Another option is to migrate your DB2 Databases to SQL Server, and then use SQL Server Integration Services (SSIS) to extract the data from SQL Server and import it into Dynamics 365 for Customer Engagement. You can create a SQL Server Agent job in SQL Server to run the SSIS package on a schedule.

  • tarunnyc Profile Picture
    65 on at

    hey thanx for the info but right now we can do SSIS for db2 - d365 but lets say i did something to the records in d365 based upon db2 data .how do i send back the updated data to db2 or sql .

    thanx for the help

  • Suggested answer
    Adrian Begovich Profile Picture
    1,027 Moderator on at

    Hi tarunnyc,

    You would just need to swap the source and destination components around in your SSIS package. Then schedule the SSIS package to run regularly, check for modified records, and update data in the target system.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans