HOW TO question for DTS setup

[Sven Elskens]

Hello everybody,

A HOW TO question about highlevel setting up my DTS:

I'll explain the setup first.

I have 10 accounts and 15 products in my Microsoft crm database. There's an intermediate custom crm entity "Account Products" for each product against the account so there are 150 Account Product records.

I'm developing a DTS that if a change to the product is made then once a week when executing the DTS the change will be detected and it will get updated against the Account Product. The update part works and I have no issues with that. The question is... if I would add a new product the DTS does not detect the new product. I would like the DTS to detect it and add a new Account Product against each account. Or also, if you delete an Account Product record against the account the DTS should detect that and re-add it again. This also does not happen as it does not "detect" the new product.

 

My current DTS setup is the following:

- "Account Product" entity in the source to loop through all "Account Product" records

- My target contains of 2 steps: first a SEEK step to retrieve the product and then an UPDATE/INSERT step on the "Account Product" entity, but the INSERT part seems to fail somewhere.

 

What do I do wrong

[Audrey Buettner]

Curious- why are you not using the CRM Publisher to detect Insert, Update as they happen to the Product entity, and have another one to listen for Delete on the Account Product entity