Loading

Mule 4: How to do a SQL Merge updates

Data pubblicazione: Aug 1, 2025
Operazione

GOAL

You want to perform Bulks Updates in a Mule 4 Application.

Fasi
  • As a requirement, you will need to use the DB Connector 1.5.1 version or above.

SQL Merge is an Update function, so you will need to use the Update Connector. See the code below as un example:
  
<db:bulk-update doc:name="Bulk update" doc:id="ab77f2ce-8185-40ee-9704-99d5e4c31a43" config-ref="Oracle">
			<db:sql >MERGE INTO destination USING origin ON (Id = :Id)
				WHEN MATCHED
				THEN UPDATE SET Id = :Id,
				Price =
				:Price
				WHEN NOT MATCHED THEN INSERT (Id, Price) VALUES (
				:Id, :Price)</db:sql>
			<db:bulk-input-parameters ><![CDATA[#[[{'Id': 2, 'Price': 200m= }]]]]></db:bulk-input-parameters>
</db:bulk-update>

 
Numero articolo Knowledge

001117179

 
Caricamento
Salesforce Help | Article