8.2. Create New Relational Source Model
8.2.1. Create a New Relational Source Model
To create a new empty relational source model:
- Launch the New Model Wizard.
- Specify a unique model name.
- Select Relational option from Model Class drop-down menu.
- Select Source Model from Model Type drop-down menu.
- Click Finish.
Note
You can change the target location (i.e. project or folder) by selecting the Browse... button and selecting a project or folder within your workspace.
In addition to creating a new empty relational source model, you can also copy from existing model of the same model class.
8.2.2. Generate File Translator Procedures
This builder option allows construction of a relational model containing one or more of the procedures required for accessing file based data via a file translator.
To create a new relational model containing file translator procedures, complete first 4 steps from the Create a New Relational Source Model section and continue with these additional steps:
- Select the model builder labeled Generate File Translator Procedures and click Next >. The Generate File Translator Procedures dialog will be displayed.
- Select one or more of the Available File Translator Procedures, then click Finish.
8.2.3. Generate Web Service Translator Procedures
This builder option allows construction of a relational model containing one or more of the procedures required for accessing web-service-based XML data via a web service translator.
To create a new relational model containing web-service-based translator procedures, complete first 4 steps from the Create a New Relational Source Model section and continue with these additional steps:
- Select the model builder labeled Generate Web Service Translator Procedures and click Next >. The Generate Web Service Translator Procedures dialog will be displayed.
- Select one or more of the Available Web Services Translator Procedures, then click Finish.
8.2.4. Copy from an Existing Relational Source Model
This builder option performs a structural copy of the contents of an existing model to a newly defined model. You can choose a full copy or select individual model components for copy.
To create a new relational model by copying contents from another relational source model, complete first 4 steps from the Create a New Relational Source Model section and continue with these additional steps:
- Select the model builder labeled Copy from existing model of the same model class and click Next >. The Copy Existing Model dialog will be displayed.
- Select an existing relational model from the workspace using the browse button.
Note
An existing model will be preselected if a relational model in the workspace is selected in the model-explorer-view prior to starting the new model wizard. - Select the Copy all descriptions option if desired. Click Finish.