SSIS Integration Toolkit for Directory Services Product Box - Package

Data Integration Made Easy

Experience More Features and Greater Performance for Salesforce Integration Projects

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.


Robust Features

Unlimited Integrations

Powered by the powerful SSIS ETL engine, developers can quickly integrate Salesforce with virtually any other application or data system.

SSIS Integration Toolkit for Salesforce includes Connection Managers, Source, and Destination components for connecting to Salesforce instances.

Youtube Video - Quick Overview of SSIS Integration Toolkit for Salesforce

SSIS Integration Toolkit for Salesforce

Advanced Integration Capabilities

  • Support both Salesforce REST and SOAP APIs, Salesforce Einstein Analytics (Also referred to as Wave Analytics, Tableau CRM), and Salesforce Marketing Cloud.

  • "Retry on intermittent errors" to deal with transient network or server problems in a robust fashion.

  • The most sophisticated support for SOQL queries, including the support for child-to-parent relationships, aggregation, datetime functions, and parameterized queries that utilize SSIS variables.

  • Support for Salesforce bulk API (both v1 and v2) for large-scale data reading and writing, including the capabilities in the destination component to output all processing details.

  • In-place picklist value mapping makes it easy to convert incoming option values to Salesforce picklist options with the ability to create new options on-fly while writing

  • Read data from either a Salesforce object or using an SOQL query.

  • Text Lookup feature makes Salesforce lookup references painlessly easy and it comes with many configurable options.

  • Seven different write actions for writing to the 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.

  • The "Refresh Salesforce Metadata" feature makes it easy to update components to the latest Salesforce metadata without having to delete and re-create them.

  • Equipped with many specifically designed integration options, the SSIS Integration Toolkit is the most flexible solution to read data from or write data to Salesforce.

See Technical Requirements

Codeless
Integration

You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.

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 an extremely simple licensing model, our solution offers the best value for your investment.

Unparalleled
Performance

Our software offers many specifically designed features that help you achieve the best possible performance without having to hijack your budget.

Data Integration Made Easy 
SSIS Integration Toolkit for Salesforce

Powered by modern cryptography and authentication technologies
for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.

DownloadPurchaseHelp Manual

Salesforce, Tableau CRM and Marketing Cloud Integration

Easily connect to your Salesforce/Tableau CRM instances for advanced data retrieval and writing through expanded actions.

Salesforce

Support for
Salesforce REST and SOAP APIs

Salesforce Marketing Cloud

Einstein (Wave) Analytics/Tableau CRM

Also Available
Salesforce Pardot
(via SSIS Productivity Pack)

Microsoft Dynamics 365 data integration

Client Testimonial


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

Salesforce SSIS Components

Salesforce SSIS Components

  • The Salesforce Connection Manager allows you to set up a connection in SSIS to Salesforce.
  • The 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.
  • The 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.
  •  See this component's documentation

Tableau CRM Destination

 Formerly known as Wave/Einstein Analytics

  • The 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).
  •  See this component's documentation

Salesforce Wave SSIS Destination Component

Salesforce Marketing Cloud SSIS Components

Salesforce Marketing Cloud SSIS Components

  • Salesforce Marketing Cloud Connection Manager allows you to set up a connection in SSIS to Salesforce Marketing Cloud.
  • The 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.
  • The 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.
  •  See this component's documentation

Get the Ultimate Edition to start using all integration toolkits, including our SSIS Productivity Pack

DownloadPurchase

More Resources

Download our Data Sheet for
SSIS Integration Toolkit for Salesforce

SSIS Salesforce Toolkit Data Sheet