---
title: "Data Source - Salesforce"
slug: "data-source-salesforce"
updated: 2025-12-17T09:53:17Z
published: 2025-12-17T09:53:17Z
canonical: "documents.trocco.io/data-source-salesforce"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documents.trocco.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Source - Salesforce

## summary

This is a help page for ETL Configuration of Data Destination of records managed in Salesforce, such as Opportunities, Leads, Business Partners, and Custom Objects.

## Setting items

### STEP1 Basic settings

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| Salesforce Connection Configuration | Yes | - | Select the previously registered [Salesforce Connection](/docs/connection-configuration-salesforce) Configuration that has the necessary permissions for this ETL Configuration. |
| API Version | Yes | 54.0 | Enter the version of the Salesforce API. |
| object | Yes | - | Enter the name of the object containing the data you wish to transfer. You can also load a list from **the Load Object List**. |
| Object Acquisition Method | Yes | - | Select one of the following options: **transfer****all object items** or **write a query (SOQL) and transfer**. |
| query | Yes | - | This is displayed when you **write a query (SOQL) and** select **transfer**. Write your query in [SOQL (Salesforce Object Query Language)](https://developer.salesforce.com/docs/atlas.ja-jp.220.0.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_sosl_intro.htm) format. For information on [how to create a SOQL](/docs/how-to-create-soql-with-developer-tool), see [How to Create a SOQL from the Developer Console](/docs/how-to-create-soql-with-developer-tool). |
| Extraction of deleted and archived records | Yes | non-extractive | Select whether or not to include records that have been deleted or archived in Salesforce in the extraction. When **"Extract" is** selected, records that have been deleted or archived are also included in the extraction. |
| type conversion mode | Yes | Use type guess results | Select the type conversion mode.Use type guess result: The column type is automatically guessed.Change custom columns to STRING type: All custom column types except BOOLEAN type are changed to STRING type. |