How to authenticate to an API with OAuth 2.0 using SSIS / ODBC

Introduction In the world of REST APIs you have to know how to authenticate, before using any API method. In this article we will cover a topic how to authenticate to an API with OAuth 2.0 technology using SSIS or ODBC Drivers. We are going to use OAuth Connection Manager SSIS component to achieve that, which is a […]

How to call NetSuite RESTlet API in SSIS / ODBC

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

Create new SSIS OAuth API Connection Manager

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

Open ZappySys Data Gateway

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

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

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

sharepoint icon

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

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

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

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

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

Query Salesforce Data using Bulk API in SSIS (read using SOQL query in Bulk mode / large dataset)

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