SQL - MS DYNAMICS CRM 4.0 INTEGRATION BY BIZTALK 2009

• Project ID:

  786331

• Project Type:

  Fixed

• Budget:

  $250-$750 USD
  

Project Description:

Our systems consists of:
SQL Server 2005
MS CRM 4.0
Biztalk 2009

Accounts and Contacts data are being held in several tables within the same SQL database in SQL 2005 Server. We need to synhronise the data in the SQL database with MS CRM 4.0 by Biztalk 2009. The synchronisation will be bidirectional.
We need somebody to design a Biztalk Project to do this funtions with the following specifications:

1. Synchronisation will be bidirectional
2. Biztalk Project will include seperate Orchestrations for each of the following:
a. Accounts from SQL to CRM
b. Accounts from CRM to SQL
c. Contacts from SQL to CRM
d. Contacts from CRM to SQL
3. The above orchestrations can also be functioning independently with the necessary artifacts, in addition to working together within the same Biztalk Project.
4. WCF-Custom (Sql Binding) and MS CRM Biztalk adapters have to be used as adapters.
5. SQL functions have to be designed as Stored Procedures.

Skills required:

.NET, Microsoft, SQL, XML