BulkInsert

Stable Version 2.1.0 (O11)
Also available for 10, 9.1
Published on 10 November 2018 by 
Created on 24 November 2015
Details
Quickly insert large quantities of records into a database table.
Read More

Quickly insert large quantities of records into a database table.

  • 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.

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.0)
  • Upgraded to OutSystems Platform 11.
  • Added support for inserting NULL values, on Integer and Text columns, on SQL Server (it should be easy to replicate this feature for Oracle and MYSQL databases, but I currently don't have access to instances where I test this feature).
Reviews (0)
Category
Components, Libraries
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from João Pedro Abreu who created this component.
Dependencies
BulkInsert has no dependencies.
Requirements
Platform
11.0.0.200
Database
All
Stack
All
Component Consumers
No consumers yet.
Weekly Downloads 
Related Components
Silk UI Web
OutSystems R&D
A fully responsive and beautiful UI framework that works within the OutSystems Platform. Build amazing looking applications, in a fraction of the time, which work perfectly across devices. Learn how to start using Silk UI and see the examples at silkui.outsystems.com . Obtain assistance on using Silk UI in our forums .
28591
Multiple File Upload
Multi Uploaders
Allow you to upload multiple files in one upload form or using drag and drop functionality.
2777
OutSystems UI Mobile
OutSystems R&D
Create amazing native mobile applications using this fully integrated UI framework for OutSystems, with dozens of UI patterns ready to use.
10076
More from João Pedro Abreu
Randomizer Number Generator
David Martins
Generate random numbers between a min and max value.
1267
ECT Server for Rally
Arlindo Lima
Integrate user feedback, submitted via App Feedback (formerly know as ECT), directly into Rally projects.
107
Prevent Spam Clicks
João Pedro Abreu
Prevent multiple clicks on a button or link.
217