You have the following data sources:
• Finance: On-premises Microsoft SQL Server database
• Sales: Azure Cosmos DB using the Core (SQL) API
• Logs: Azure Table storage
• HR: Azure SQL database
You need to ensure that you can search all the data by using the Azure AI Search REST API.
What should you do?
To ensure that you can search all the data using the Azure AI Search REST API, you need to consider where the data resides. Azure Data Lake Storage is designed to work seamlessly with various Azure services, including Azure Search. By exporting the data in Finance to Azure Data Lake Storage, it will be easier to integrate and make searchable across different services. This approach consolidates the data in an Azure-native storage environment that is compatible with Azure AI Search.
C. migrate what is on-promises to Azure