Share via

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,728 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,696 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,426 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