Data Input Properties

To view or edit a data input's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

The General tab contains the following properties:

Property	Description
Name/Code/Comment	Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.
Stereotype	Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file.
Data connection	Specifies the data store represented by the input. You must select a data connection to access the list of available data stores. This field will be automatically completed if you drag the data store from the browser, and drop it onto the diagram.
Source object	[XML and Web service inputs only] Specifies the particular object from the source model to be used as input. Use the tools to the right of the list to browse for an object or view the properties of the currently selected object.
Keywords	Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

The following tabs are also available:

Data Structure Source Objects - [database inputs] Lists the source objects to which the object is attached. Use the Add Source Object tool to add a new object.
Data Structure Columns - Lists the data structure columns associated with the object (see Data Structure Columns (DMM)).

SQL Query - [database inputs] Allows you to edit the default SQL query to help you create your data structure columns. The following tools are available:

Tool	Description
	Retrieve Columns by Parsing Query — Parses the query you have specified in the textbox using the SQL Editor. The columns of the query are automatically created in the Data Structure Columns tab and their parent tables or views are displayed in the Data Structure Source Objects tab. You can also click this tool to update data structure columns and source tables when you have modified source expressions of data structure columns.
	Edit SQL Query — Opens the query in the SQL editor that helps you select PDM objects (tables, views, columns, procedures, and users) to build the SQL query script.

Tool

Description

Retrieve Columns by Parsing Query — Parses the query you have specified in the textbox using the SQL Editor. The columns of the query are automatically created in the Data Structure Columns tab and their parent tables or views are displayed in the Data Structure Source Objects tab. You can also click this tool to update data structure columns and source tables when you have modified source expressions of data structure columns.

Edit SQL Query — Opens the query in the SQL editor that helps you select PDM objects (tables, views, columns, procedures, and users) to build the SQL query script.