Loading

SPOnline: sync user profile custom properties from Oracle?

Prakash Singh

Hi, I need to migrate SharePoint on-prem to SharePoint online. so need few things keep in mind like in On-prem SharePoint 2016 i am using MIM 2016(Microsoft Identity Manager) to import profile from AD and Oracle.

In Oracle DB, few custom properties created for AD users, in both AD and Oracle the conman property is "email".

Now I am new for SharePoint online, so guide me how to sync/import information from Oracle to user profile if email id match for the AD users.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nishanth Shreepad7y ago
You could read through the user properties from oracle and create a json file which has to be uploaded into sharepoint. you can then run a powershell script which reads this json and updates user profile accordingly.

please follow below blog from microsoft

https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/bulk-user-profile-update-api-for-sharepoint-online
0
Vipul Jain7y ago
You need to sync users from local Active Directory to Azure Actice Directory. For this, use can use a free tool from Microsoft - "Azure AD Connect".

To read more about Azure AD Connect, please follow below URL:-
https://docs.microsoft.com/en-us/azure/active-directory/hybrid/how-to-connect-sync-whatis
0