Replies to This Discussion

We have support for XML import/export. However it does not record the data that came in and out and you will have to do data transformation before updating. Therefore becomes difficult to debug if there is any problem during integration.

So i would recommend you to define staging tables for data imported into DimensioN. This will act as an audit trail for integration. You can get data from CRM either from SOAP/XML or from database and populate the staging tables which can then be imported into DimensioN using DbImport.

BTW, Always make sure that there is a natrual key for all records imported during integration. This will allow you to co-relate data between applications (especially during failures).