Create Block

The Create or Insert Block adds a new record into a source or target datastore. As part of configuring a Create Block, you:

Depending on the operations available for the Connector, Create Blocks are available for both source and target Connections.

Note: Depending on your Connector, this Block may display as Create, Insert, or Add.

The TIBCO Scribe® Online Connector For Microsoft SQL Server can be set to allow stored procedures. In this case, the Execute Block is available for SQL Server source or target datastores. For more information, see Execute Block.

Block Properties — General Tab

From the Block Properties General Tab, you can change the Block Label, add a description, set batch processing options, and select the entity to use for this operation.

Set Batch Processing Options

Note: Error handling options configured on the Error Handling tab are disabled if Batch Processing is enabled on the Block Properties General tab. When Batch Processing is enabled, the following text is displayed on the Error Handling tab:

Batch processing is enabled, records with errors are processed by subsequent Blocks.

If your Connection supports batch, or bulk, processing, the Batch Processing option is available.

Note: For Salesforce Connections, see TIBCO Scribe® Online Connector For Salesforce for additional information.

  1. Select the Process This Operation In Batches Of checkbox.
  2. Select the size of the batch; from 1 to 10,000.

    When the Solution runs, the source records are stored and then processed in batches of the specified number of records for this Block.

Block Properties — Fields Tab

From the Block Properties Fields Tab, you can:

When using the Fields tab, you can:

For detailed information about using the Fields tab, see Block Properties Fields Tab.

Note: When you first open the Fields tab, the icon displays and the Errors/ Warnings tab indicates that there are Errors and Warnings. This is expected behavior. Errors and Warnings display for the General and Fields tabs until all required data has been entered and the Validate button has been selected. See Block And Map Errors And Warnings.

Block Properties - Error Handling Tab

Note: Error handling options configured on the Error Handling tab are disabled if Batch Processing is enabled on the Block Properties General tab. When Batch Processing is enabled, the following text is displayed on the Error Handling tab:

Batch processing is enabled, records with errors are processed by subsequent Blocks.

Use the Error Handling options to enable or disable processing this record when a Block operation encounters a problem. For the Create Block, errors can be logged when an operation fails. See Block Properties Error Handling Tab for additional information.

Block Properties - Errors And Warnings Tab

If there are any errors or warnings for this Block, the Errors and Warnings tab displays the number of errors or warnings in the tab name. See Block And Map Errors And Warnings.

Once you have corrected the errors, select the Validate button to update the Errors and Warnings tab.

Related Topics

Working With Blocks

Mapping Blocks

Viewing Execution History

Execute Block

Batch Processing