Apex Data Loader in Linux environment?
According to a requirement, we have to do data loading to Salesforce.com in Linux environment. In Windows, the Apex data loader works fine for data loading. Apex data loader is written in Java so it should work in Linux. How can we run the Apex data loader in Linux or is there any alternative application for data loading for linux?
Solution 1:
I was under impression that core of Data Loader is a JAR file so if your server is running Java you could fairly easily discard the GUI of application written for Windows?
- Please have a look at Data Loader User Guide, especially chapters about running it from command line and in batch mode. In worst case you could even roll out your own program that will use WebServices API exactly like Data Loader does (with reuse of the JAR or written from scratch).
- Another option would be to use "bulk API", designed for mass inserts. The guide for this is extremely technical and contains tons of useful info (including code of sample Java app).
- There's "Excel connector" and build of "LexiLoader" for MacOS but I don't think this helps a lot in your case.
- Last but not least - please consider the Salesforce partners, their AppExchange applications etc. I don't want to do marketing here but on my past project we were pleased with tool from "Relational Junction" (it was working on Unix server, easy to configure, connected with Oracle database, allowed us to pretty much do a proper Extract-Transform-Load proces to and from Salesforce).
Good luck!