How to register Salesforce App and obtain Client ID / Secret (for API Call / OAuth)

Introduction Using Salesforce Connection with OAuth App in SSIS / ODBC Once you have Client ID / Secret, you can use it in the Salesforce Connection in SSIS Connector / ODBC Driver for Salesforce like below (Only the new version will have OAuth option) Troubleshooting Known Issues Let’s look at some common issues with Salesforce […]

Open Azure Active Directory

How to register App for Dynamics CRM 365 / CDS / Dataverse API (Azure AD / OAuth)

Introduction In this article, we will show you step by step approach on how to register an Azure AD (Active Directory) app to access Dynamics CRM 365 API (also same for CDS / Dataverse API). You might have heard that Microsoft is deprecating an older way of authenticating (i.e. User ID / Password-based WS-Trust Authentication) […]

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

ODBC PowerPack 1.4.2 released

Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around All API Drivers and Multi statement support in Salesforce Driver. We also added many new features in various drivers along with bug fixes/performance improvement features. To see full release notes click here New Features/Improvements NEW: All […]

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

SSIS PowerPack 4.1.3 released

Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features  in various tasks / components along with bug fixes / performance improvement features. To see full release notes […]

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

SSIS PowerPack 4.1.2 released

Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features  in various tasks / components along with bug fixes / performance improvement features. To see full release notes […]

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

SSIS PowerPack 4.1.1 released

Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features  in various tasks / components along with bug fixes / performance improvement features. To see full release notes […]

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

SSIS PowerPack 4.1.0 released

Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features  in various tasks / components along with bug fixes / performance improvement features. To see full release notes […]

Create a new connection

Download Gmail Attachment in SSIS

Introduction Downloading Gmail Attachments in SSIS is always a little more difficult than working with simple text or numeric columns. If you are not an SSIS expert, doing it for the first time may be challenging. That is why we created this article for you. This is a common request we receive, so we are […]

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

SSIS PowerPack 4.0.1 released

New Features/Improvements NEW: General – Modify installer to create license folder with correct permissions for all to prevent license related issue when running product under non-admin account NEW: JSON Source, CSV Source, XML Source – Add an option to support high precision / scale decimal numbers (more than 15 digits numbers) NEW: JSON Source, JSON Parser Transform- Add […]