Introducing Flights: agent-native data pipelines in MotherDuckJoin the livestream

Skip to main content

Salesforce

Salesforce is a CRM platform for sales, marketing, service, and customer data. To analyze Salesforce data in MotherDuck, use an ingestion tool that supports Salesforce as a source and MotherDuck as a destination.

How it works with MotherDuck​

The most direct documented path is dlt, which has a Salesforce source and a MotherDuck destination.

  1. Install dlt with MotherDuck support.
  2. Initialize a Salesforce-to-MotherDuck pipeline.
  3. Configure Salesforce credentials and MotherDuck credentials in the generated .dlt/secrets.toml.
  4. Run the generated pipeline script to load Salesforce resources into a MotherDuck dataset.
pip install "dlt[motherduck]"

mkdir salesforce_pipeline
cd salesforce_pipeline
dlt init salesforce motherduck
pip install -r requirements.txt
python salesforce_pipeline.py

Managed ingestion platforms can also move Salesforce data into MotherDuck. Fivetran supports Salesforce as a source and MotherDuck as a destination. Airbyte supports Salesforce as a source and has a MotherDuck destination.

Related content​