Fields on the Data Sources page

You define data sources on the Data Sources page. If you are unsure of how to complete the fields, use the information provided here.

Table 1. Fields on the Data Sources page
Field	Description
Properties
Content Type	Select one of the following options. Transaction - Customer transactions. At least one Transaction data source is required to run a workspace. Profile - Data such as address, age, and gender in an external database table.
Name	Enter a descriptive name for the data source. For profile data sources in database tables, the name must be the same as the corresponding column name in the database. For transaction data sources, the name does not have to match the field name in the actual flat file or web service message.
Description	Provide a description of the data source.
Add Field
Name	Provide the physical name of the field in the source database table or flat file. Data source field names should not be assigned so that one name can be found within another. For example, the name `date` can be found within the name `firstdate`. Field names cannot use spaces, hyphens, or periods. Restrict the field names to letters, numbers, and underscores.
Display Name	Provide a descriptive name. This appears in component editors.
Description	Provide a description of the data source field.
Field Type	Select the attribute type from the following options. The options available depend on the Content Type selected for the data source. Audience Id-Select this for audience level fields. Audience Level-If you select Audience Id as the Field Type, select the audience level you want to associate with this field. Profile Attribute-Choose this type for profile fields that are not audience or date fields. Transaction Attribute-Choose this type for transaction fields that are not audience or date fields. Transaction Date-Choose this type for date fields. One date field is required for each transaction data source.
Audience Level	If you selected Audience Id as the Field Type, enter the audience level code that applies for the field.
Data Type	Select the type of the data in the field. The options available depend on the Field Type selected for the field, and also on the custom data types defined on the Custom Data Types page, if any. The following are the default options. Boolean Currency Date Double Integer String The application supports profile data sources in database tables in a variety of database types. The data types shown in this field are generic types that may be different in your database. The system converts the type you select into the correct data type for your database.
Name Value List	Named value lists with a data type that matches the field you are working with are displayed here. If the field contains predefined values, you can associate it with a named value list.