BulkInsert

Stable version 2.1.10 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Published on 14 Sep by 
4.9
 (24 ratings)

BulkInsert

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.
Read more
  • 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
What’s new (2.1.10)
  • Demo created
  • Documentation created
Reviews (0)
Related assets
More from Galter