External Content Connector - SharePoint - Where are index documents stored?

benm3 · ‎05-29-2025

Hello,

I am setting up the SharePoint External Content Connector. I have ran a full document crawl and a user mapping crawl. Both have completed and have found various documents. 151 of those documents have been indexed.

My problem is creating the index and search source as I have no idea what table these 151 documents are stored on, or if they are even stored on a table?

I have looked through sys_db_object to try and find relevant tables but cannot find any. I did find the user mapping table which does contain data.

If anyone can help, it would be really appreciated.

See image below.

benm3 · ‎06-27-2025

Hi,

Yea if you go to the ais_datasource table you should see a Index called "SharePoint Online". You can't see any of the records since they aren't stored within SN but you can use the index source and link it to a search profile.

You should be able to ask Now Assist sharepoint related queries and get answers.

View solution in original post

Priya179 · ‎08-21-2025

Hi I am working on the same sharepoint ECC, I can see doucments have been indexed after full crawl, however cannot view the results in global search or service portal, can you let me know how to get the results?

benm3 · ‎08-21-2025

Have you done a user mapping crawl? You need to be impersonating a user that is on the user mapping list.

Also have you added the index source to a search profile?

kaustubhdub · ‎08-21-2025

hey, when i do the user mapping i actually get no result what else do i need to do actually? and same i added the SharePoint to the service portal but no result.