Power BI Integration

How to read NetSuite data in Power BI

Introduction In our previous blog we discussed how to import REST / SOAP API data in Power BI. Now we will use that knowledge to read NetSuite data in Power BI (NetSuite CRM – SuiteTalk). We will use ZappySys XML Driver to call Search function in NetSuite SOAP API. If you are not familiar with SOAP […]

Pentaho logo

How to read REST API in Pentaho Kettle

Introduction In this article, we will learn how to read REST API in Pentaho Kettle. Pentaho is a very popular tool in Business Intelligence to integrate data for OLAP services and to create reports and dashboards. In this article, we will use our ZappySys ODBC PowerPack to connect to REST API in Pentaho Kettle. Our software requires the JDBC connector […]

Read from Salesforce Custom Reports in SSIS / ODBC

Introduction In our previous posts we saw how to read and write Salesforce Data using SSIS. In this post we will see how to read Salesforce Metadata in SSIS using JSON Source. Later in this post we will show you how to integrate Salesforce data in Apps like Power BI, SSRS, Informatica and languages like C#, […]

Qlik Sense logo

Qlik REST Connector Examples – Read JSON / XML API

Introduction In this article, we will learn to create a Qlik REST connector to OneDrive, Google, and other services. Qlik is a very powerful tool to analyze data from multiple sources and visualize, create relations and charts. It is a simple, but powerful tool used to visualize data. In this tutorial, we will show how to get […]

Logo REST API

How to export REST API to CSV using c# or Python

Introduction to export REST API to CSV Export REST API to CSV is in some cases necessary to process the data because many tools can handle CSV files. In this new article, we will show different ways to export the data. The first example will do it using C#. The second example with use Python. Let’s take a […]

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

Visual Studio show REST API information

Calling REST API in C# (Read JSON Data)

Introduction – REST API using C# In this post, We will use ZappySys ODBC Powerpack for calling REST API in C# (i.e. CSharp). We will create an ODBC connection to REST API and consume it different ways (e..g Bind API data to Data Grid, Combo Box or Write to File). ZappySys ODBC Driver allows to connect […]

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

Power BI Integration

Calling SOAP API in Power BI (Read XML Web Service data)

Introduction In our previous post, we saw in general how to call REST API in Power BI. Now let’s look at how to call SOAP API in Power BI (e.g. WorkDay, Google AdWords services). SOAP API is in XML format so we will be using ZappySys XML Driver for a demonstration in this article. To […]