Exploring OpenAI Integration in Azure with Sql Azure

Yens Solis 0 Reputation points
2023-09-29T21:56:58.86+00:00

Dear all, how can I use Azure Cognitive Services with multiple tables from my SQL Server data source in Azure that are related? I want to then use this data in Azure Open AI Studio to perform queries on it. In other words, I want it to analyze my tables, identify relationships between them, and provide me with responses.

What alternatives do I have to use OpenAI on my relational data in SQL Server, to inquire about invoices, electronic guides for a specific client, etc.?

Is it possible to consume Azure Open AI as an API, similar to how the OpenAI API is consumed, or is it only for use within the Azure environment?

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.
758 questions
Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
2,301 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 16,231 Reputation points
    2023-10-01T17:15:29.61+00:00

    You may need to have your tables in Azure SQL Database using the relationships (don't forget the primary and foreign keys). You may also need to consider creating stored procedures or views to aggregate or filter data for specific tasks.

    Then, you need Azure Cognitive Search to index data from multiple tables in your Azure SQL Database.

    In reality, the indexer in Azure Cognitive Search can traverse the relationships in your tables and create a search index that respects those relationships. This can be useful if you want to do a free-text search over your data.

    Azure Machine Learning Service provides cloud-based tools for building and deploying machine learning models. You can use this service to build custom models on top of your data and if you have a pre-trained OpenAI model, you can deploy it on Azure using Azure ML Service or Azure Kubernetes Service (AKS).

    Check the following documentation : https://learn.microsoft.com/en-us/azure/ai-services/openai/overview

    0 comments No comments