Alooma can read and replicate all of the Salesforce objects from your Salesforce account. This allows you to, among other scenarios, merge client usage data with payment data to get insights on your business.
Before you can start importing your Salesforce data into your target data warehouse, you'll need to make sure that you have set the correct permissions on the objects you'd like to import.
Alooma synchronizes Salesforce data every 15 minutes. The synchronization contributes to your API calls count.
Our API call usage can be approximated using this formula: 4 (syncs per hour) * 24 (hours a day) * (number of replicated Salesforce objects) * 10 (API calls per object).
The first synchronization may take a few more API calls as the large batch of historical data is copied, and uses Salesforce's bulk API.
Once you've created a Salesforce input, you can see the status of the input synchronization in the upper left of the Live tab.
A Salesforce admin user will have to set "View All Data" permission on all of the objects you'd like to replicate.
You will also need to make sure that API Access is enabled.
You can connect Salesforce to Alooma in just a few steps:
From the plumbing screen, select Add new input.
Select Salesforce from the list of inputs.
Select the type of Salesforce instance (Production or Sandbox) and then click Connect to Salesforce. You will be prompted to log in to Salesforce. Enter your username and password.
Provide a name for the input. We’ll use the input name in the UI, but it won’t affect event naming. Note that after creation, the input name cannot be changed.
Select the objects you want to replicate from the list of available objects.
Under Advanced Settings, you can specify the start date for pulling data. Alooma will "backfill" data from this date. If you do not specify a date, Alooma will pull all historical data.
[Optionally] If you have strict Salesforce API call quotas, set a quota for the daily and bulk APIs. When we've hit the quota, we'll pause for 24 hours and then pick up where we left off.
Keep the mapping mode to the default of OneClick if you'd like Alooma to automatically map all Salesforce objects as is to your target data warehouse. Otherwise, they'll have to be mapped manually from the Mapper screen.
That's it, you're ready to replicate your Salesforce objects to your target data warehouse!