Hi Ira,
We've done Totara 1.1 and SAP two-way intrgration.
We get the user data, hierarchies, positions, managers from SAP, as well as the path to the user's profile image on the relevant file server. This is done every 30 minutes using CSV. After initial import of data, we only get incremental changes - e.g. new users, or users that any of their data changed.
For each user we get their entire hierarchy, their manager, authentication data and other info.
To update Totara we need to do more than 1 update script run with the data we get - we need to first make sure that the user's unit is in the hierarchy and that the hierarchy is up to date, then we add/update the users, and only then update managers (in case these are also new users that we would not have in Totara before the previous script pass).
We also report back to SAP on several data changes: competencies and face to face participation data.
Competency completion is reported using a live web-service, and is simply the competency code, user id, date achieved and a custom field on the competencie validity period.
Face to face participition is sent nightly via CSV and includes attendance information (which we customized to be able to mark attendance for each date in a session separately).
If you have any further questions, please let me know.
Amir