The SQL transformation processes SQL queries midstream in a pipeline. The transformation processes external SQL scripts or SQL queries that you create in an SQL editor. You can pass the database connection information to the SQL transformation as input data at run time.
This chapter provides two examples that illustrate SQL transformation functionality. You use the examples in this chapter to create and execute dynamic SQL queries and to connect dynamically to databases. The chapter provides sample data and descriptions of the transformations that you can include in mappings.
The chapter provides the following examples:
Creating a dynamic SQL query to update a database.
The dynamic query update example shows how update product prices in a table based on a price code received from a source file.
Configuring a dynamic database connection.
The dynamic connection example shows how to connect to different databases based on the value of a customer location in a source row.