SQL Export node in IBM SPSS

Use SQL as Export Node in SPSS

Create an ODBC connection on the Modeler server.

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.