Professional > Using UNICOM Intelligence Professional > Using the Connection String Builder > Data Link Properties dialog box > Data Link Properties: Connection
 
Data Link Properties: Connection
You use the Connection tab in the Data Link Properties dialog box to define the name, location, and type of the data to which you want to connect. When you select UNICOM Intelligence DM-2 OLE DB Provider on the Provider tab, an UNICOM Intelligence-specific Connection tab is displayed.
Metadata Type
Defines the type of metadata. The list shows the types of metadata for which you have a metadata source component (MDSC). The default options are:
Type
Description
None
Choose this option if you want to connect to case data only
Metadata Document
Selects metadata that is in the standard UNICOM Intelligence Data Model format, which is a questionnaire definition (.mdd) file
ADO Database
Selects metadata that is in an ActiveX Data Objects (ADO) data source
Log File
Selects metadata in a standard UNICOM Intelligence log file
Participation Database
Selects metadata that is in a UNICOM Intelligence Interviewer - Server Admin project's Sample and HistoryTable tables
Quancept Definitions File (QDI)
Selects metadata in a Quancept .qdi file using the QDI/DRS DSC
Quancept Script File
Writes the metadata in an MDM document to a Quancept script (.qqc) file
Quantum Specification
Writes the metadata in an MDM document to a Quantum specification
Quanvert Database
Selects metadata that is in a Quanvert database
Routing Script File
Writes the routing section of an MDM document to a script that defines the routing required for interviewing
IBM SPSS Statistics File (SAV)
Selects metadata that is in an IBM SPSS Statistics .sav file
Metadata Location
The name and location of the metadata. The way you specify this depends on the type of metadata that you selected in the previous list.
Click Browse to select the file in the Open dialog box.
Type
Value
Data Collection Metadata Document
The name and location of the .mdd file.
ADO Database
The name and location of a .adoinfo file, which is an XML file that specifies the connection string for the target data source and the name of the target table in that data source. For more information, see ADO DSC.
Data Collection Log File
The name and location of the log file. Typically log files have a .tmp filename extension. However, some log files may have another filename extension. If necessary, you can rename the file so that it has a .tmp filename extension.
Data Collection Participation Database
The name and location of a Participants Report Document (.prd) file, which is an XML file that specifies the connection string and the names of the table and columns to be used.
Quancept Definitions File (QDI)
The name and location of the .qdi file.
Quancept Script File
The name and location of the .qqc file.
Quantum Specification
The location of the Quantum specification files.
Quanvert Database
The name and location of the qvinfo or .pkd file.
Routing Script File
The name and location of the routing script file.
IBM SPSS Statistics File (SAV)
The name and location of the .sav file.
Open Metadata Read/Write
By default, the metadata is opened in read-only mode. Select this option if you want to be able to write to it. When you open some types of data (for example, a Quanvert database) the metadata is always opened in read-only mode.
Properties. Edit MDM Properties
Click this button to open the Metadata MDM Properties dialog box, in which you can specify the versions, language, context, and label type to use.
Case Data Type
Defines the type of case data. The list shows all of the types of case data for which you have a case data source component (CDSC). The default options are:
Type
Description
ADO Database
Reads case data from an ActiveX Data Objects (ADO) data source.
Delimited Text File (Excel)
Read/writes case data in tab-delimited format to a .csv file.
Database (MS SQL Server)
Reads and writes case data in a UNICOM Intelligence relational database in SQL Server. This option can be used to read data collected using UNICOM Intelligence Interviewer - Server Admin.
Data Collection Log File
Selects the Log DSC, which enables you to read UNICOM Intelligence log files.
Data Collection XML Data File
Reads and writes case data in an XML file. Typically, you use this option when you want to transfer case data to another location.
Quancept Data File (DRS)
Reads case data in a Quancept .drs, .drz, or .dru file using the QDI/DRS DSC.
Quantum Data File (DAT)
Selects theQuantum DSC, which reads and writes case data in a Quantum-format ASCII file.
Quanvert Database
Selects the Quanvert DSC, which reads data in a Quanvert database.
IBM SPSS Statistics File (SAV)
Reads and writes case data in an IBM SPSS Statistics .sav file.
If you have specified a Metadata Type and a Metadata Location, and the default data source in your metadata refers to the case data that you want to connect to, you don't need to specify a Case Data Type or a Case Data Location.
Case Data Location
The name and location of the case data. The way you specify this depends on the type of case data that you selected in the previous list. Click Browse if you want to browse to the location of the case data in a dialog box.
Type
Value
ADO Database
The OLE DB connection string for the ADO data source.
To build the string, click Browse, which opens another Data Link Properties dialog box, and then choose the options for the data source.
For example, to connect to a Microsoft Access database or a Microsoft Excel file, select Microsoft OLE DB Provider for ODBC Drivers in the Provider tab and click Build in the Connection tab to build a connection string that uses the Machine Data Source called “MS Access Database” or “Excel Files” as appropriate.
If your data source is a SQL Server database that is not a UNICOM Intelligence relational database, select Microsoft OLE DB Provider for SQL Server in the Provider tab and enter the server name and database name in the Connection tab. Click OK to close the second Data Link Properties dialog box and return to the Connection tab of the first Data Link Properties dialog box.
Delimited Text File (Excel)
The name and location of the .csv file.
Database (MS SQL Server)
An OLE DB connection string. For more information, see Connecting to a relational MR database using RDB DSC 2.
Log File
The name and location of the log file. Typically log files have a .tmp filename extension. However, some log files may have another filename extension. If necessary, you can rename the file so that it has a .tmp filename extension.
XML Data File
The name and location of the .xml file. Do not use this DSC in production; it is provided for reference only.
Quancept Data File (DRS)
The name and location of the .drs, .drz, or .dru file.
Quantum Data File (DAT)
The name and location of the .dat file. If a .dau file is created, it will have the same name, but with the file name extension of .dau.
Quanvert Database
The name and location of the qvinfo or .pkd file.
IBM SPSS Statistics File (SAV)
The name and location of the .sav file.
Case Data Project
This text box should be blank, unless you are connecting to one of the following case data types:
▪ADO Database: If you are connecting to a SQL Server database (that is not a UNICOM Intelligence relational database) or a Microsoft Access database, enter the name of the database table that you want to use. If you are connecting to a Microsoft Excel file, enter the name of the worksheet that you want to use, for example, Sheet1. Depending on the version of Excel installed, you may have to add a dollar sign ($) after the worksheet name for the connection to be successful, for example, Sheet1$.
▪Database (MS SQL Server): Enter the name of the project that you want to use.
Test Connection
Click this button to test the connection and verify whether you have entered all information correctly.
See also
Data Link Properties dialog box