Create multiple datasources for a single search index

Question

I have physical documents (docx, pdf, xlsx, etc...) stored in blob storage. Accompanying metadata is held in AZURE SQL Database tables. I want to be able to expose a search index which is combining the searchable contents from the physical documents and the metadata for the same document. Both will have a common field value which can be used to join them up.

i.e. BlobStorage will have the filename as "1ea2e9c4-0b5e-40f4-9aab-b3ca630010ea.docx" and then the content

     AZURE SQL Table will have a record like:     Id:                       1ea2e9c4-0b5e-40f4-9aab-b3ca630010ea
                                                                          Filename:             1ea2e9c4-0b5e-40f4-9aab-b3ca630010ea.docx
                                                                          Title:                     The journal for traffic lights

Hopefully, this can be easily done in a single index so that the users can search against all aspects of the file..

Answer 1

@Tarun Patel , Thanks for the great question.

This can be accomplished, take a look at this Tutorial: Index from multiple data sources using the .NET SDK for a step-step instructions. As long as both of the data sources have an Id in common, all you really need to do is create an indexer for each data source and point them to the same index. Hope this helps!

Apologies for the delay!