data mutation through external SQL table

• 11-19-2008 7:13 AM

  Redrum Joined on 11-19-2008 Posts 2

  data mutation through external SQL table Reply Contact We work with an AS400 where we have triggered our customertable. All changement are written in an table where all INSERT, UPDATE and DELETE's are listed. This table is replicated to SQL server 2005 every night. After that we would like to update our Accountbase and AccountExtensionBase according the SQL table. Can anyone help us how to establish this ??   Thnx in advance for all your effort

• 11-19-2008 7:31 AM

  In reply to

  Frank Hermes Joined on 07-01-2008 Posts 163	Re: data mutation through external SQL table Reply Contact Never update or insert or delete directly in any CRM tables as it is not only not supported but also leads to corrupted data integrity! I would remommend using the BizTalk server with the CRM adapter to synchronize the data via CRMs webservices.

• 11-19-2008 7:33 AM

  In reply to

  Redrum Joined on 11-19-2008 Posts 2

  Re: Re: data mutation through external SQL table Reply Contact isn't it a bit overdone to setup a biztalk server when it only concern one table ?? Frank Hermes: Never update or insert or delete directly in any CRM tables as it is not only not supported but also leads to corrupted data integrity! I would remommend using the BizTalk server with the CRM adapter to synchronize the data via CRMs webservices.

• 11-19-2008 7:58 AM

  In reply to

  Frank Hermes Joined on 07-01-2008 Posts 163

  Re: Re: Re: data mutation through external SQL table Reply Contact Well, in CRM 2 tables are involved and maybe you have to merge or transform some fields? What if the data in CRM changes? Which system is the leading system? How to you manage transactions? Sure you can also write your own applications that queries your database and updates and inserts records via CRMwebservices, but as a said before don't do that directly via SQL.