Created on 24 November 2015
icon_unfollowing
Login to follow
bulkinsert

BulkInsert

Stable version 2.1.13 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded on 29 August 2023 by 
bulkinsert

BulkInsert

5 star
23
1 Review |  23 Ratings
4 star
1
0 Reviews |  1 Rating
3 star
2
0 Reviews |  2 Ratings
2 star
0
0 Reviews |  0 Ratings
1 star
0
0 Reviews |  0 Ratings
26
Ratings
4.8 Average rating
1
Review
by 
20 Mar (8 days ago)
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 !