This can be a complex topic. Here are the major steps: 1) Generate a list of transactions from your database. This could be a simple table that lists all the create, updates, and deletes from your table with the date/time the transactions occurred. In theory, this table could be created with a stored proc or a trigger in MySQL 5.
2) Query your table created in step 1 for a list of transactions since the last sync. This would give you a list of all the creates, updates, and deletes to accounts that need to be mirrored in Google. 3) Use the provisioning API to apply the transactions from step 2. You'll notice the Google API closely aligns with the usual database CRUD actions, so this is pretty straightforward. 4) Store some kind of "last updated" time for use in your query the next time you run step 2. 5) Repeat periodically (hourly, daily, etc) On May 17, 10:30 pm, Roaring Tiger <[EMAIL PROTECTED]> wrote: > how can synchronize my mySQL ( which has everything stored - name, > password, username ) database with my Google Apps provisioning api. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Apps APIs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/google-apps-apis?hl=en -~----------~----~----~----~------~----~------~--~---
