Challenge
The client relied on a third-party Learning Management System (LMS) to manage Continuing Medical Education (CME) credits for its members. Previously, they used an SSIS package to transfer these credits to ARDMS. However, ARDMS introduced new API-based requirements and stopped supporting SSIS, leaving the client without a functioning transfer mechanism.
This change meant they needed to:
- ✅ Move away from SSIS and build a modern, API-driven solution
- ✅ Ensure daily, automated data transfers to ARDMS
- ✅ Track failures and provide detailed reporting
Our Solution
Elastik Teams designed and implemented an Azure Function App that runs on a time-triggered schedule.
🔹 Seamless Daily Execution
The app runs every day at a predefined time, retrieving all new CME credits from the client’s transaction table. It collectively transfers the credits to ARDMS via API requests.
🔹 Durable Function Chaining for Efficient Processing
- A time-triggered function initiates the process.
- An orchestrator function manages the flow.
- Activity methods handle individual data transfer operations.
🔹 Advanced Error Handling & Tracking
- Failed transfers are safely queued to prevent data loss.
- A detailed email report is sent daily, showing:
✔ Total records transferred
✔ Failed validations
✔ Successful transactions
Results
- ✅ 100% Automation – No manual intervention needed
- ✅ Zero Data Loss – Failed requests are securely stored and retried
- ✅ Clear Reporting – Staff receives daily insights on transfer success rates
- ✅ Increased Efficiency & Productivity – The process is now faster, smoother, and error-free
A Success Story in Digital Transformation
The transition from SSIS to a modern, serverless Azure-based solution has eliminated downtime, improved accuracy, and provided full transparency. The client was pleased with how seamlessly the new system handled CME credit transfers.
