How can I make prediction and write it in my local Rdbms using azure.

Student 0 Reputation points
2023-01-20T12:05:27.44+00:00

How can I run the model trained with the training data and get an additional column in the dataset?

For Eg:- If I have trained a model which has an interface that takes height weight and age as input and gives output as the individual health status of being fit unfit types. Now I want to do that through automation and put the prediction and inputs in the file of local RDBMS/SQL and save the values. I want to do this by using Azure.

Azure SQL Database
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,446 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,145 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,148 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,786 Reputation points MVP
    2023-01-20T12:35:10.29+00:00

    You could use an Export Data module to export the results (output) to an an Azure SQL Database first, here you will find instructions. After that you can use a free tool named Azure SQL Data Sync to sync/transfer your predictions stored on the Azure SQL Database to a local SQL Server instance installed on your computer. Here you will find a tutorial to configure Azure SQL Data Sync. The sync can be configured to be automatic (every X seconds, minutes, hours, days) or manual.

    0 comments No comments