Skip to main content

Notifications

Customer Service forum

Need to sync couple of fields in user entity. what are the best out of the box options for dynamics 365 online?

Posted on by Microsoft Employee

Hi,

I have a need to do a daily update of couple of fields for all users in dynamics 365 online. I see there are few products available but there does not seem to be an out of box way to implement this daily task either using SSIS or sync from active directory? Basically source information is available in a local on-premise database which I can use to sync Dynamics 365 cloud using SSIS if there are connectors available. Also since dynamics is part of office 365 suite, I thought there will be a way to join username field of user entity with active directory online to get additional information about the users within dynamics 365. But I do not find any pointers to achieve this. Please let me know what are the better options for the given scenario.

Thanks.

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Need to sync couple of fields in user entity. what are the best out of the box options for dynamics 365 online?

    Thanks. I was looking for a way to achieve my goal using out of box tools. Kingswaysoft connector needs license to work as a daily task.

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    RE: Need to sync couple of fields in user entity. what are the best out of the box options for dynamics 365 online?

    Hi,

    You can try to use Kingswaysoft

    www.kingswaysoft.com/.../ssis-integration-toolkit-for-directory-services

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,316 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans