The SSIS Integration Toolkit for Salesforce components to facilitate integration with Salesforce applications.

The toolkit includes 2 connection managers and corresponding Source and Destination components to connect to Salesforce service. For your convenience these components are split among the appropriate 3 categories within this Help Manual.

You will need to use the appropriate group of components in order to perform the integration with your desired application.

  • Use the Salesforce Components to facilitate your integration/migration with Salesforce.com.
  • Use the Salesforce Marketing Cloud Components to facilitate your integration/migration with Salesforce Marketing Cloud.
  • Use the Salesforce Wave Destination component to facilitate your integration/migration with Salesforce Wave Analytics.

These components can be used with any other SSIS component to create your integration or migration project.

Installation and Setup

Salesforce
  • Salesforce Connection Manager
    • Salesforce connection manager allows you to specify how you want to connect to Salesforce.com.
  • Salesforce Source Component
    • Salesforce Source Component is an SSIS data flow pipeline component that can be used to read / retrieve data from your Salesforce.com instance. Salesforce source component supports using either a Salesforce object, or an object query statement as the data source.
  • Salesforce Destination Component
    • Salesforce Destination Component is an SSIS data flow pipeline component that can be used to write data to your Salesforce.com instance. You may Create, Update, Delete, Upsert, Merge, or HardDelete Salesforce records using the Salesforce Destination Component.

Youtube Video - Getting started with the SSIS Integration Toolkit for Salesforce

Salesforce Marketing Cloud
  • Salesforce Marketing Cloud Connection Manager
    • Salesforce Marketing Cloud connection manager allows you to specify how you want to connect to Salesforce Marketing Cloud.
  • Salesforce Marketing Cloud Source Component
    • Salesforce Marketing Cloud Source Component is an SSIS data flow pipeline component that can be used to read / retrieve data from your Salesforce Marketing Cloud instance.
  • Salesforce Marketing Cloud Destination Component
    • Salesforce Marketing Cloud Destination Component is an SSIS data flow pipeline component that can be used to write data to your Salesforce Marketing Cloud instance. You may Create, Update, Delete, or Upsert Salesforce Marketing Cloud records using the Salesforce Marketing Cloud Destination Component.
Salesforce Wave Analytics
  • Salesforce Wave Destination Component
    • Salesforce Wave Destination Component is an SSIS data flow pipeline component added since v7.0 release that can be used to write data to the Salesforce.com Wave Analytics platform. Salesforce Wave Destination Component includes the following two pages to configure how SSIS writes data to Salesforce Wave Analytics.