Use SQL as Export
Node in SPSS
Open ODBC and
click on System DSN, define the name and the SQL server from the drop
down list.
Click Next and
either use Windows Authentication or Server authentication, in case
of server authentication enter the username and password.
Click next and
select the default database from SQL databases where you want to
export data.
Click next with
the default settings and click Finish & Test Data Source.
Next screens will
appear like
To use SQL
database in the export node, drag it into the stream canvas and click
edit.
From the data
Source drop down, click on “Add new database connection”.
New window will
pop up with available data sources and select the created data source
in ODBC and click Connect button.
Now in case you
want to create new table define the name of table and click OK/Run.
