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 add row numbers in SSIS data flow

Problem Sometimes Data Flow source does not contain an ID column, or a number indicating a row number, which you need in further steps. To solve this, you may use a free ZappySys PowerPack component Template Transform. So let’s take a look at how to accomplish that.     Tip Add Template Transform Go to […]

How to compare records in SSIS using hash

Introduction In this blog,  we are going to learn to how to compare records in SSIS using hash method. We will use FREE Template Transform component along with Sort Transform, Merge Join Transform and Conditional Split Transform. We will see how to produce hash value from multiple columns and later compare source\target hash values to detect changes\new rows. Data […]

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

ODBC PowerPack 1.6.0 released

Introduction This release brings tons of new features and bug fixes. We have added a new connector for Excel Driver. To see full release notes click here New Features/Improvements NEW: All API Drivers – Add support for OAuth 1.0 with SHA256 (Usecase like NetSuite API) NEW: All API Drivers – Add Support for Tls 1.3 NEW: All API Drivers […]

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

ODBC PowerPack 1.5.1 released

Introduction This release had many bug fixes. To see full release notes click here New Features/Improvements NEW: JDBC Bridge Driver – Prefix schema name to table when you select it from table dropdown and default query is generated (by default schema is not prefixed) Bug fixes FIX: All API Drivers – Add support for Page End Indicator / […]

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

SSIS PowerPack 4.2.3 released

Introduction This was a minor update release. It fixes important issues with API Source, API Destination, DynamoDB, Export XML Task, JSON Source, CSV Source, XML Source, Upsert Destination and Salesforce Source. To see full release notes click here New Features/Improvements NEW: API Connector – SharePoint Online – Add new endpoint get_list_items_dynamic to read complex datatypes (e.g. Lookup, […]

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

SSIS PowerPack 4.2.2 released

Introduction This was a minor update release. It have added a new API Connectors for Google Drive, SharePoint Online & Zoho. Also, It fixes important issues with API Source, API Destination, Salesforce Source and Web API Destination. To see full release notes click here New Features/Improvements NEW: API Connector – Google Drive – Add support for very […]

How To Connect ADP API using HTTP Connection over OAuth Connection

Introduction In this post, we will cover how to connect ADP API using HTTP connection manager over OAuth connection manager with JSON Source. ADP API works a bit differently with the OAuth connection manager. Let’s take a look at it… Prerequisites Before we perform the steps listed in this article, you will need to make sure the […]

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