0

We came with a requirement to Search SQL table which contain documents data in Image/binary column type. we are trying to do this with Elastic-search and Azure Search. we can able to proceed with Elastic-search but hit roadblock on Azure Search as indexing is not possible for these data types thru indexer.

can any body help us, is there any possibilities to achieve this with Azure Search?

Srinivasa Rao Myneni
  • 1
  • A workaround is to extract the document text upon insert/update, store the text on another column, then index that column instead. – Martheen Jan 04 '18 at 05:03

1 Answers1

0

Please see my response to your question on MSDN.

In short, currently, in order to use Azure Search built-in document extraction capabilities, the files need to be stored in Azure blob storage. Then, you can use the blob indexer.

Eugene Shvets
  • 4,561
  • 13
  • 19
  • Thanks for the update. we are taking alternative apporach by converting the image data type to string while loading data to Azure Search for indexing. – Srinivasa Rao Myneni Jan 08 '18 at 14:02