יום שני 13 אוקטובר 2008 14:04
I need to know how is it possible to synchronize the CRM 4.0 database with a MySql database.
Is there a general way?
יום שני 13 אוקטובר 2008 15:08Hi Isabine.
It is pretty difficult.
All outgoing MS CRM data that needs to sync should be written to a temporary holding table. You will need a windows service to iterate through these records and update mySQL. Use Callouts to export data.
Incoming is a bit more difficult. You may want to create a flag in mySQL to specify whether a record has synchronised or not. Additionally you will want to specify a max try field such that a record that can't sync doesn't try to sync indefinitely.
Most difficult aspect in providing a long term solution that can be maintained is to ensure transaction across updates which is not possible at the DB level between mySQL and SQL.
As for 'how' to get data into SQL and mySQL, best is to use a linked server in SQL and install the latest ODBC driver (I think they're up to 5.1).
We have two clients that wanted to integrate with mySQL and they are pretty happy. We did hit some stumbling blocks with mySQL happily storing invalid dates (e.g. 31 April 2008). Key however is to be able to track data across the systems and provide the client with an interface for resolving their own issues.