function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SFDC_RJSFDC_RJ 

SAlesforce ETL

I am very new to Saleforce integration . I want to bring in data from Web Based Third party system into salesforce . Volume of Data is big  .Data is in form of CSV file which needs to loaded back and forth from that application . Currently some scripts written by our org are doing so but it is ceating too many duplicates . I need some kind of ETL process , I guess . It is done async . Want to know what approach should we adopt . What are my options . I have just taken over this system . Any views on TAlend ?

 

Thanks 

Vinita_SFDCVinita_SFDC

Hello,

 

As you said there is lot of data, i would suggest you to go for BULK API implementation. Following is the list of APIs available, have a look and decide which one suits to your requirement.

 

https://help.salesforce.com/HTViewHelpDoc?id=integrate_what_is_api.htm&language=en_US

 

Bulk API implementation guide: http://www.salesforce.com/us/developer/docs/api_asynch/api_bulk.pdf

David ArchibaldDavid Archibald
You tell us that you are very new to Salesforce integration, so Talend can be rather complex for you, I can advise you to use easier service better no-coding at all, for example - Skyvia (https://skyvia.com/data-integration/salesforce-data-loader) or Workato (https://www.workato.com/)
SergeiSergei
The most cost effective and easy to use ETL for Salesforce - https://skyvia.com/connectors/salesforce