SSIS Integration Toolkit for Salesforce

The most performant and feature-rich Salesforce data integration solution on the market

Experience more features and greater performance for your Salesforce data integration project.

The SSIS Integration Toolkit for Salesforce is the most performant and feature rich data integration solution for Salesforce on the market. With a meticulously designed software that leverages the power of the SSIS ETL engine for a familiar development experience, your integration job can be completed 3 to 10 times faster.

Salesforce CRM and Marketing Cloud Integration

  • An extremely simplified ETL development experience within a familiar development environment (Microsoft Visual Studio) provides your developers the best possible development productivity.
  • Intuitive user interface to manage different aspects of your integration development in a codeless, drag and drop environment.
  • Robust error handling and superior performance.
  • Text Lookup feature makes Salesforce lookup references painlessly easy and it comes with many configurable options.
  • Includes support for writing to Salesforce Wave Analytics (also known as Salesforce Einstein Analytics) using the Salesforce Wave Destination component.
  • Includes support for Salesforce Marketing Cloud using Salesforce Marketing Cloud Connection Manager, Salesforce Marketing Cloud Source, and, Salesforce Marketing Cloud Destination.
  • Equipped with many specifically designed integration options, the SSIS Integration Toolkit is the most flexible solution to read from or write to Salesforce.
  • Integration can be done with virtually any application or data source that you may need to work with, including NetSuite, HubSpot, Microsoft SharePoint, Active Directory and any other solution available in the Ultimate Edition. Support for Salesforce Pardot is available via the SSIS Productivity Pack.

Youtube Video - Quick Overview of SSIS Integration Toolkit for Microsoft Dynamics CRM

  • fill

    Codeless Integration

    You do not have to write a single line of code
    to make data integration happen; your development
    can be done in a matter of minutes, which would
    otherwise take weeks or even months


    Unparalleled Performance

    Our software offers many specifically designed
    features that help you achieve the best possible
    data integration performance, while rescuing your
    IT budget


    Flexible and Easy to Use

    We make the most flexible integration solution
    on the market. Our software offers intuitive user
    interfaces that are flexible and easy to use


    Cost Effective

    With a streamlined development experience,
    and a simplified licensing model, our solution
    offers the best value for your investment

  • fill

    Database Developers can be fully utilized to
    create complex data integrations or migrations
    from start to finish without the need for additional
    development resources.


    Chris LaBadie, Senior Database Developer, Sonoma Partners

Unique Features

  • "Retry on intermittent errors" to deal with transient network or server problems in a robust fashion.
  • Read data from either a Salesforce object or using SOQL query
  • The most sophisticated support for SOQL queries, including the support for child-to-parent relationship, aggregation, datetime functions, and parameterized queries that utilize SSIS variables.
  • Support for Salesforce bulk API
  • "Refresh Salesforce Metadata" feature makes it easy to update components to latest Salesforce metadata without having to delete and re-create them.
  • Seven different write actions for writing to Salesforce server: Create, Update, Delete, Upsert, Merge, HardDelete, and UnDelete.
  • Automatically maps all available input columns to the corresponding Salesforce fields by matching their names.
  • Text Lookup feature to perform a lookup to Salesforce records using either text or integer values as the input
  • "Ignore Null-Valued Fields"  to avoid overwriting existing values with an empty value.
  • Write to Salesforce Wave Analytics (Einstein Analytics) using Append, Delete, Overwrite and Upsert operations.

Salesforce SSIS Components

Salesforce Connection Manager

Salesforce Connection Manager

Salesforce Connection Manager allows you to setup a connection in SSIS to Salesforce

Salesforce Source Component

Salesforce SSIS Source Component

Salesforce source component is a source component that you can use in SSIS data flow tasks, which allows you to read data from your Salesforce.com organization.

Salesforce Destination Component

Salesforce SSIS Destination Component

Salesforce destination component is a destination component that you can use in SSIS data flow tasks, so that you can write data to your Salesforce.com organization.

Salesforce Wave Destination Component (also for Salesforce Einstein Analytics)

Salesforce Wave SSIS Destination Component

Salesforce Wave Destination component is a destination component that you can use in SSIS data flow tasks, so that you can write data to Salesforce Wave Analytics (Einstein Analytics).

Salesforce Marketing Cloud Connection Manager

Salesforce Marketing Cloud Connection Manager

Salesforce Marketing Cloud Connection Manager allows you to setup a connection in SSIS to Salesforce Marketing Cloud.

Salesforce Marketing Cloud Source Component

Salesforce Marketing Cloud Source Component

Salesforce Marketing Cloud source component is a source component that you can use in SSIS data flow tasks, which allows you to read data from your Salesforce Marketing Cloud organization.

Salesforce Marketing Cloud Destination Component

Salesforce Marketing Cloud Destination Component

Salesforce Marketing Cloud destination component is a destination component that you can use in SSIS data flow tasks, so that you can write data to your Salesforce Marketing Cloud organization.

Technical Requirements

  • Salesforce CRM, either:
    • Salesforce Professional Edition,
    • Salesforce Enterprise Edition, or,
    • Salesforce Unlimited Edition.
  • Big Data
    • Salesforce Wave Analytics (Einstein Analytics)
  • Marketing
    • Salesforce Marketing Cloud
  • Microsoft SQL Server Integration Services, either:
    • Azure-SSIS Integration Runtime,
    • Microsoft SQL Server 2019,
    • Microsoft SQL Server 2017,
    • Microsoft SQL Server 2016,
    • Microsoft SQL Server 2014,
    • Microsoft SQL Server 2012,
    • Microsoft SQL Server 2008 R2, or,
    • Microsoft SQL Server 2008.