Introduction In this article, we learn how to call SharePoint (on-premises) SOAP API Service in SSIS. If you intend to call SharePoint Online (part of Office 365), we suggest reading SSIS SharePoint Online Connector article. Using SOAP API with SharePoint in SSIS is a common requirement to Administer SharePoint. SharePoint on-premises is a nice Microsoft […]
Introduction This release brings tons of new features and bug fixes. We have added new connectors for API Source and API Destination. To see full release notes click here New Features/Improvements NEW: API Connection Manager – Add Support for RefreshTokenFilePath NEW: API Connector – DropBox – New connector to read / write data to DropBox (Upload, Download, Delete, […]
Introduction This release brings tons of new features and bug fixes. We have added new connectors for API Driver. To see full release notes click here New Features/Improvements NEW: All API Drivers – Allow to use Custom SQL for Virtual Table NEW: All API drivers – META with extended query syntax cause invalid syntax error NEW: All Drivers – […]
Introduction In our previous post, we saw how to read Salesforce data using SSIS Salesforce Source (Which uses SOAP API under the hood). This may be slow if you have millions of rows because Salesforce Source paginates every 2000 rows, so it’s not a good option to read millions of rows to iterate on a […]
Introduction In this post, we will see how to create SSIS Package Programmatically to use ZappySys SSIS PowerPack. This blog post assumes you have basic knowledge of Programming language like C# and you have installed Visual Studio Express or a similar product (VS Code not supported). Add SSIS Dll References The very first thing is […]
Introduction Using Salesforce Connection with OAuth App in SSIS / ODBC Once you have Client ID / Secret you can use in the Salesforce Connection in SSIS Connector / ODBC Driver for salesforce like below (Only new version will have OAuth option) Troubleshooting Known Issues Let’s look at some common issues with Salesforce Connection and […]
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) […]
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 […]
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 […]
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 […]