Looking for a best solution concepts for a daily batch in Dynamics 365 (On premise and Online )
We have Dynamics CRM 2013 on premise environment and have a complex daily batch which is
1 ) Using SSIS for ETL
2) Using Store procedures in a separate database to fetch the customer data from MSCRM database
3) Process and separating data base on different criteria(business rule) and priority
4) using CRM API to push back to queue item records for various queues
5) Extracting the records by manual and uploading in to another custom system for business process .
This batch required to process 1 million data daily to categorised based on the business rule .
Anyone can suggest what will be the best approach that is improve that should support for online in future ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156