Cochranville Ag Service

Cochranville Ag wanted to enable their users to generate Excel reports containing crop rotation information and customer data directly from the Salesforce interface. Given crop rotation reports from Salesforce, which contain huge volumes of complex information, they wanted to enable users to click a button and generate an informative and well-formatted Excel report.

They created an FME Workspace to query Salesforce based on given parameters, process the crop rotation data, and arrange the data in an informative Excel report. They then published this workspace to FME Cloud and used the FME Server REST API to connect it to a Salesforce workflow. Now, users can click a button to request an Excel report from Salesforce, and FME processes the job and delivers the report to them via email.

By running FME Workspaces from Salesforce, Cochranville enabled users to stay within their familiar environment, Salesforce, while leveraging the full power of FME for processing large volumes of complex data. Cochranville has also expanded their use of FME to include generating maps, FME Server apps, and HTML and Javascript reports.

“FME has become a great Enterprise Integration Platform for us.” -- John Glick, Cochranville Ag