Chapter 12 Creating Mappings
The Source pane displays all the data sources and their source models showing all the objects that can be mapped.
You need to create at least one data source and declare models in the list of data source models to define where (in which database or model) data should be extracted to be transferred to the model in the Target pane. You can create several data sources.
A data source can contain several models, you can select the source models among a list of models open in the current workspace.
The Source pane always displays a gray background ; it is primarily displayed on the left in the Mapping Editor. However, the Source pane is displayed on the right pane in case of reverse mapping editing.
For more information about reverse mapping, see the Creating Mappings from the Mapping Editor section.
The following toolbar helps you manage sources:
| Tool | Description |
|---|---|
|
Properties - Opens the property sheet of the selected source object. |
|
Create Data Source - Launches the Data Source Creation Wizard that allows you to name a data source, specify an access type, a model type and select source models. See Creating a data source. |
|
Delete Data Source - Deletes the selected data source. Related mappings, if any, are automatically deleted. |
|
Add Model to Data Source - Adds one or more source models to an existing data source from a selection dialog box. |
|
Remove Model from Data Source - Removes the selected source model from the data source. Related mappings, if any, are automatically deleted. |
|
Find Source Object - Finds an object in the Source pane and highlights it. |
The following table lists how you can delete mappings and objects in the Source pane.
| Type of deletion | Short keys |
|---|---|
| Mapping deletion | del key on a mapped object in the Source pane to delete the mapping with its target object in the Target pane
Contextual menu: Delete Mapping |
| Object deletion | shift+del combination key to delete a selected object in the Source pane
Contextual menu: Delete |
You can right click a data source and select Generate Default Mappings. The Generate Default Mapping feature allows you to automatically create mappings between source and target objects having the same name. When an object in the target model is mapped to an object in the source model, their sub-objects are automatically mapped when their name and code match.
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |