BulkInsert - Overview | OutSystems

Log in

Give us feedback

Stable version 2.1.13 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded on 29 Aug by

4.8

(25 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

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 (0)

Related assets

Discovery is a visual tool to help analyze, measure and understand how to improve your factory architecture

data-migration-manager-dmm-performance-advisor-ipa

DMM - Data Migration Manager + IPA - Intelligent Performance Advisor. DMM - Data Migration Manager is a robust, cost-efficient, and intuitive data management solution. IPA - Intelligent Performance Advisor is the next generation in OutSystems performance monitoring and advisory. DMM - Data Migration Manager enables you to reduce costs by saving hundreds of hours that were spent in building custom scripts, allowing you to increase quality and unprecedented flexibility and speed in managing your data. DMM enables data and BPT migration across/into/out of OutSystems environments (onPrem, Hybrid, Cloud, PaaS), databases (mySQL, Oracle, SQLServer) and OS versions (v9 , v10 or v11) using a simple user interface without the need of building custom scripts. It also supports features like data anonymization, data scramble and data deletion, essential to comply with GDPR. IPA - Intelligent Performance Advisor is the next generation in OutSystems performance monitoring and advisory. With IPA you can define and monitor transactions execution times and understand correlation between flows, algorithms and data. IPA is a crucial tool for developers to understand how performance is impacted with data volume growth or to understand performance bottlenecks.

TestFramework is an open-source application that offers simple management and automated execution of OutSystems Unit and API tests. With seamless integration with BDD Framework and Unit Testing Framework , it allows automated regression tests setup and execution. With the recent addition of Ghost Inspector integration, it now also allows the inclusion of automated UI tests in the test suites. TestFramework is provided by Indigo, an OutSystems partner, with ample experience in automated testing strategy and implementation. With the latest update, it’s now possible to analyze, track, and produce reports of your project’s code coverage, load tests from other environments and schedule your test runs! Take a tour!

More from Galter

validate-cpf-or-cnpj

Component is to validate the document number of a CPF or Brazilian CNPJ, indicates whether it is a document with valid or invalid syntax.

sql-advanced-query-samples-for-dummies

The purpose of this application is to present practical examples of using advanced SQL commands for your daily life, such as: SQL Tips (WITH NOLOCK or READUNCOMMITTED), Recursion using CTEs, temporary tables at session and global level, Pivot Table, Unpivot Table, APPLY commands (CROSS APPLY and OUTER APPLY), SPLIT_SQL() and spatial data (geometry and geography). Demonstration of the use of the EncodeSql () function to guarantee the security of the operation in question, as well as a practical example of Dynamic Sorting in Advanced Query.

jitsi-video-call

Video calling with jitsi - by iframe