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 a Quanvert database > 2: Creating the .mdd file
 
2: Creating the .mdd file
The UNICOM Intelligence Data Model includes a component (mdmqvgen2.exe) that can create an .mdd file from a Quanvert database. You run this as follows:
1 Open the Command Prompt.
2 Change to the folder in which the UNICOM Intelligence Data Model components are installed. Typically, this is:
C:\Program Files\Common Files\IBM\SPSS\DataCollection\7\ DataModel.2
3 At the command prompt, type mdmqvgen2 followed by the path of the folder which the Quanvert database is in. For example, if the database is in C:\databases\museum, type:
mdmqvgen2 c:\databases\museum
mdmqvgen2 displays a message indicating whether the creation of the metadata was successful. If not, check that you entered the path correctly. If it was successful, you will find the .mdd file in the folder above the one which the database is in. For example, in this example, the .mdd file would be C:\databases\museum.mdd.
4 For convenience, move the .mdd file to the folder which the database is in.
Requirements
UNICOM Intelligence Data Model
Next
3: Creating a new SQL Server database
See also
Creating a relational MR database from a Quanvert database
Transferring data using SQL Server Integration Services