Salesforce and Database User Aggregation

Aggregate users from Salesforce and a database into a CSV file.

See Salesforce and Database User Aggregation

Description

This template is designed to aggregate (collect) user from Salesforce and a database into a CSV file. This basic pattern can be modified to collect from more or different sources and to produce formats other than CSV. It is triggered by a http call so it can be used manually or programmatically. Users are sorted such that the accounts only in Salesforce show up first, followed by users only in the database, and lastly by users found in both systems. The custom sort or merge logic can be easily modified to present the data as needed. This template also serves as a great base for building APIs using the Anypoint Platform. A database table schema is included to make testing this template easier.

Aggregation templates can be easily extended to return a multitude of data in mobile friendly form to power your mobile initiatives by providing easily consumable data structures from otherwise complex backend systems.