Regarding data source of Azure cognitive search for managed instance and sql not on azure vm

Question

Two approaches which need to be tried with azure cognitive search.

1. How to import the data in azure cognitive search from a normal SQL database that is not on azure vm?
2. How to import data in azure cognitive search from Azure sql managed instance ?
   -- i referred the document https://learn.microsoft.com/en-us/azure/search/search-howto-connecting-azure-sql-mi-to-azure-search-using-indexers

Once it is done, how to configure the data source of the SQL-managed instance?

Answer 1

@Vishweshwar-3323 ,

Thanks for the follow-up and update. Glad to know #2 is working fine.

I understand you are looking to import data from a SQL database that is not on an Azure VM, based on my understanding of your scenario, you can use the Azure SQL indexer. You can create a data source by providing a connection string to the SQL database. You can then map the source fields to equivalent fields in the index. During execution, the rowset is automatically transformed to JSON and loaded into the specified index.

You can use the Import Data wizard in the Azure portal to create and load an index, and optionally invoke AI enrichment using built-in skills for natural language processing, translation, OCR, and image analysis.

Checkout these docs for more info:

Import data wizard in Azure Cognitive Search
Index data from Azure SQL
Data import in Azure Cognitive Search