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 > Exporting UNICOM Intelligence data to IBM SPSS Statistics
 
Exporting UNICOM Intelligence data to IBM SPSS Statistics
Note For information on working with the SQL Server Import and Export Wizard, see:
http://technet.microsoft.com/en-us/library/ms141209(SQL.90).aspx
This topic shows how to use the SQL Server Integration Services Import/Export wizard to take data that was collected using one of the UNICOM Intelligence products (for example, UNICOM Intelligence Interviewer) and that is stored in relational MR database and export it to a .sav file, so that you can analyze it using IBM SPSS Statistics.
When you export data to IBM SPSS Statistics, you should create a SSIS package and not attempt to export the data immediately. You then edit the package before you can run it in SQL Server Management Studio.
If you want to export data collected using more than one version of the questionnaire definition (.mdd) file and there have been changes to the variable and/or category definitions in those versions, select all of the versions of the questionnaire definition that were used to collect the case data you want to export. For more information, see Working with versions. Alternatively you can create a special merged version of the questionnaire definition for use for the export. You can do this using the Metadata Model Version Utility. For more information, see Metadata Model Version Utility.
1 From the Windows Start menu, choose Programs > Microsoft SQL Server > SQL Server Management Studio
2 Right-click the appropriate database and select Tasks > Export Data.
This opens the first page of the SQL Server Import/Export wizard.
3 Click Next.
4 From the Data Source list, select UNICOM Intelligence DM-2 OLE DB Provider, and then click Properties.
This opens the Connection tab in the Data Link Properties dialog box.
5 From the Metadata Type list, select Intelligence Metadata Document.
6 Enter the Metadata Location, either by typing the name and location of the .mdd file into the text box, or by clicking Browse and selecting it in the Open dialog box.
7 Deselect Open metadata read/write.
8 If you want to select one or more particular versions of the metadata to use for the export, click Properties, and then select the version or versions you require. For more information, see Working with versions.
9 From the Case Data Type list, select UNICOM Intelligence Database (MS SQL Server) (read-write).
10 Generally, the Case Data Location defaults to the connection string defined in the .mdd file when the project was activated and you do not need to change it. However, if necessary you can enter the connection string manually. For more information, see Connecting to a relational MR database using RDB DSC 2.
11 If necessary enter your Login ID and Password, and then click OK.
12 Enter the Case Data Project, and then click Test Connection.
Test connection succeeded means that you have entered all of the details correctly and you have successfully connected to the database.
If Test connection failed is displayed, check that you have entered all of the details correctly. If relevant, check your network connection to the server where the database is.
13 Click OK to return to the Choose a Data Source page of the SQL Server Import/Export wizard, and then click Next.
This opens the Select Destination page of the SQL Server Import/Export wizard.
14 From the Data Source list, select UNICOM Intelligence DM-2 OLE DB Provider, and then click Properties.
This opens the Connection tab in the Data Link Properties dialog box.
15 From the Metadata Type list, select Intelligence Metadata Document.
16 Enter the Metadata Location, either by typing the name and location of the .mdd file into the text box, or by clicking Browse and selecting it in the Open dialog box. This should be the same .mdd file that you specified previously.
17 Select Open metadata read/write.
18 If you previously selected one or more particular versions of the metadata to use for the export, you must click Properties and select the same version or versions that you selected before. For more information, see Working with versions.
19 From the Case Data Type list, select SPSS Statistics File (SAV) (read-write).
20 Enter the Case Data Location, either by typing the name of the .sav file to which you want to export the data, or by clicking Browse and selecting it in the Open dialog box. This must either be a new file, or one to which you have previously exported data using the same version or versions of the .mdd file and, if a filter was specified, the same selection of variables.
21 Leave the Case Data Project text box blank.
22 Select the Advanced tab and choose the data validation options that you require. Select Allow dirty data if you want to write data, even if it contains some inconsistencies.
23 Select the Connection tab, and then click Test Connection.
Test connection succeeded means that you have entered all of the details correctly and the data can be exported to the specified .sav file.
If Test connection failed is displayed, check that you have entered all of the details in this dialog box correctly.
24 Click OK to return to the Choose a Destination page of the SQL Server Import/Export wizard, and then click Next.
25 Do one of the following:
To export only a subset of the data, select Use a query to specify the data to transfer, and then follow the instructions in Filtering data when exporting to IBM SPSS Statistics.
To export all of the data, select Copy table(s) and view(s) from the source database and then continue through the instructions in this topic.
26 Click Next.
27 Select the VDATA table for both the Source and Destination.
28 If you want to append data to an existing .sav file, click the button in the Transform column. This opens the Column Mappings and Transformations dialog box. Select Append rows to destination table and then click OK. This returns you to the Select Source Tables and Views page.
29 Click Next.
30 Deselect Run immediately.
31 Select Save SSIS Package.
32 Select SQL Server, if you want to store the SSIS package onto a SQL Server installation, or Structured Storage File, if you want to store the SSIS package in a file.
33 Click Next.
This opens the Save SSIS Package page. The details on this page depend on whether you chose SQL Server or Structured Storage File on the previous page.
34 Enter a Name, Description, and the other details that are required for the SSIS package.
35 Click Next, and then click Finish.
SSIS now saves the SSIS package.
For information about error and warning messages, see SPSS Statistics SAV DSC error and warning messages.
Requirements
UNICOM Intelligence Data Model
Microsoft SQL Server
See also
Working with versions
SSIS troubleshooting
SSIS packages
Transferring data using SQL Server Integration Services
SPSS Statistics SAV DSC
Connecting to the UNICOM Intelligence Data Model