• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 93 subscribers
  • Views 1789 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Date in Synchronization Editor Object Mapping rule

lrigs
over 5 years ago

Hello.

I'm having issues with Sync project with SQL as a target.

I have a Object matching rule with personnel number and leaving date property to SQL table which should write the personnel number and the date.

I'm only doing an insert to a table when a employee get's terminated. I have this job scheduled to run every night after my  HR import.

It keeps writing new entries to the SQL table even though it already exist in the target.

The workflow is only set for insert if it does not exist in the Target system. 

Is there an issue with date matching when trying to use in a object mapping rule?

I cannot seem to figure it out the dates are matching in Source and Target when it writes to the SQL table. Yet it want to write it over and over again.

Thank you,

Lu

Parents
  • 0 over 5 years ago

    I got it figured out I think...

    Testing but I create a new virtual property on the source side to convert the date to UTC when sending over to the target.

    Then on the mapping it will map both side UTC from target and source.

Reply
  • 0 over 5 years ago

    I got it figured out I think...

    Testing but I create a new virtual property on the source side to convert the date to UTC when sending over to the target.

    Then on the mapping it will map both side UTC from target and source.

Children
No Data