Creating a relational MR database from an IBM SPSS Statistics.sav file

Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > Accessing case data from third party applications > Transferring data using SQL Server Integration Services > Creating a relational MR database from an IBM SPSS Statistics.sav file

You can create a relational MR database from an IBM SPSS Statistics.sav file. The steps involved parallel the steps involved in creating a relational MR database from a Quanvert database.

The steps are:

1 Prepare the IBM SPSS Statistics.sav file. You may want to set up value labels for your categorical variables in IBM SPSS Statistics so that they are interpreted as categorical variables by the UNICOM Intelligence Data Model.

For more information, see Tabulating IBM SPSS Statistics variables in UNICOM Intelligence Reporter.

2 Create the metadata (.mdd) file: see Creating an MDM document from an SPSS Statistics.sav file.

3 3: Creating a new SQL Server database.

4 Exporting the .sav file data to the new database.

5 5: Changing the default data source.

Requirements

▪IBM SPSS Statistics

▪UNICOM Intelligence Data Model

▪Microsoft SQL Server