HTML icon

How to read and write data to HTML in SSIS

Introduction to read and write data to HTML in SSIS In this article, we will show how to send values from an SSIS Variable to an HTML file. We will use the SSIS Advanced File System Task to store the list of system files of a folder into a variable and then we will use […]

SSIS Dynamics CRM – Read / Import data into SQL Server

Introduction Today Microsoft Dynamics CRM is one of the most popular CRMs in the world. SSIS Dynamics CRM read operation can be achieved using Dynamics CRM Source Connector. It allows connecting to Dynamics CRM 365 Online or On-Premises Installation / Hosted CRM instance (IFD – internet facing deployment). You can read data from Dynamics CRM […]

Using Data flow in SSIS

Calling Gmail REST API using SSIS – Read Emails

Introduction to get Gmail with REST API In this example, we will show how to read emails by calling Gmail REST API using SSIS. To illustrate, we will use ZappySys SSIS PowerPack, which includes several tasks to import/export data from multiples sources to multiple destinations like flat files, Azure, AWS, databases, Office files and more. […]

XML to JSON intro

How to Convert XML into JSON using SSIS

Introduction These days, JSON is more popular and it is replacing XML because it is faster, easier to use, it is shorter because it does not require tags and uses brackets instead. In this tutorial, we will learn how to convert XML into JSON using SSIS. So let’s get started. Requirements SSDT for business intelligence […]

The logo of Python

How to call REST API in Python (Read JSON / SOAP XML)

Introduction to REST API Call in Python In this article, we will cover how to call REST API in Python without using REST Python client. We will use ZappySys ODBC Driver for JSON / REST API. This driver allows querying RESTful API Services without extensive coding effort. For demo purpose, we will see examples to call […]

Parse JSON using SQL Server 2014 or lower

Parse JSON using SQL Server 2014 or lower Hello, this time we will show how to parse JSON in SQL Server 2014 or other versions. we will use a simple tool easy to use and we do not need programming knowledge. Solution In this article we will learn how to parse JSON in SQL Server using […]

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

Get data from Google Maps in SSIS using REST API

Full article coming soon. Meanwhile check following similar articles : SSIS XML Source (FILE, SOAP, REST API Connector) SSIS JSON Source (File, REST Connector) Read Zendesk data in SSIS using REST API Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol Get data from SurveyMonkey in SSIS using REST […]