+ Start a Discussion
Atla MasthanaiahAtla Masthanaiah 

upload records

I have 6 millions recods.Those records insert into external system to salesforce how to achive it ?

Thanks
Alain CabonAlain Cabon
Hi,

You can use the dataloader with CSV files.

You can set the minimum and maximum heap size. For example, -Xms256m -Xmx256m sets the heap size to 256 MB.

Support for large files with up to 5 million records: it is a limit for a single file but you can split the file ( 5 + 1 ).

https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/data_loader.htm

http://www.runconsultants.com/blog/the-7-best-salesforce-data-loaders/

Receiving error "Java Heap Space" from the Data Loader UI:
https://help.salesforce.com/articleView?id=000170855&language=en_US&type=1

Alain
Anilkumar KotaAnilkumar Kota

Hello Atla Masthanaiah,

Salesforce have limitation of 5 million records through Dataloader. Best way to insert all records if those are related to one object please split the file and insert using dataloader with CSV Files.

 

https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/data_loader.htm

Amit Singh 1Amit Singh 1
Hi Atla,

You can also use any third party Data Integration Tool. Like Talend, Jitterbit etc.

You can download Talend which free to use and is OpenSource from the given link.
https://www.talend.com/download/

Thanks,
Amit Singh
Anilkumar KotaAnilkumar Kota
Better you can go with Batch apex to upload 5 million records and remaining you can go with dataloader
brahmaji tammanabrahmaji tammana

You can try with external tools like Jitterbit as dataloader can only process upto 5 million.

Thanks

Brahma