8.2. Create New Relational Source Model

8.2.1. Create a New Relational Source Model

To create a new empty relational source model:
  1. Launch the New Model Wizard.
  2. Specify a unique model name.
  3. Select Relational option from Model Class drop-down menu.
  4. Select Source Model from Model Type drop-down menu.
  5. 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:
  1. Select the model builder labeled Generate File Translator Procedures and click Next >. The Generate File Translator Procedures dialog will be displayed.
  2. 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:
  1. Select the model builder labeled Generate Web Service Translator Procedures and click Next >. The Generate Web Service Translator Procedures dialog will be displayed.
  2. 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:
  1. 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.
  2. 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.
  3. Select the Copy all descriptions option if desired. Click Finish.