SQL Transformation
This type of transformation specifies a database connection for the database server
that runs the SQL file associated with the scenario. The data processed by the SQL
script is
located in the database.
To create an SQL transformation scenario, use one of the following methods:
- Use the
Configure Transformation Scenario(s) (Alt + Shift +
T, C (Command + Alt + T, C on OS X)) action from the
toolbar or the XML menu. Then click the New button and select
SQL transformation.
- Use the
Apply Transformation Scenario(s) (Alt + Shift +
T, T (Command + Alt + T, T on OS X)) action from the
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, selectingApply Transformation
Scenario(s) runs the associated scenario automatically. You can check to see
if transformation scenarios are associated with the edited document by hovering your
cursor
over the Apply Transformation
Scenario button.
- Go to and select Transformation Scenarios to display this view.
Click the New button and select SQL
transformation.
- Name
- The unique name of the SQL transformation scenario.
- SQL URL
- Allows you to specify the URL of the SQL script. You can
specify the path by using the text field, its history drop-down, the
Insert Editor
Variables button, or the browsing tools in the 
Browse drop-down list. - 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 add or configure parameters for the transformation.