Loading

Mule 4: How to do a SQL Merge updates

게시 일자: Aug 1, 2025
과업

GOAL

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

단계
  • 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>

 
Knowledge 기사 번호

001117179

 
로드 중
Salesforce Help | Article