Introduction In this article, we will show you steps to register OAuth App for Zoho API and use it ZappySys Product. The steps listed here can be used for Zoho Products like CRM or ManagedEngine Products like ServiceDesk (ManageEngine is Zoho’s subsidary). For detailed steps check Zoho’s link here. Register OAuth App in Zoho Go to […]
How to Secure ZappySys Data Gateway (Network Settings)
Introduction In our earlier blog post, we have seen some of the wonderful features of ZappySys Data Gateway. Now, we are exploring in this blog more about How to Secure ZappySys Data Gateway? Some of the new features have been introduced in Network Settings tab of ZappySys Data Gateway. Network Settings On this tab we […]
SSIS PowerPack 4.2.1 released
Introduction This was a minor update release. It fixes important issues with DynamoDB and Salesforce Source. To see full release notes click here New Features/Improvements NEW: Add SiteId parameter to Sharepoint connector, Upload file endpoint NEW: API Connector – JIRA – Add columns to display custom fields with multi select values NEW: API Connector – Zendesk – Added Retry […]
Read data from SharePoint List in SSIS (On-Premises SOAP API)
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 […]
SSIS PowerPack 4.2.0 released
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, […]
ODBC PowerPack 1.5.0 released
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 – […]
How to query salesforce data using Bulk API in SSIS
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 making so its not good option to read millions of rows to iterate on a […]
How to create SSIS Package Programmatically (Add / Execute Tasks)
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 […]
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 in the Salesforce Connection in SSIS Connector / ODBC Driver for salesforce like below (Only new version will have OAuth option)
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) […]