BulkInsert - Overview (O11)

Stable version 2.1.13 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded

on 29 August 2023

4.8

(27 ratings)

Details

Quickly insert large quantities of data records into a database table. Supports MySQL, Oracle and SQL Server. The purpose of this component is to allow large amounts of data to be batch inserted into a database table quickly and efficiently. This new version has been converted into a Service Application (new application type made available in version 11 from October 2020). A Service Application allows you to impose a better segmentation of modules and to encapsulate the main business services in your projects.

This new version has been converted into a Service Application (new application type made available in version 11 from October 2020). A Service Application allows you to impose a better segmentation of modules and to encapsulate the main business services in your projects;
Supports MySQL, Oracle and SQL Server.
Doesn't support simultaneous inserts into multiple entities - the record list passed into the extension must contain only one entity type.
Supports inserting data into additional catalogs, if they are added in Service Center.
Supports inserting data into external databases, with external connection, if the connection is added in Service Center.

The bulk insert operations use mechanisms that are specific to each DBMS and Application Server, so the performance may vary.

For SQL Server, we used the SqlBulkCopy class
For Oracle + .NET, we used ODP.NET’s array binding
For Oracle + Java we used JDBC’s batch statements
For MySQL + .NET we used the MySQLDataAdapter class
MySQL + Java wasn't tested, so it probably doesn't work

Release notes (2.1.13)

Improvements have been applied to the component to:

- Support the specific date format for Oracle databases (e.g. "DD/MM/YYYY HH24:MI:SS"),

- Allow the capture of generated SQL logs, enabling the log to be displayed in ServiceCenter (general tab).

License (2.1.13)

BSD-3 license (https://opensource.org/licenses/BSD-3-Clause)

Reviews (2)

29 Aug

in version 2.1.13

Do you want to handle big data volume? that will help <3

20 Mar

in version 2.1.13

Hi, I used this Bulkinsert Component for OutSystems 11 in combination with an external oracle Database holding all necessary data.
It took me some time to know which value to set for the parameters
TableName
and
ExernalDatabaseConnectionName
As a tip:
TableName is "Schemaname.Tablename" (write in " " because it is datatype TEXT)
ExernalDatabaseConnectionName => take a look in your service center under
ADMINISTRATION => Database Connection and copy the ExternalDatabaseConnectionName
from there and set it also in " " (because it is also datatype TEXT)

After that it worked excellent!
Inserting 60.000 rows by iterating and inserting via CRUD-Method took 13 Minutes.
Inserting 60.000 rows by using an object together with this Bulkinsert took 1 min 30 secs!
Thank you for that !

Team