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 Read API data in SSIS and Load into SQL Table

Introduction If you have need to integrate REST API in SSIS (i.e. fetch JSON, XML, CSV via HTTP call) and wondering how to Read API data in SSIS and Load into SQL DB (i.e. SQL Server, MySQL, Oracle) then you are at the right place. In this article we will cover simple step by step […]

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

ODBC PowerPack 1.3.0 released

Version 1.3.0.10909 [Sep 16, 2020] This version brings brand new JDBC Bridge driver which can connect data using any JDBC Driver in  ODBC Apps (e.g. Excel). Many vendors dont provide ODBC Driver because its expensive and complex to build so they simply supply you Java based JDBC Driver, however these JDBC drivers work only with […]

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

SSIS PowerPack 3.1.4 released

New Features/Improvements NEW: Dynamics CRM Destination – Add Support for Multiple Threads for faster performance (Added EnableParallelThreads, MaxParallelThreads Properties) NEW: General – Add new functions LOWER, UPPER, FUN_UNIX_TIMESTAMP_TO_DATE (When input is Seconds format) and FUN_UNIX_TIMESTAMP_MS_TO_DATE (When input is Milliseconds format) NEW: General – Add product Update notification (Show release notes when new available) NEW: General – Enforce License manager […]

How to call OneDrive API in SSIS (Upload, Download)

Introduction Microsoft Graph API is a unified way to access many Microsoft services API including OneDrive API. In our previous blog post we saw how to call Office 365 API Graph API. In this post, you will focus on how to access OneDrive API in SSIS and use REST API Task or connector like SSIS JSON / […]

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

SSIS PowerPack 3.1.3 released

New Features/Improvements NEW: HTTP Connection Manager – Allow option to set DynamicToken request as Form-Data (Multi-Part) request NEW: HTTP Connection Manager – For Dynamic Token option when Auth Scheme contains space do not suffix another space (e.g. MyAuthScheme sess-id=) NEW: JSON Source – Allow to set Custom Filter for Column Less 2D Array with First Line as Column […]

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

SSIS PowerPack v3.1.2 released

New Features/Improvements NEW: Dynamics CRM Destination – Allow to update OwnerID field in older CRM version (i.e. lower than v9) NEW: Dynamics CRM Destination – Use mapped type field in Update / Upsert operation to set EntityReference fields (e.g. ownerid ) – Right now system picks first type from Allowed LinkedEntity list (see Advanced Custom Properties) NEW: General […]

Importing Virtual Tables in MS Access (JSON REST API Example)

Using Custom Objects in ZappySys Drivers

Introduction ODBC PowerPack v1.2 release brought an interesting feature for all API drivers. New version gives you an ability to create Custom Objects. You can create parameterized Stored Procedure and Virtual Tables on the same Data Source (ODBC DSN or Data Gateway Data Source). Custom Stored Procedure You can create procedures to encapsulate custom logic […]

MongoDB Atlas Replicaset Cluster (Primary / Secondary Nodes)

How to connect to MongoDB Atlas in SSIS (Replica Set)

Introduction In our previous post we saw how to read / write MongoDB data using ZappySys MongoDB Source and Destination. However it was all about connecting to On Premises hosted version of MongoDB. In this post you will focus on specifically on how to connect to MongoDB Atlas in SSIS (MongoDB Hosted in Cloud). MongoDB Atlas […]