1

I was planning to build an automated Data Loader process that would read a CSV file and populated the Account and Opportunity entities. There would also be some Account matching on existing records.

Data Loader would have been a simple method to achieve that, however we have been directed that we must use a web service instead in order to comply with a future ESB strategy (the source system would also change from producing a CSV to calling the web service).

Defining a corresponding web service end point is simple in Salesforce.com, however are there any good strategies or AppExchange offerings that could replicate the configuration based Data Loader process and avoid APEX coding as much as possible?

(I'm aware of third party products such as Mulesoft and Informatica Cloud. Ideally I don't want to add a new product into the mix)

4
  • I heard Skyvva is quite versatile and installs from AppExchange right into your org.
    – dzh
    Nov 28, 2015 at 22:55
  • doing a custom solution means you have to take various limits into account - especially CPU time and heap size as large CSVs may/will cause you to hit these limits.
    – cropredy
    Nov 29, 2015 at 6:26
  • The Skyvva data loader appears to be a cloud based version of SFDC Data Loader. It doesn't appear to expose a web service to interface with?
    – user12646
    Nov 29, 2015 at 7:43
  • @Andrew You should probably contact SKYVVA support ([email protected]) directly about calling their webservices. Would you like to share a bit of info about your use case ?
    – altius_rup
    Nov 29, 2015 at 11:05

1 Answer 1

1

There are several AppExchange offerings. What they offer is a platform native installed version, versus a external client using the Force.com APIs. This is similar to the Data Import Wizard that you can fire up on the platform. The ones I have seen, including Skyvva, use an import file. There is a lot of functionality that these packages provide from a data cleansing perspective. Things like de-dup, external ID matching, error handing, etc.

Given the fact that file export is no longer acceptable, and you do not want to add in any other products, your only choice is to build out an orchestration on your own ESB using the SOAP or bulk REST API. Hopefully your mandated ESB/ETL tooling has a connector to simplify this task, and provide some cleansing abilities.

You must log in to answer this question.