Skip to main content
Version: Current

Import From DataTable

Description​

The Import From DataTable activity bulk inserts rows from an IbDataTable into a database table.

IbDataTable is the common tabular data structure used across IB-X. This activity enables tabular data produced by different activities and data sources to be directly imported into a database table.

For example, the source IbDataTable can come from:

  • Database query results
  • CSV files
  • Excel worksheets
  • Google Sheets
  • Word tables
  • Other IB-X activities that produce IbDataTable output

This makes it possible to transfer data from different sources into a database without requiring intermediate data conversion.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

The following properties define how the activity connects to the database and imports the data.

Connection Type​

Specifies the database engine (for example, SQL Server, Oracle, MySQL, PostgreSQL). Selecting the correct type ensures compatibility with the target database.

Connection Name​

Select a preconfigured database connection that defines the server, credentials, and security settings.

Schema​

Specifies the database schema that contains the target table.

Table Name​

Specifies the database table into which the rows from the DataTable will be inserted.

DataTable​

Specifies the source IbDataTable containing the rows to be imported into the target database table.

The DataTable can be provided by any IB-X activity that produces an IbDataTable, such as database, CSV, Excel, Google Sheets, and Word activities.

This allows the output of one activity to be directly used as the input to Import From DataTable, enabling seamless tabular data transfer between different systems and data sources.

Column Mapping​

Defines how columns from the source IbDataTable are mapped to columns in the target database table.

Use the Resource Mapper to map each source DataTable column to the corresponding target database column.

note

Ensure that the mapped source and target columns use compatible data types. Incompatible values may cause the import operation to fail.

Batch Size​

Specifies the number of rows processed in each batch during the bulk insert operation.

For large DataTables, processing records in batches can help manage database and system resource usage.

Set the value to 0 to allow the database provider to process the complete DataTable without explicitly specifying a batch size.

Timeout​

Specifies the maximum time (in seconds) that the activity will wait for the import operation to complete.

The default value is 600 seconds.

Outputs​

Inserted Records Count​

Returns the total number of records successfully inserted into the target database table.

This value can be used for:

  • Validation
  • Reporting
  • Conditional workflow logic

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • any incoming path completes, or
  • all relevant paths have completed before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling