Algorithm Parameters

Each Microsoft database model type has specific parameters that can be set using the msas_parameters property--for example:

stream = modeler.script.stream()
msregressionnode = stream.findByType("msregression", None)
msregressionnode.setPropertyValue("msas_parameters", [["MAXIMUM_INPUT_ATTRIBUTES", 255], 
["MAXIMUM_OUTPUT_ATTRIBUTES", 255]])

These parameters are derived from SQL Server. To see the relevant parameters for each node:

  1. Place a database source node on the canvas.
  2. Open the database source node.
  3. Select a valid source from the Data source drop-down list.
  4. Select a valid table from the Table name list.
  5. Click OK to close the database source node.
  6. Attach the Microsoft database modeling node whose properties you want to list.
  7. Open the database modeling node.
  8. Select the Expert tab.

The available msas_parameters properties for this node are displayed.