Create multiple datasources for a single search index

Tarun Patel 1 Reputation point
2021-02-19T15:57:16.067+00:00

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..

Azure SQL Database
Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
694 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ajkuma 22,086 Reputation points Microsoft Employee
    2021-02-23T15:18:22.44+00:00

    @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!

    0 comments