Data Link Properties: Advanced
Use the Advanced tab to define additional connection properties.
Metadata Source when Location is Different. If existing Data Source has a different location
The Data Model uses the DataSource object to store details about case data that is associated with an MDM Document (.mdd file). This option specifies what should happen if there is no DataSource object in the MDM Document with the same case data type whose location matches the case data location specified on the Connection tab:
▪Use the Data Source (except for location). This is the default behavior. Select this option if you want to use the first DataSource object of the same type that is encountered and do not want to store the new case data location in it.
▪Use the Data Source and store the new location. Select this option if you want to use the first DataSource object of the same type that is encountered and store the new case data location in it.
▪Create a new Data Source. Select this option if you want to create a new DataSource object. This is useful when you do not want to use the same variable names when exporting to SPSS .sav as used previously.
▪Raise an Error. Select this option if you want the connection to fail.
Categorical variables
Specifies whether to display the categories of categorical variables as numeric values or names.
Preserve source column definitions
Select this option if you want the native objects in the underlying database to be exposed directly as Data Model variables without any interpretation. For example, if you select this option, a multiple dichotomy set in a .sav file would be represented as several long or text variables instead of one categorical variable.
Reading categorical data
Provides options for specifying how data is presented to the user.
▪Return category values. When selected, numerical values that represent the data are presented. This is the default setting.
▪Return category names. When selected, the unique ID that represents the data is presented.
Writing data
Specifies whether the CDSC deletes the output data, if it exists, before writing new data. The options are as follows:
▪Append to existing data. This is the default behavior. Select this option if you want to append to the existing data if it exists.
▪Replace existing data. Select this option if you want to delete the existing data and schema. This will allow data to be created with a different schema.
▪Replace existing data but preserve schema. Select this option if you want to delete the existing data, but preserve the existing schema if possible. Note that for some CDSCs, such as SPSS SAV and Delimited Text, the schema will not be preserved because deleting the data results in the loss of the schema.
Validation
Select if you want case data to be validated before it is written. Deselect if you do not want any validity checks to be performed on case data before it is written.
Allow Dirty
Select if you have chosen data validation, and you want to run in dirty mode. This means that data is accepted even if it has some inconsistencies. Deselect this option to run in clean mode, which means that data is rejected if it contains any inconsistencies (for example, if more than one response has been selected in answer to a single response question). The validation that is performed varies according to the CDSC that is selected.
User name
If required, enter your User ID.
Password
If required, enter your password.
See also