[Advanced Excel] How can upload bulk data(over 1 billion records) from excel to entities

Forge Component
(66)
Published on 2019-08-27 by Hanno
66 votes
Published on 2019-08-27 by Hanno

Hello everyone 

Please let me ask some questions.

How can I upload bulk data(over 1 billion records) from excel to entitiy and how to overcome timeout while uploading data.

Currently I use advance excel.If any other things which I can find in the forget please let me know.

Regards

Hi May Zin Linn

You might want to consider the following component:
https://www.outsystems.com/forge/component-overview/1117/bulkinsert 

Advanced Excel is not the ideal component for importing large amounts of data into the database.

Hanno

Hanno wrote:

Hi May Zin Linn

You might want to consider the following component:
https://www.outsystems.com/forge/component-overview/1117/bulkinsert 

Advanced Excel is not the ideal component for importing large amounts of data into the database.

Hanno

 Hello Thanks you for your reply and your sugession but I don't know how to use this extension.

Is there any sample oml associated with this extension.

If yes let me know Please.

Thanks

Hi May Zi Linn,

This is the subforum of Advanced Excel, not BulkInsert. Please ask a question int he BulkInsert subforum, thanks.