Salesforce Connection

Download Salesforce Attachment in SSIS

Introduction Download Salesforce Attachment in SSIS can be difficult the first time. In this new article, we will show how to download an Attachment from the Salesforce Source into a file using SSIS. Working with images is always tricky the first time. However, with the right article, this process is really simple. This article will show you how […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

ODBC PowerPack v1.1.4 Released

What’s New In this version we focused on many bug fixes. Among them most important bug was limitation of only 2000 characters for SQL Query using OPENQUERY statement. Now you can use up to 8000 characters for OPENQUERY and if that’s not enough use EXEC AT statement to send query to Data Gateway. We also […]

Read Salesforce Marketing Cloud data in SSIS (ExactTarget API)

Introduction In this post we will learn how to call Salesforce Marketing Cloud API using SSIS and load into SQL Server. We will show you use case of SSIS REST API Task  and SSIS JSON Source Basically there are two steps to call Salesforce Marketing Cloud API Obtain ClientID and ClientSecret ( Check these steps ) Get Access Token by […]

Read from Salesforce Custom Reports in SSIS / ODBC

Introduction In our previous posts we saw how to read and write Salesforce Data using SSIS. In this post we will see how to read Salesforce Metadata in SSIS using JSON Source. Later in this post we will show you how to integrate Salesforce data in Apps like Power BI, SSRS, Informatica and languages like C#, […]

How to call Salesforce REST API via ODBC driver

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 call Salesforce REST API via ODBC driver using ZappySys ODBC PowerPack. You will find out how to register a Connected App in Salesforce, set OAuth authentication and use it for […]

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 […]