How to read Microsoft Dynamics 365 OData API data in SSIS

Introduction In our previous article, we talked about how to read from Dynamics CRM using Dynamics CRM Source connector. In this post you will learn How to read Microsoft Dynamics 365 OData API data in SSIS using REST API Call (Drag and drop approach without any coding).  We will use SSIS JSON/ REST API Source to extract data from Dynamics […]

Read SAP S4 / HANA data in SSIS (OData REST API)

Introduction In out previous post we saw how to call REST API in SSIS. Now let’s learn how to read data from SAP S4 / HANA OData Service (i.e. S/4HANA). SAP HANA provides OData REST API interface to access data in your application using HTTP Protocol. We will use SSIS XML Source component to read SAP […]

OData Paging using SSIS JSON Source

How to read OData in SSIS – REST API Example

Introduction In this article we will learn how to use SSIS JSON Source Component to fetch JSON data from OData service and perform OData Pagination of large result. In OData specification data may come in JSON format or XML format. For XML format check this article. This article will cover mostly OData JSON API example. REST […]

Logo REST API

How to Call REST API in SSIS – Read JSON / XML / CSV

Introduction REST API is becoming more and more popular in Data Integration landscape. If you are SSIS Developer (not a coder) and stumbled upon a question what is REST API and “how to consume API inside SSIS package?” then you are at the right place :). We encourage you to read this article carefully and follow […]