web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / data mutation through ...
Microsoft Dynamics CRM (Archived)

data mutation through external SQL table

(0) ShareShare
ReportReport
Posted on by Redrum 40

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

*This post is locked for comments

I have the same question (0)
  • Frank Hermes Profile Picture
    Frank Hermes on at
    Re: data mutation through external SQL table

    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.

  • Redrum Profile Picture
    Redrum 40 on at
    Re: Re: data mutation through external SQL table

    isn't it a bit overdone to setup a biztalk server when it only concern one table ??

    [quote user="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.

    [/quote]
  • Frank Hermes Profile Picture
    Frank Hermes on at
    Re: Re: Re: data mutation through external SQL table

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans