Introduction In this new article, we will see how to connect Java to REST API using a simple connector. This ODBC driver allows connecting to REST API or a local file in Java using SQL queries. If you are familiar with SQL, you can easily access to REST API or JSON using simple SQL queries. This article mainly […]
Introduction In this blog, we will learn How to read JIRA data in SSIS and load into SQL Server Table, along with few other topics such as how to generate an API Token using Atlassian Account for JIRA REST API Call, how to read all Issues data from JIRA with SSIS. We will go through the […]
Introduction Salesforce is a popular CRM tool that 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 JSON Driver. You can also use ZappySys Salesforce Driver for salesforce data read / write but this article covers more more […]
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 […]
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 […]
Introduction to Sentiment Analysis in SSIS In this article, we will show how to do sentiment Analysis in SSIS of text using artificial intelligence. It is very important for a company to measure customer satisfaction. Today, it is possible to do sentiment and use artificial intelligence and detect if a customer liked or not our […]
Introduction In this blog, we will learn How to read LinkedIn data in SSIS and load into SQL Server Table, along with few other topics such as how to register an OAuth App for LinkedIn REST API Call, how to retrieve basic profile data from LinkedIn, how to share a post on LinkedIn with SSIS. We […]
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 […]
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 […]
Introduction (Read REST / SOAP API in SSRS) In this tutorial, you will learn how to read REST API in SSRS (SQL Server Reporting Services). Traditionally to read data from XML / JSON Files or RESTful web service in SSRS, some sort of ETL approach was needed (i.e Load data from JSON / XML to SQL […]