You can sync data from your database or warehouse → Salesforce with a simple SQL statement.
Using the Mapping UI
1. To start sending your database data to Salesforce, Authorize the app.
2. Write your SQL query in the app for the data you want to send to Salesforce and view the results. Be sure to include the Id
for the record in Salesforce. If you don't already have that in your database, you can query Id
.
3. Select "Salesforce" as the Destination and select your object (e.g. Account) and operation (e.g. update).
4. Click "Mapping" next to Results under your query.
5. In the Mapping UI, select columns from your query and map them to the fields in Salesforce you want to send them to.
6. Click "Test Sync" once you've mapping all your columns to their corresponding fields in Salesforce to ensure the sync is working. If the records haven't updated, you can view your job statuses in Salesforce under Setup → Bulk Data Load Jobs. Click on the "Job ID" and scroll down to view any errors. You can also view background job errors in the SeekWell App's Feed.
7. Add a schedule under "Repeat" so your sync runs regularly and your Salesforce data is always up-to-date!
Null values
Use the special value #N/A
to "blank out" or set a field to NULL
. For example:
select
u.salesforce_id as "Id",
u.email as "Email",
case when u.some_column is null then '#N/A' else u.some_column as "Custom_Data__c"
from public.users as u
Upserts
You need to specify an External ID (such as email) for upserts.
Using Parameters
You can also use Parameters to map your columns to their corresponding fields in Salesforce, as in the video below:
