Loading

Mule 4: How to do a SQL Merge updates

Udgivelsesdato: Aug 1, 2025
Opgave

GOAL

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

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

 
Vidensartikelnummer

001117179

 
Indlæser
Salesforce Help | Article