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 .
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.
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.
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
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
