Data Source Properties

You can modify an object's properties from its property sheet. To open a data source property sheet, double-click its diagram symbol or its Browser entry in the Data Sources folder.

The General tab contains the following properties:

Property	Description
Name	Name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users
Code	Technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces
Comment	Descriptive label for the data source
Access type	Controls which types of queries (for PDM data sources) are available in the Mappings property sheet or in the Mappings pane of the Mapping Editor, and also controls the existence of forward and reverse mappings. For more information about forward and reverse mappings, see Creating a data source.
Model Type	Type of model(s) being used as data source. See Object Mappings

The following tabs are also available:

Models - Lists the models associated with the data source. Use the Add Models tool to add models open in the current workspace.
Database Connection - [for data sources created in a PDM] Contains the parameters needed to connect to the database associated with the data source. Click the Select a Data Source tool to specify an ODBC data source or connection profile (see Connecting to a Data Source).
Cost - [for data sources created in a PDM that supports lifecycle modeling] Lets you specify the cost per GB of storage for the data source along with the compression rate, which is used to estimate the relative size of the data once it has been loaded to the data warehouse (where 100% indicates no compression).
Data Movement (Lifecycle) - [for data sources created in a PDM that supports lifecycle modeling] Lets you define parameters to connect to a remote database, whose data will be loaded into the warehouse.