Bulk Delete

Delete Multiple rows from database table using Bulk Delete Operation

Using Bulk Delete operation of DB Connector we can delete the multiple database rows at a time

Bulk operations allow you to run a single query using a set of parameters values.

Advantage of Bulk Operation:

• The query is parsed only once.
• Only one database connection is required since a single statement is executed.
• Network overhead is minimized.
• RDBMS can execute the bulk operation atomically

Create project in anypoint studio and configure the listener to trigger the flow

Sample JSON Input:

[
  {
    "CUSTOMER_ID": 1,
    "CUSTOMER_NAME": "TEST11",
    "ADDRESS1": "Flat 101",
    "ADDRESS2": "Viman Nagar 1",
    "POSTALCODE": "201018",
    "CITY": "PUNE"
  },
  {
    "CUSTOMER_ID": 2,
    "CUSTOMER_NAME": "TEST22",
    "ADDRESS1": "Flat 102",
    "ADDRESS2": "Viman Nagar 2",
    "POSTALCODE": "201019",
    "CITY": "PUNE"
  },
  {
    "CUSTOMER_ID": 3,
    "CUSTOMER_NAME": "TEST33",
    "ADDRESS1": "Flat 103",
    "ADDRESS2": "Viman Nagar 3",
    "POSTALCODE": "201018",
    "CITY": "PUNE"
  },
  {
    "CUSTOMER_ID": 4,
    "CUSTOMER_NAME": "TEST44",
    "ADDRESS1": "Flat 104",
    "ADDRESS2": "Viman Nagar 4",
    "POSTALCODE": "201019",
    "CITY": "PUNE"
  }
]

Create Sample Payload:

Drag and drop Bulk Delete operation from mule palette

Complete the connector configuration

Configure the bulk delete operation, you can pass the payload as a input parameters and sql query as shown below

Deploy and test the project