Microsoft Azure Synapse SQL Connector

Back Next

Process SQL queries and stored procedures using an SQL transformation

You can configure an SQL transformation to process SQL queries and stored procedures midstream in a Microsoft Azure Synapse SQL mapping. When you add an SQL transformation, you define the database connection and the type of SQL that the transformation processes.

You cannot configure an SQL transformation for mappings in advanced mode.

The SQL transformation can process the following types of SQL statements:

Stored procedure: You can configure an SQL transformation to call a stored procedure in Microsoft Azure Synapse SQL. The stored procedure must exist in the Microsoft Azure Synapse SQL database before you create the SQL transformation. When the SQL transformation processes a stored procedure, it passes input parameters to the stored procedure. The stored procedure returns the values to the output fields of the transformation.
SQL Query: You can configure an SQL transformation to process an entered query that you define in the SQL editor. The SQL transformation processes the query and returns the rows. The SQL transformation also returns any errors that occur from the underlying database or if there is an error in the user syntax.

Saved query type is not applicable.

For more information about SQL queries and stored procedures, see

Transformations

in the Data Integration documentation.

Mappings for Microsoft Azure Synapse SQL

Configuring an SQL transformation

Rules and guidelines for SQL transformations

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities