SSIS Components for Salesforce Integration

The most powerful and feature-rich Salesforce integration solution.

Read from and write to Salesforce (REST/SOAP APIs), Einstein Analytics (Tableau CRM), Salesforce Marketing Cloud and Pardot.
Perform Create, Update, Upsert, Delete, Merge, and Hard Delete operations with high-performance Bulk API support.
Query data using objects or advanced SOQL, including relationships, aggregates, and parameters.

Download Book a Demo

KingswaySoft - Salesforce SSIS Data Integration Made Easy

When it comes to marketing platforms, having the most up-to-date information in your system is imperative. Avoid the embarrassment of sending the wrong email at the wrong time by keeping your Salesforce data synced with the other applications in your business.

Synchronize Data

Easily sync Salesforce with your CRM, ERP, or any other application, so customer records are always up-to-date. Bring more visibility across applications so each team knows exactly where each client is in the sales process.

Automate Business Processes

Marketing Automation cannot always handle the entire customer life-cycle itself, it relies on information from your other applications to help drive automation. Customer downloads a white paper? Let your sales team follow up in CRM. Your ERP says it is time for a customer to renew? Let Salesforce follow-up automatically.

Replicate Data

Data Archival

Easily replicate data from Salesforce for data archival and warehousing requirements.

Data Analytics

Easily retrieve data from Salesforce so it is available for your choice BI and Analytics platform.

Salesforce Data Integration is available in the SSIS Integration Toolkit

Download Purchase Help Manual

Video Tutorial

Get Started with Salesforce Components

Learn how to quickly connect, read, write, and synchronize data with Salesforce using KingswaySoft 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

Write to Einstein Analytics using Append, Delete, Overwrite, or Upsert with automatic dataset creation.
Automatically map input columns to destination fields with advanced tools for column resets, expression-based configurations, and external schema imports.
Define dataset properties with full control and receive upload notifications, while generating detailed documentation for metadata and field mappings.
See this component's documentation

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

Unique Features

Seamlessly connect, read from, and write to Salesforce directly within your SSIS packages.
Enjoy flexible connectivity, supporting both SOAP and REST API endpoints.
Benefit from secure and diverse authentication options, including advanced OAuth.
Perform comprehensive data operations including Create, Update, Upsert, Delete, Merge, Hard Delete, and Undelete.
Utilize Salesforce Bulk API for high-volume, fast, and efficient data processing.
Access powerful data querying capabilities, extracting precise data using objects or complex SOQL queries.
Ensure data consistency with intelligent picklist mapping and robust error control for non-matched values.
Gain granular control over error handling, with options to redirect failed rows to a dedicated error output.
Keep your integration aligned with Salesforce changes through automated metadata synchronization.
Execute custom Salesforce Apex code directly within your SSIS control flows.

Salesforce Data Integration Made Easy

Our solution is easy to use, offering code-less integration between Salesforce and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

Our Salesforceintegration solution is available within the SSIS Integration Toolkit, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Salesforce with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.

More SSIS CRM Components

Our CRM components make it easy to integrate with different services within the ETL process. Each service available has specific components that have been developed to work with all the intricacies of that particular CRM solution. In addition to Salesforce, we support the following CRM services:

Blackbaud

Copper CRM

Emarsys

Insightly

Freshsales

Dynamics 365 CE/CRM

Oracle CRM On Demand

Pipedrive

SugarCRM

SuiteCRM

Zoho Bigin

Zoho CRM

More Resources

Download our Data Sheet for
SSIS Components for Salesforce

Get In Touch

If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!