Publishing models for a scoring adapter

You can publish models to a database server that has a scoring adapter installed. A scoring adapter enables model scoring to be performed within the database by using the user-defined function (UDF) capabilities of the database. Performing scoring in the database avoids the need to extract the data before scoring. Publishing to a scoring adapter also generates some example SQL to execute the UDF.

To publish a scoring adapter

  1. Double-click the model nugget to open it.
  2. From the model nugget menu, choose:

    File > Publish for Server Scoring Adapter

  3. Fill in the relevant fields on the dialog box and click OK.

Database connection. The connection details for the database you want to use for the model.

Publish ID. (Db2 for z/OS databases only) An identifier for the model. If you rebuild the same model and use the same publish ID, the generated SQL remains the same, so it is possible to rebuild a model without having to change the application that uses the SQL previously generated. (For other databases the generated SQL is unique to the model.)

Generate Example SQL. If selected, generates the example SQL into the file specified in the File field.