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>

 
Номер статьи базы знаний

001117179

 
Загрузка
Salesforce Help | Article