How do I import user profile directly from an external source (SQL database
) without using active directory?
The common usual solution is to have a SharePoint privilege account that have the replicate directory changes
to start the user profile synchronization service and then use the Business Connectivity Service of SharePoint to connect to a SQL
.
However in my project, we are unable to get the replicate directory changes
privilege to the account.
Thus, is it possible to start the User Profile Synchronization Service WITHOUT granting the 1) Replicate Directory Changes in the AD 2) Granting the domain user account "sp_farm" the local admin account so that we can synchronize the user profile using BCS from an external data source?