Salesforce is the world’s most trusted customer relationship management (CRM) platform. We help your marketing, sales, commerce, service and IT teams work as one from anywhere — so you can keep your customers happy everywhere.
Learn more about Salesforce.
This sync can be used to request and retrieve objects, fields and records data from a user specified data warehouse and send it to the Salesforce platform.
Learn more about what data can be integrated into your data warehouse using DataChannel in the documentation here.
1. Setup a Data Warehouse - Go to Data Warehouses Tab add an Azure Synapse Analytics Warehouse.
2. Setup a Data Model - Navigate to Data Models tab and click on Create New. Name your Data Model and select your data warehouse from the drop down. Write a SQL query to fetch data from your warehouse.
(Eg. Select * from Schema_Name.Table_Name)
*A simple “select” statement will work, although you can write complex SQL queries in the data model field itself or use our no-code segment builder to filter your data without writing complex SQL Queries.
You can fetch data directly from any table / view existing in your warehouse if you don’t want to set up a data model. In that case you can skip this step and directly move to configuring your destination.
3. Configure your Data Destination - Navigate to All Destinations Tab inside Reverse ETL and select Salesforce.
.png)
.png)
.png)
