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.
  • Go to Window > Show View and select Transformation Scenarios to display this view. Click the New Scenario drop-down menu button and select SQL transformation.
Both methods open the New Scenario dialog box. This dialog box allows you to configure the following options that control the 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.