Hi,
Matt answered this question pretty well last week. But if you need a
simpler approach, consider the following process:
1. Using MySQL data export functionality, export all user records
into a CSV file.
2. Manually upload the CSV into Google Apps using the bulk upload
feature:
http://www.google.com/support/a/bin/answer.py?hl=en&answer=40057
Repeat the steps as and when you want to sync.
Remember, bulk upload only allows Add and Update operations. Deletion
of users is not supported. This is a simple solution and may not be
the most efficient one if you have a fairly large set of users.
Alternatively, you can follow Matt's suggestion to maintain a
transaction table to retrieve all modifications and use Provisioning
API to sync the records. This process can be automated and is more
efficient. Here is a step-by-step guide:
1. Create an INSERT, DELETE and UPDATE database trigger on your
accounts table that inserts a new record into <TransactionSyncTable>
recording the database operation i.e insert/update/delete and the
modified record.
2. Select all records from <TransactionSyncTable> and depending on the
database operation recorded in Step 1, use the appropriate
Provisioning API call to update Google Apps accounts. The Provisioning
APIs map to regular database CRUD operations as Matt pointed out.
3. On successful completion of the process, delete the records from
<TransactionSyncTable>. You can do this by maintaining a list of
record IDs from Step 2. This should mark the completion of a sync
cycle.
4. Leverage your OS capabilities to set up a schedule for your sync
process.
Make sure that the Provisioning API calls are done in the same order
as record entry in the <TransactionSyncTable> to maintain data
integrity.
Thanks,
Anirudh
On May 28, 9:37 am, Roaring Tiger <[EMAIL PROTECTED]> wrote:
> how can i synchronize my mySQL database with my Google Apps database.
> can u provide me a step 2 step guide, which should be easy to
> understand since i am not a experienced programmer. please make it
> easy to understand and enumerate the step.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
