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) (Ctrl + Shift
+ C (Command + Shift + C on macOS)) action from the
toolbar or the menu. Then click the New button and select
SQL transformation. - Go to and select Transformation Scenarios to display this view. Click the
New Scenario drop-down menu 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 actions 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.