bulkinsert
Service icon

BulkInsert

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

BulkInsert

5 star
24
1 Review |  24 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
27
Ratings
4.8
2
Reviews
by 
29 Aug
in version 2.1.13
Do you want to handle big data volume? that will help <3
by 
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 !