none
User Profile Database RRS feed

  • Question

  • Hello,

    I implemented CometChat for SharePoint 2013. Which table (database) should I refer to retrieve the user Name (display name)?

    What I mean is what is the User Profile table in SharePoint 2013 Database.

    Thank You.

    Thursday, February 22, 2018 9:37 AM

All replies

  • Hi Ameenah,

    it isn't completely supported to Connect directly to the SharePoint Database , but you can easily use SharePoint Api to read users profiles . you can do integration with SharePoint Userprofile using one of the following

    1- Rest Api /_api/SP.UserProfiles.PeopleManager

    2-CSOM : People Manager

    3- SSOM (Object Model)

    i hope this will help you.


    Best Regrads, Ahmed Madany MCTS @twitter http://twitter.com/ahmed_madany @Blog http://ahmedmadany.wordpress.com @LinkedIn http://eg.linkedin.com/pub/ahmed-madany/35/80/2b6

    Thursday, February 22, 2018 4:20 PM
  • Hi Ameenah

    When you create a User Profile service application, SharePoint Server creates three databases for storing user profile information and associated data:

    Profile database – used to store user profile information.

    Synchronization database – used to store configuration and staging information for synchronizing profile data from external sources such as the Active Directory Domain Services (AD DS).

    Social tagging database – used to store social tags and notes created by users. Each social tag and note is associated with a profile ID.

    As Ahmed's answer , Microsoft doesn’t support directly accessing or updating SharePoint databases , here are some reference you could check .

    https://sharepoint.stackexchange.com/questions/201185/in-which-table-all-the-users-of-sp-user-profile-are-stored

    https://onehundredwatt.wordpress.com/2016/01/14/get-sharepoint-user-profile-properties-via-sql-script/


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, February 23, 2018 2:33 AM
  • Hi,

    CometChat is client side plug in chat system and it does nothing with SharePoint or its Profile Database. Opening the SharePoint related SQL DB is not only the best practices and not supported. If anything got interrupted its difficult for you to restore it.

    So try to understand the cometchat by reading its technical documentation.


    Murugesa Pandian MCSA,MCSE,MCPD <pre> Gear up for some solid action by doing. Slide,theory and blog won&#39;t useful much.</pre> After all world likes only doers not Sayers/speakers

    Friday, February 23, 2018 3:35 AM