Requirements for Integration with Microsoft Analysis Services

The following are prerequisites for conducting in-database modeling using Analysis Services algorithms with IBM® SPSS® Modeler. You may need to consult with your database administrator to ensure that these conditions are met.

  • IBM SPSS Modeler running against an IBM SPSS Modeler Server installation (distributed mode) on Windows. UNIX platforms are not supported in this integration with Analysis Services.
    Important: IBM SPSS Modeler users must configure an ODBC connection using the SQL Native Client driver available from Microsoft at the URL listed below under Additional IBM SPSS Modeler Server Requirements. The driver provided with the IBM SPSS Data Access Pack (and typically recommended for other uses with IBM SPSS Modeler) is not recommended for this purpose. The driver should be configured to use SQL Server With Integrated Windows Authentication enabled, since IBM SPSS Modeler does not support SQL Server authentication. If you have questions about creating or setting permissions for ODBC data sources, contact your database administrator.
  • SQL Server must be installed, although not necessarily on the same host as IBM SPSS Modeler. IBM SPSS Modeler users must have sufficient permissions to read and write data and drop and create tables and views.
    Note: SQL Server Enterprise Edition is recommended. The Enterprise Edition provides additional flexibility by providing advanced parameters to tune algorithm results. The Standard Edition version provides the same parameters but does not allow users to edit some of the advanced parameters.
  • Microsoft SQL Server Analysis Services must be installed on the same host as SQL Server.

Additional IBM SPSS Modeler Server Requirements

To use Analysis Services algorithms with IBM SPSS Modeler Server, the following components must be installed on the IBM SPSS Modeler Server host machine.

Note: If SQL Server is installed on the same host as IBM SPSS Modeler Server, these components will already be available.
  • Microsoft SQL Server Analysis Services 10.0 OLE DB Provider (be sure to select the correct variant for your operating system)
  • Microsoft SQL Server Native Client (be sure to select the correct variant for your operating system)
  • If you are using Microsoft SQL Server 2008 or 2012, you might also require Microsoft Core XML Services (MSXML) 6.0.

To download these components, go to www.microsoft.com/downloads, search for .NET Framework or (for all other components) SQL Server Feature Pack, and select the latest pack for your version of SQL Server.

These may require other packages to be installed first, which should also be available on the Microsoft Downloads web site.

Additional IBM SPSS Modeler Requirements

To use Analysis Services algorithms with IBM SPSS Modeler, the same components must be installed as above, with the addition of the following at the client:

  • Microsoft SQL Server Datamining Viewer Controls (be sure to select the correct variant for your operating system) - this also requires:
  • Microsoft ADOMD.NET

To download these components, go to www.microsoft.com/downloads, search for SQL Server Feature Pack, and select the latest pack for your version of SQL Server.

Note: Database modeling and SQL optimization require that IBM SPSS Modeler Server connectivity be enabled on the IBM SPSS Modeler computer. With this setting enabled, you can access database algorithms, push back SQL directly from IBM SPSS Modeler, and access IBM SPSS Modeler Server. To verify the current license status, choose the following from the IBM SPSS Modeler menu.

Help > About > Additional Details

If connectivity is enabled, you see the option Server Enablement in the License Status tab.

See Connecting to IBM SPSS Modeler Server for more information.