I am automating a real estate trade process. It is a surprising complex process. I’m using Salesforce to implement the process. Salesforce doesn’t have a good reporting process. I need an automated way to extract the data from Salesforce and populate GantProject. I would then automatically create a report and email it. I would update the GanttProject weekly and send a new report. At any time there are between 3 - 20 active trades with different clients. I want it running on a Linux server. Since it is written in Java a Java API would be great. Does one exist?
I could use MS Project and VBA but MS Project won’t run on a server, not even IIS.