User Profile Properties mapped to BCS Oracle Data source is not getting imported RRS feed

  • Question

  • We have requirement to populate few user profile properties from Oracle ERP Database.

    For this we have created BDC Meta Model file.Through which we were able to retrieve data successfully,Confirmed it by creating External List using created external content Type.

    Using same external content type I have created BCS Synchronization Connection with 1:1(User Name: Employee Name) mapping and mapped few user profiles properties with Oracle Properties .

    but after completing full synchronization user profiles properties are not getting updated.

    no error in Event viewer  nor in 14 hive log file

    not able to track the error ,Please suggest how can we track/solve this issue.

    Thanks in advance



    Thursday, February 2, 2012 7:26 PM


All replies

  • Hi,

    Please take a look at this thread SharePoint 2010 User Profile synchronization through BCS is not working after applying service pack 1 on server.


    Lightning Tools LogoLightning Tools Check out our SharePoint tools and web parts
    Friday, February 3, 2012 8:41 AM
  • thanks Dmitry

    it worked after restarting user profile synchronization service.

    Friday, February 3, 2012 5:29 PM
  • Hi Raghu,

    I have a similar requirement, but the user profiles are not being updated with BCS. I have a few queries regarding this:

    1. Is AD synchronizatioin a must for BCS to update user profiles?

    2. Is October 2011 Cumulative updates necessary for this to work?

    Tuesday, March 13, 2012 4:52 PM
  • Hi  Edlas ,

    1.SharePoint uses active directory connection as the primary and Business data connection as Secondary Store for user profiles.

    Which means to import profile properties from BCS External store we have to import user profiles from Active directory first and then we have to create connection of type BDC with 1:1 or 1: Many mapping relationship between imported active directory properties & BDC store

    So property imported from Active Directory will act as Primary Key(One which was selected while creating BCS Connection) and property in BCD Model file Will act Foreign Key(Identifier in MOdel File).so based on which in join action will be performed and mapped user profiles properties  will be imported.

     2.Nothing like that our dev  environment doesn't have oct update ..but still it working perfectly.But Oct CU contains lot bug fixing related to UPS synchronizaion its better to have it.

    hope this helps you 


    Tuesday, March 13, 2012 8:28 PM
  • Hi Raghu

    Hemant here

    Can you please elaborate to achieve the same.




    Thanks Ba$va

    Friday, June 21, 2013 7:14 PM
  • this was helpful to me. thanks Raghu.
    Thursday, October 9, 2014 1:01 PM