SQL Transformation

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

• Use the Configure Transformation Scenario(s) (Ctrl + Shift + C (Command + Shift + C on OS X)) action from the 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 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 to see if transformation scenarios are associated with the edited document by hovering your cursor over the Apply Transformation Scenario button.
• Go to Window ⇒ Show View 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.

Storage

Allows you to select one of the following storage options:

• 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.
• 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.

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. You can also use the Open in editor button to open the specified file in the editor panel.

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.