Hi Shazia,

We have implemented a 2-way integration with MS Dynamics.

In Totara an admin would pre-create courses using 'Course_id' as the link between Totara & Dynamics.

Totara recieved 2 files from Dynamics on a scheduled basis;

course_assignments.csv - Contains details of courses & users who were assigned to those courses (course name, course_id, username)

users.csv - new users i.e. those that have been created or amended since the last time the process was run. - Standard bulk user import script setup to be called by cron 

Our process then imported the users followed by the courses, thereby assigning users to courses.

We then exported 'results.csv' which contained details of; users, courses, status & passmark, which was then imported into Dynamics. The client then ran MI reports against Dynamics as well as reports from within Totara.

Hope the above helps

Tony