Share via

What are the possible ways to connect an SQL db with Azure AI Search ?

Adarsh Augustine 0 Reputation points
2025-01-10T05:29:45.22+00:00

I want to connect Azure AI search with SQL data base, I know it is effective to use azure sql service, but most of my data is on SQL server and the data gets updated frequently, so making copy of my data in azure sql seems inefficient. Is it possible to directly sync my data in SQL server with Azure AI search index using Azure data factory ? Could I get help regarding other possible approaches for this scenario. Thank you.

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.
1,142 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,106 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sreeju Nair 12,536 Reputation points
    2025-01-10T07:42:26.22+00:00

    You may use Azure Data Factory with Self Hosted Integration Runtime to pull data from your SQL Server. Now Azure Data Factory can ingest SQL Server Data into Azure AI Search Index.

    Refer: https://zcusa.951200.xyz/en-us/azure/data-factory/connector-azure-search?tabs=data-factory

    To see how to create Self hosted runtime: https://zcusa.951200.xyz/en-us/azure/data-factory/create-self-hosted-integration-runtime?tabs=data-factory

    Another good read: https://github.com/Azure-Samples/openai/blob/pmishra/AOAI_with_CogSearch_and_Sql/End_to_end_Solutions/AOAISearchDemo/README.md

    Hope this helps

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.