SSIS Salesforce Source Connector (CRM Connector)

SSIS Salesforce Source Connector (CRM)

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).

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 for data preview, max rows, batch size
  • Support for OAuth Access Token (Helpful for 2FA / MFA )
  • Support for Dynamic query (using SSIS Variable placeholder e.g. {{User::MyVar}} )
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see Salesforce related articles
  • NOTE:
    Read from Salesforce Custom report – use this technique
    Read metadata (table / fields) – this this technique

Download Help File Buy
View All Tasks
ScreenshotsArticles / Useful LinksSystem Requirements

SSIS Salesforce Connection Manager UI (Used with Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source)

SSIS Salesforce Connection Manager UI (Used with Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source)

SSIS Salesforce Connection Manager UI (Used with Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source)

SSIS Salesforce Source – Table mode (get data from Salesforce.com object)

SSIS Salesforce Source - Table mode (get data from Salesforce.com object)

SSIS Salesforce Source – Table mode (get data from Salesforce.com object)

SSIS Salesforce Source – Query mode (query data using SOQL language)

SSIS Salesforce Source - Query mode (query data using SOQL language)

SSIS Salesforce Source – Query mode (query data using SOQL language)

Articles / Tutorials

Click here to see all articles for [SSIS Salesforce Source] category


SSIS PowerPack v2.9.5 released (Maintenance Release)

SSIS PowerPack v2.9.5 released (Maintenance Release)

What’s New In this release we focused on fixing some bugs with Dynamics CRM Source , Dynamics CRM Destination and Reporting Services Task. Version 2.9.6.10621 [Jun 24, 2019] New Features/Improvements NEW: Excel Source – Add option to read from any sheet by number rather than hard coded table name (e.g. $4$ , $5$ … ) Bug fixes […]


How to export data from Salesforce to SQL Server using SSIS

How to export data from Salesforce to SQL Server using SSIS

Introduction Salesforce is a popular CRM tool which lets you manage your sales, contacts, products and other useful things. In this tutorial, you will learn how to export data from Salesforce to SQL Server using SSIS (part of SQL Server) and ZappySys PowerPack. In this article, we will extract Salesforce contacts and import them into a […]

Articles/Posts

Oracle Logo

Oracle CSV Export from Table or Query Data

Introduction In this article we will learn how to use ZappyShell Command Line Tools for Oracle CSV Export from Table or Query result ZappyShell for DB can export your Oracle data to CSV, PDF, Excel in one line command. This is just single exe less than 5 MB.. CSV export allows you to export data […]

0 comments
SQl Server Logo

SQL Server Excel Export from Table or Query data

Introduction In this article we will learn how to use ZappyShell Command Line Tools for SQL Server Excel Export from Table or Query result The problem SQL Server comes with few tools to export data to excel but if you ever try it you will realize its not as easy as it sounds. Solution There […]

0 comments
SQl Server Logo

SQL Server JSON Export from Table or Query Data

Introduction JSON File format is becoming very popular due to its simplicity and smaller size. Most of NoSQL Databases are now using JSON for their document mechanism. In this article we will learn how to use various techniques to generate JSON data files from SQL Server Table or any other relational source such as MySQL […]

SQl Server Logo

SQL Server CSV Export from Table or Query Data

Introduction In this article we will learn how to use ZappyShell Command Line Tools for SQL Server CSV Export from Table or Query result ZappyShell for DB can export your SQL Server data to CSV, PDF, Excel in one line command. This is just single exe less than 5 MB.. CSV export allows you to […]

0 comments

MySQL CSV Export from Table or Query result

Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL CSV Export from Table or Query result ZappyShell for DB can export your MySQL data to CSV, PDF, Excel in one line command. This is just single exe less than 5 MB.. CSV export allows you to export data […]

0 comments

MySQL Excel Export from Table or Query result

Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL Excel Export from Table or Query result The problem There is no native way of Exporting MySQL Data to Excel. You can use some coding techniques or libraries but when things become complex you will run out of options […]

1 comment

MySQL JSON Export from Table or Query result

Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL JSON Export from Table or Query result JSON File format is becoming very popular due to its simplicity and smaller size. Most of NoSQL Databases are now using JSON for their document mechanism. The problem There is no native […]

0 comments

References

Click here to learn more about System Requirements
Download View All Tasks Like This