ODBC connection

Here you specify the connection to the Cognos data server (that is, the database) to which the stream data is to be exported.

Note: You must ensure that the data source you specify here points to the same one specified on the Cognos connections panel. You must also ensure that the Cognos connection data source uses the same login as the ODBC data source.

Data source. Shows the selected data source. Enter the name or select it from the drop-down list. If you don't see the desired database in the list, select Add new database connection and locate your database from the Database Connections dialog box. See Adding a database connection for more information.

Table name. Enter the name of the table to which you want to send the data. If you select the Insert into table option,
  • You can select an existing table in the database by clicking the Select button.
  • If you provide a table name that does not currently exist, a new table will be created with the specified name, and data will be inserted into it.

Create table. Select this option to create a new database table or to overwrite an existing database table.

Insert into table. Select this option to:
  • Insert the data into new rows in an existing database table, or
  • Insert the data into a table that doesn't exist. In this case, a new table will be created and data will be inserted as new rows in the newly created table.

Merge table. (Where available) Select this option to update selected database columns with values from corresponding source data fields. Selecting this option enables the Merge button, which displays a dialog from where you can map source data fields to database columns.

Drop existing table. Select this option to delete any existing table with the same name when creating a new table.

Delete existing rows. Select this option to delete existing rows from the table before exporting, when inserting into a table.

Note: If either of the two options above are selected, you will receive an Overwrite warning message when you execute the node. To suppress the warnings, deselect Warn when a node overwrites a database table on the Notifications tab of the User Options dialog box.

Default string size. Fields you have marked as typeless in an upstream Type node are written to the database as string fields. Specify the size of strings to be used for typeless fields.

Click Schema to open a dialog box where you can set various export options (for databases that support this feature), set SQL data types for your fields, and specify the primary key for purposes of database indexing. See Database export schema options for more information.

Click Indexes to specify options for indexing the exported table in order to improve database performance. See Database Export Index Options for more information.

Click Advanced to specify bulk loading and database commit options. See Database export advanced options for more information.

Quote table and column names. Select options used when sending a CREATE TABLE statement to the database. Tables or columns with spaces or nonstandard characters must be quoted.

  • As needed. Select to allow IBM® SPSS® Modeler to automatically determine when quoting is needed on an individual basis.
  • Always. Select to always enclose table and column names in quotes.
  • Never. Select to disable the use of quotes.

Generate an import node for this data. Select to generate a source node for the data as exported to the specified data source and table. When you click Run, this node is added to the stream canvas.