Skip to main content

Notifications

Dynamics 365 general forum

Complex Daily,long running ,scheduled batch Solution

Posted on by 75

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   ?

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans