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

Hugh 111 · 2 weeks ago

Hi @kaustubhdub ,

Big Thanks fory your help!

I had stucked in this problem for serveral days and now i finally got the answer,

Your a life saver!

kaustubhdub · 2 weeks ago

Hey, @Hugh 111 no problem, i can understand as i too was stuck with the same issue,
> >Please mark my answer helpful if i was able to solve your issue, that also helps other to find the solution ✌️

Regards,

Kaustubh Dubey