Model Automation Operation Tool--IBM SPSS Modeler Batch

Source: Internet
Author: User
Tags odbc connection

650) this.width=650; "alt=" SPSS Modeler "class=" Img-thumbnail "src=" http://evgetimg.oss-cn-hangzhou.aliyuncs.com/ Content/files/2016/5/27/86810c3ea04e4b3d90bf1d141922335c635999390909143561.jpg "/>

Background Introduction

Many users will pay attention to a problem, that is, after the model is created, how to automate the operation of the model, because it is not possible to run each time to open the SPSS Modeler client, click “ Run &rdquo, then today this article will introduce you through IBM SPSS Modeler Batch processing mode to automate the process of running the model.

IBM SPSS Modeler batch can be implemented without the need to open the IBM SPSS Modeler client, which can run tasks automatically and periodically without user intervention, and it is important to note that IBM SPSS Modeler batch must have purchased an IBM SPSS Mod Eler server is capable of attaching features.

Introduction to Batch processing mode

The tasks that apply to batch mode include:

    • Run more time-consuming modeling exercises in the background;

    • Run the forecast task at the scheduled time (for example, at night, when the task on the computer does not affect daytime server resource consumption);

    • Run data preprocessing for large amounts of data (for example, in the background or at night);

    • Run regular scheduled tasks, such as weekly/monthly reports;

working in batch mode

Working in batch mode by including:

    • Invoking IBM SPSS Modeler in batch mode using the CLEMB command

    • Connect to Server

    • To load an existing stream or script file

    • Executing a stream or script

Example Introduction

3. Use the Windows operating system's scheduled task program to call the Druglearn.bat file.

The following describes the most common connection to the IBM SPSS Modeler Server, which invokes the. str stream file to automate the implementation steps.

1. Use IBM SPSS Modeler to create the stream file Druglearn.str and save it in the C:\wing directory.

650) this.width=650; "alt=" SPSS Modeler "class=" Img-thumbnail "src=" http://evgetimg.oss-cn-hangzhou.aliyuncs.com/ Content/files/2016/5/27/96129c2a259242e08cfcb2d092e823c0635999390964766743.jpg "/>

In the data flow file, the source is the database, and the final analysis results are exported to an Excel file.

2. Write the batch file, open the text editor, enter the following, and save with a. bat suffix.

Clemb-hostname myserver-port 80-username dminer-password 1234-stream "C:\wing\druglearn.str"-P: databasenode.datasource={"POC", sa,123456,true}-execute-logreport32.log

Each parameter is interpreted as follows:

    • CLEMB is the call command;

    • Server is the IBM SPSS Modeler Server name of the connection

    • Port is the connected IBM SPSS Modeler Server port number

    • Username is logged into IBM SPSS Modeler Server user name

    • Password is logged into IBM SPSS Modeler Server password

    • Stream is the flow file (including path and stream file name) to invoke

    • P:databasenode.datasource is the information required by the source node database connection in the stream file, including the name of the ODBC connection configuration, the database user name, the database login password

    • Excute is a representation of the execution

    • Log indicates output log file to Report32.log

In front of each parameter, it is delimited by symbols “-”.

On the trigger panel, set to 22:00 every Saturday night, as

650) this.width=650; "alt=" SPSS Modeler "class=" Img-thumbnail "src=" http://evgetimg.oss-cn-hangzhou.aliyuncs.com/ Content/files/2016/5/27/c5549dad951545d19f4c0eb4b9147c08635999391013159511.jpg "/>

On the operator panel, select the Druglearn.bat file that you just saved.

650) this.width=650; "alt=" SPSS Modeler "class=" Img-thumbnail "src=" http://evgetimg.oss-cn-hangzhou.aliyuncs.com/ Content/files/2016/5/27/4bcdd6c13c1a449588297b8521431f0b635999391053721831.jpg "/>

When you are sure, you are finished setting up scheduled tasks.

Other parameter Contents

The parameters used by IBM SPSS Modeler batch can be very flexible, in addition to the command parameters used in our example, and can be custom parameters in the stream file, for more information, you can download the trial IBM SPSS Modeler and view the relevant user manuals on the website.

Model Automation Operation Tool--IBM SPSS Modeler Batch

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.