Use the Bulk Execute operation to combine multiple statements of the same data manipulation operation into one statement. When the Bulk Execute operation is invoked, the connector builds one API request for each type of operation.

Configuring Bulk Ops in the Visual Editor

To configure the operation 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 Bulk Execute.
• SQL Query: Enter one or more SQL statements. See the following examples. The statements can also contain expressions.

Bulk Insert

The following examples combine multiple inserts into a single Oracle Sales Cloud request:

SQL

INSERT INTO Opportunities (Name) VALUES ('Commercial Oppty'); INSERT INTO Opportunities (Name) VALUES ('Residential Oppty');

<cdata-oraclesalescloudbulk-execute config-ref="CData_OracleSalesCloud_Configuration" query="INSERT INTO Opportunities (Name) VALUES ('Commercial Oppty'); INSERT INTO Opportunities (Name) VALUES ('Residential Oppty');" doc:name="CData OracleSalesCloud"/>

Bulk Update

The following examples combine multiple updates into a single Oracle Sales Cloud request:

SQL

UPDATE Opportunities SET Name='Commercial Oppty' WHERE Id = 'MyId1';UPDATE Opportunities SET Name='Residential Oppty' WHERE Id = 'MyId2';

<cdata-oraclesalescloudbulk-execute config-ref="CData_OracleSalesCloud_Configuration" query="UPDATE Opportunities SET Name='Commercial Oppty' WHERE Id = 'MyId1';UPDATE Opportunities SET Name='Residential Oppty' WHERE Id = 'MyId2';" doc:name="CData OracleSalesCloud"/>

Bulk Delete

The following examples combine multiple deletes into a single Oracle Sales Cloud request:

SQL

DELETE FROM Opportunities WHERE Id = 'MyId1'; DELETE FROM Opportunities WHERE Id = 'MyId2'; 

<cdata-oraclesalescloudbulk-execute config-ref="CData_OracleSalesCloud_Configuration" query="DELETE FROM Opportunities WHERE Id = 'MyId1'; DELETE FROM Opportunities WHERE Id = 'MyId2'; " doc:name="CData OracleSalesCloud"/>