To create an SQL transformation scenario, use one of the following
methods:
- Go to and select
Transformation Scenarios to display this view.
Click the New button and select SQL
transformation. - Use the Configure Transformation Scenario(s) (Alt + Shift +
T, C (Meta + Alt + T, C on OS X)) action from the
Transformation toolbar or the XML menu. Then click the New button and select
SQL transformation.
- Use the
Apply Transformation Scenario(s) (Alt + Shift +
T, T (Meta + Alt + T, T on OS X)) action from the
Transformation toolbar or the XML menu. Then click the New button and select
SQL transformation.Note: If a scenario is already associated with the edited document, selectingAll three methods open the New Scenario dialog box. This dialog box allows you to configure the following options that control the transformation:
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. - Name - The unique name of the SQL transformation scenario.
- 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 Developer plugin 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
workspace- Opens a file browser dialog box allowing you to select a file from the local workspace.
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.
- 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.
