SQL Transformation

To create an SQL transformation scenario, use one of the following methods:

Go to Window > Show View and select Transformation Scenarios to display this view. Click the New button and select SQL transformation.
Use the Configure Transformation Scenario(s) (Ctrl Shift C (Command Shift C on OS X)) action from the Transformation toolbar or the Document > Transformation menu. Then click the New button and select SQL transformation.
Use the Apply Transformation Scenario(s) (Ctrl Shift T (Command Shift T on OS X)) action from the Transformation toolbar or the Document > Transformation menu. Then click the New button and select SQL transformation.
Note: If a scenario is already associated with the edited document, selecting Apply Transformation Scenario(s) runs the associated scenario automatically. You can check whether transformation scenarios are associated with the edited document by hovering your cursor over the Apply Transformation Scenario button.

All three methods open the New Scenario dialog box. This dialog allows you to configure the following options that control the transformation:

Name - The unique name of the SQL transformation scenario.
Storage - Allows you to select one of the following storage options:
- Global Options - The scenario is saved in the global options that are stored in the user home directory and is not accessible to other users.
- Project Options - The scenario is stored in the project file and can be shared with other users. For example, if your project is saved on a source versioning/sharing system (CVS, SVN, Source Safe, etc.) or a shared folder, your team can use the scenarios that you store in the project file.
SQL URL - Allows you to specify the URL of the SQL script. You can use the following browsing buttons to enter value in this field:

Insert Editor Variables

Opens a pop-up menu allowing you to introduce special Oxygen XML Editor editor variables or custom editor variables in the XML URL field.

Browse for local file

Opens a local file browser dialog box allowing you to select a local file.

Browse for remote file

Opens an URL browser dialog box allowing you to select a remote file.

Browse for archived file

Opens a zip archive browser dialog box allowing you to select a file from a zip archive.

Browse Data Source Explorer

Opens the Data Source Explorer window.

Search for file

Allows you to find a file in the current project.

Open in editor

Opens the file in an editor panel with the path that is specified in the XML URL text box.
Connection - Allows you to select a connection from a drop-down list. To configure a connection, use the Advanced options button to open the data source preferences page.
Parameters - Allows you to configure the parameters of the transformation.