Contents x
    Data Source - Salesforce
      • Print
      • PDF
      Contents

      Data Source - Salesforce

        • Print
        • PDF
        Article summary

        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.

        constraints

        Setting items

        STEP1 Basic settings

        item nameindispensabledefault valueContents
        Salesforce Connection ConfigurationYes-Select the previously registered Salesforce Connection Configuration that has the necessary permissions for this ETL Configuration.
        API VersionYes54.0Enter the version of the Salesforce API.
        objectYes-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 MethodYes-Select one of the following options: transfer****all object items or write a query (SOQL) and transfer.
        queryYes-This is displayed when you write a query (SOQL) and select transfer.
        Write your query in SOQL (Salesforce Object Query Language) format.
        For information on how to create a SOQL, see How to Create a SOQL from the Developer Console.
        Extraction of deleted and archived recordsYesnon-extractiveSelect 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 modeYesUse type guess resultsSelect 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.
        • Was this article helpful?
        What's Next