MuleSoft Connector for AWS Data Management

Build 20.0.7654

Updating Data

See the following to configure the supported update SQL:

Configuring Updates in the Visual Editor

Select the connector inside your flow and specify the following connector properties:

  • Connector Configuration: Select a connection you created. See Establishing a Connection for more information.
  • Operation: Choose the update operation.
  • Query type: By default, the connector executes parameterized queries. Choose the Dynamic query type to override this. See Parameterized Queries for more information.
  • SQL query: Enter the SQL statement. See the following examples.

Configuring Updates in XML

You can set the following fields in the connector configuration:

  • config-ref: Reference a connection you created. See Establishing a Connection for more information.
  • query: Specify the SQL statement.

  • queryType: By default, the connector is configured to execute parameterized queries. Set this field to "Dynamic" to override this. See Parameterized Queries for more information.

UPDATE

Below is an example parameterized update using variables defined within the flow.

SQL

  UPDATE NorthwindProducts SET Name = #[flowVars.Name] FROM NorthwindProducts WHERE Id = #[flowVars.Id]
  

XML

The following configuration executes a parameterized update.

<cdata-awsdatamanagement:update config-ref="CData_AWSDataManagement_Configuration" query="UPDATE NorthwindProducts SET Name = #[flowVars.Name] FROM NorthwindProducts WHERE Id = #[flowVars.Id]" doc:name="CData AWSDataManagement"/>
  

INSERT

Below is an example parameterized insert using variables defined within the flow.

SQL

INSERT INTO NorthwindProducts (PartitionKey, Name) VALUES (#[flowVars.PartitionKey], #[flowVars.Name])

XML

<cdata-awsdatamanagement:insert config-ref="CData_AWSDataManagement_Configuration" query="INSERT INTO NorthwindProducts (PartitionKey, Name) VALUES (#[flowVars.PartitionKey], #[flowVars.Name])" doc:name="CData AWSDataManagement"/>

DELETE

Below is an example parameterized delete using variables defined within the flow:

SQL

DELETE FROM NorthwindProducts WHERE Id = #[flowVars.Id]
  

XML

<cdata-awsdatamanagement:delete config-ref="CData_AWSDataManagement_Configuration" query="DELETE FROM NorthwindProducts WHERE Id = #[flowVars.Id]"/>

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654