How to call Salesforce REST API via ODBC driver

Introduction Salesforce is a popular CRM tool which lets you manage your sales, contacts, products and other useful things. In this tutorial, you will learn how to call Salesforce REST API via ODBC driver using ZappySys ODBC PowerPack. You will find out how to register a Connected App in Salesforce, set OAuth authentication and use it for […]

How to Import LinkedIn data in Power BI

Introduction In this article, we will learn how to import LinkedIn data in Power BI. For that, we will create a successful OAuth Connection then request for reading LinkedIn Profile data and loading into Power BI Power BI is a very popular Business Analytic tool used to get business information. It is very popular because it […]

Power BI Integration

Read Amazon S3 data in Power BI or Call AWS REST API (JSON / XML)

Introduction If you are looking around to find connectivity options to get Amazon AWS data in Power BI (e.g. Read from Amazon S3 files (CSV, JSON, XML) or get AWS API data such as Billing Data by calling REST API) then unfortunately as of now Power BI doesn’t support it natively. In this article, you will […]

Informatica PowerCenter Logo

Read JSON in Informatica – Import REST API / SOAP / JSON File

Introduction JSON / REST API is becoming more and more popular each day as everyone embrace cloud-centric services. This article is primarily focused on Informatica users who want to do XML SOAP/ JSON / REST API Integration in Informatica. However many tips and techniques described in this article will help you to understand how to integrate XML […]

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 […]