How to call Amazon MWS API using SSIS

Introduction In this post you will learn how to call Amazon MWS API (Amazon Marketplace Web Service) or Amazon Product Advertising API using SSIS PowerPack. Using drag and drop approach you can consume data from Amazon MWS XML Web service. In this post we will use ZappySys XML Source connector to read data from Amazon MWS […]

Semantics3 API Call using SSIS OAuth1 Connection Manager

Call Semantics3 REST API in SSIS use OAuth1

Introduction In this post you will learn how to call Sementics3 REST API using SSIS PowerPack. Using drag and drop approach you can consume data from Semantics3 REST API service. In this post we will use ZappySys JSON Source connector to read data from Amazon MWS API and load into SQL Server. We will also use REST API Task […]

How to call MongoDB JavaScript using SSIS

Introduction SSIS PowerPack comes with great features for MongoDB Integration Scenarios but in this post we will focus on how to call MongoDB Javascript (Server side) using SSIS. For this purpose we will use SSIS MongoDB Execute SQL Task This powerful task not only easy to use but it supports calling any valid MongoDB commands […]

How to read / write Google SpreadSheet using SSIS

Introduction In this post you will learn how to get data from Google SpreadSheet (REST API) using SSIS. We will use drag and drop REST API connectors from SSIS PowerPack. No need to download any SDK or learn programming language (e.g. JAVA, C#, Ruby, Python) when you use SSIS PowerPack Connectors. We will use Google […]

SSIS Base64 Encode, Decode using SSIS Logging Task (Without coding convert plain text to base 64 string)

SSIS Base64 Encode Decode without Coding

Introduction In this post you will learn how to use FREE SSIS Logging Task to perform ssis base64 encode decode and save to Variable or File  (i.e. convert Base64 Encoded value to plain text or encode plain text to base64) . You can also use many other format specifiers found here How to invoke Placeholder […]

How to import XML into SQL Server using SSIS

Introduction In this post you will learn how to import XML file into target such as SQL Server, CSV, Excel, Oracle. Converting or Importing XML requires flattening XML structure (i.e. hierarchy) sometimes we refer this process as de-normalization.  Parsing XML can be tricky depending on how many levels you have and from which level you need data. […]

Start / Stop Fiddler Capture

Tutorial – How to use Fiddler to analyze HTTP Web Requests (Tips)

Introduction Fiddler is one the most popular tool to inspect your Http Traffic. This tool helps you to test REST API / SOAP Web requests very easily. If you are using SSIS PowerPack or REST API ODBC Drivers you will find this post really useful to debug various REST API integration issues. When you run Fiddler […]

Create new Amazon DynamoDB Connection in SSIS - Use Amazon DynamoDB Execute SQL Task - List Tables Example

How to Read / Write Amazon DynamoDB in SSIS

Introduction In this article we will look at how to Read / Write Amazon DynamoDB in SSIS. ZappySys developed many AWS related components but in this article we will look at 3 Tasks/Components for DynamoDB Integration Scenarios (Read, Write, Update, Bulk Insert, Create / Drop Table etc.). We will discuss how to use SSIS DynamoDB Source Connector […]

Tip – How to fix UI scaling issue on Windows 10 and 7

Problem Many customers reported issue regarding UI not scaling correctly on certain machines (windows 10 and windows 7). If you have similar issue then most likely its due to System Font Scale (DPI) is set to higher than 100%. Perform following steps to verify/fix it. Sometimes maximizing the window will show correct UI elements so […]