Icon

01_​Model_​Deployment_​file_​to_​database_​scheduling

Model Deployment File to Database (Scheduling)
Model Deployment File to Database (Scheduling) This workflow: - reads new unseen data from file (.table format), - scores the data with the available current model, - appends model predictions and probabilities to original data, - writes results to database or file.Blog post available at https://www.knime.org/blog/seven_modes_deploymentVideo available at https://youtu.be/Og7VZOJhsOc Apply Model- PMML predictor- Dedicated predictor - SQL model recoding- Executable JAR model Input - Static data from file or database - Dynamic data through REST Interface Output (Prediction Score) - Static to file or database - Dynamic through REST Interface - Static visual: report or email - Dynamic visual: dashboard - External application update Deployment Mode - Remote execution from server - Scheduled execution from server - external application - REST API from Server - Guided Execution from WebPortal tableDeploymentDataWithPredictionsreading deployment data from fileconnect to DBRead modelinfosDeploymentPredictions.xlsx Database Writer Table Reader SQLite Connector Table Reader Predictor Excel Writer (XLS) Model Deployment File to Database (Scheduling) This workflow: - reads new unseen data from file (.table format), - scores the data with the available current model, - appends model predictions and probabilities to original data, - writes results to database or file.Blog post available at https://www.knime.org/blog/seven_modes_deploymentVideo available at https://youtu.be/Og7VZOJhsOc Apply Model- PMML predictor- Dedicated predictor - SQL model recoding- Executable JAR model Input - Static data from file or database - Dynamic data through REST Interface Output (Prediction Score) - Static to file or database - Dynamic through REST Interface - Static visual: report or email - Dynamic visual: dashboard - External application update Deployment Mode - Remote execution from server - Scheduled execution from server - external application - REST API from Server - Guided Execution from WebPortal tableDeploymentDataWithPredictionsreading deployment data from fileconnect to DBRead modelinfosDeploymentPredictions.xlsx Database Writer Table Reader SQLite Connector Table Reader Predictor Excel Writer (XLS)

Nodes

Extensions

Links