SSIS Salesforce Integration Pack

SSIS Salesforce Integration Pack

SSIS Salesforce Integration Pack is your complete toolset to automate Salesforce integration scenarios in SSIS. Using simple drag and drop interface you can read data from Salesforce or Bulk insert/update data into Salesforce. You can also execute any valid Salesforce API calls inside SSIS. It includes Salesforce Source Connector, Salesforce Destination Connector, Salesforce Connection Manager and Salesforce API Task.

Features

  • Multiple modes to read data from Salesforce CRM (i.e. Table or Query)
  • Support for SOQL Query Language (Salesforce Object Query Language)
  • Support for automatic conversion between UTC date/time and Local date/time
  • Intuitive user interface with Salesforce Object Browser
  • Support multiple write operations (e.g. Bulk Insert, Update, Delete, Upsert)
  • Support for OAuth Access Token (Helpful for 2FA / MFA )
  • Load data into Salesforce.com from any source with drag and drop user interface
  • Support multiple reade/write operations using BULK API Mode for large dataset (Table / SOQL Query)
  • Support for executing assignment rule after Update/Insert operation for Case, Lead or Account
  • Support for saving RawResult (e.g. JSON response) into SSIS variable
  • Support for calling any Salesforce REST API (RESTful API)
  • Support for calling any Salesforce SOAP API (XML API)
  • Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST )
  • Save response to variable or file
  • Filter JSON response using JSONPath to extract specific value inside response text
  • Filter XML response using XPath to extract specific value inside response text
  • Provide Report Progress for every N rows, also Report row count summary at the end (i.e. Total Rows=nnn, Inserted = nnn, Updated=nnn, Deleted=nnn, Error=nnn, Time Took=nn:nn:nn.nnn)
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: Salesforce related articles
Download Buy View All Tasks

SSIS Salesforce Source Connector (Query/Read/Extract CRM Data)

SSIS Salesforce Source Connector SSIS Salesforce Source Connector can be used to extract large amount of data from Salesforce.com without any programming. You can use simple Table mode or Query mode with full SOQL query language support (SOQL=Salesforce.com Object Query Language).

Read more

SSIS Salesforce Destination Connector (Bulk Insert, Update, Delete, Upsert)

SSIS Salesforce Destination Connector SSIS Salesforce Destination can be used to bulk insert/delete large amount of records to Salesforce storage from any data source using SSIS. 

Read more

SSIS Salesforce API Task (Call REST/SOAP API)

SSIS Salesforce API Task (Call REST/SOAP API) SSIS Salesforce API Task can be used to call any Salesforce.com API (e.g. REST/SOAP) which can be in XML or JSON format. This task provides easy way to save response into file or variable.

Read more

SSIS Salesforce Connection Manager

SSIS Salesforce Connection Manager SSIS Salesforce Connection Manager can be used with Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source to read/write Salesforce.com data or execute various actions via API calls.

Read more

 

Download View All Tasks