Introduction In our previous post we saw how to read API data in SSIS. This post we will cover how to call NetSuite RESTlet to read / write data in SSIS or ODBC Apps. For demo purpose we will use SSIS PowerPack REST API Task but concepts and many UI elements remain same for ODBC […]
Read/Write ManageEngine ServiceDesk Data in SSIS (Zoho API)
Introduction In this post, you will learn how to read / write ManageEngine ServiceDesk data in SSIS (Drag and drop approach without any coding). We will use SSIS JSON/ REST API Source to extract data from Servicedesk API and use SSIS Web API Destination to write data to Zoho. We will look at step-by-step instructions to read ServiceDesk data […]
How to register OAuth App for Zoho / ManageEngine API
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 […]