Chapter 12 Creating Mappings


Data source properties

To display a data source property sheet, double-click its name or its icon in the Browser tree view.

General

The General tab of a data source property sheet displays 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 Introduction to Model Object Mapping

A data source also includes the following properties:

Models

The Models tab of a data source property sheet displays an empty list of models. You have to define the list of models used as source of data. You use the Add Models tools to open a selection dialog box. You must select among models open in the current workspace.

Database connection (PDM data source only)

For a PDM data source, the Database Connection tab lets you define the following parameters to connect to a database:

Parameter Description
Using a data source Data source associated with the database
Using a connection string Allows you to connect to a database. A connection string is a series of semicolon delimited arguments that define parameters such as the data source provider and the location of the data source. For example, the connection string for jConnect is:

jdbc:sybase:Tds:machine-name:port-number
User ID User login
Password User password

 


Copyright (C) 2008. Sybase Inc. All rights reserved.