IBM Data WH and Netezza model nugget Server tab

On the Server tab, you can set server options for scoring the model. You can either continue to use a server connection that was specified upstream, or you can move the data to another database that you specify here.

IBM Data Warehouse Server Details. Here you specify the connection details for the database you want to use for the model.

  • Use upstream connection. (default) Uses the connection details specified in an upstream node, for example the Database source node. This option works only if all upstream nodes are able to use SQL pushback. In this case there is no need to move the data out of the database, as the SQL fully implements all of the upstream nodes.
  • Move data to connection. Moves the data to the database you specify here. Doing so allows modeling to work if the data is in another IBM Data Warehouse database, or a database from another vendor, or even if the data is in a flat file. In addition, data is moved back to the database specified here if the data has been extracted because a node did not perform SQL pushback. Click the Edit button to browse for and select a connection.
    CAUTION:
    IBM® Netezza® Analytics and IBM Data Warehouse is typically used with very large data sets. Transferring large amounts of data between databases, or out of and back into a database, can be very time-consuming and should be avoided where possible.

Model name. The name of the model. The name is shown for your information only; you cannot change it here.