Introduction REST API is becoming the most popular way to communicate between multiple systems. In this blog post you will learn how to read data from JSON REST API or JSON File and import API to SQL Server Table (or any other target e.g. Oracle, MySQL, Flat File). We will use drag and drop approach (yes no coding […]
Monthly Archives: August 2017
How to configure MongoDB SSL Connection in SSIS
Introduction MongoDB comes with SSL support which can secure your end to end communication. However setting up MongoDB SSL Connection may require some configuration on both sides (i.e. Server and Client side). In this post our goal is to secure your MongoDB Integration in SSIS. Now lets look at steps to configure SSL in MongoDB. Configure […]
Tip – How to check file size before download from URL
Introduction In this article you will see how to use SSIS REST API Task to get file size without actually downloading it. Prerequisites Before we look into Step-By-Step section to get file size from URL let’s make sure you met following requirements. SSIS designer installed. Sometimes it is referred as BIDS or SSDT […]
How to use Office 365 API with SSIS (Mail, Calendar, Contacts, OneDrive, Excel)
Introduction In this post you will learn how to access Microsoft Graph API (Office 365 REST API / Sharepoint API) inside SSIS without any coding. Microsoft Graph API is a unified way to access many Microsoft services API including Office 365 API. In this post we will use SSIS JSON Source / REST API Connector to […]
Parse JSON array in SSIS or ODBC Drivers
Introduction In our previous post we saw how to parse JSON arrays. Now let’s look at more advanced techniques to parse multi-dimensional JSON array in SSIS ( e.g. 2D – JSON array inside array). We will use SSIS JSON Source to parse complex nested JSON in few clicks. Tips and Tricks mentioned in this article […]