How to authenticate to an API with OAuth 2.0 using SSIS / ODBC

Introduction In the world of REST APIs you have to know how to authenticate, before using any API method. In this article we will cover a topic how to authenticate to an API with OAuth 2.0 technology using SSIS or ODBC Drivers. We are going to use OAuth Connection Manager SSIS component to achieve that, which is a […]

How to get data from Bluebeam into Power BI

Introduction Bluebeam Studio is a cloud collaboration platform that construction and design teams use to run drawing reviews, markups, and document handoffs through Bluebeam Revu. Many organizations need Bluebeam Studio data in Power BI to monitor Session activity, Project status, and review turnaround. Using the ZappySys ODBC Driver for REST APIs, you can query Bluebeam […]

SSIS Tutorial: How to get data from Bluebeam

Introduction Bluebeam Studio is a cloud collaboration platform that construction and design teams use to run drawing reviews, markups, and document handoffs through Bluebeam Revu. Many organizations need Studio Sessions, Projects, and Jobs data in SQL Server for reporting, audit trails, and project tracking. In this tutorial, you will learn how to connect to the […]

How to get data from ShipStation into Power BI

Introduction ShipStation is a leading shipping and order management platform used by eCommerce businesses to manage orders, shipments, and fulfillment across multiple sales channels. Many organizations need ShipStation data in Power BI to monitor fulfillment performance, shipping costs, and order trends. Using the ZappySys ODBC Driver for REST APIs, you can query ShipStation API data […]

SSIS Tutorial: How to get data from ShipStation

Introduction ShipStation is a leading shipping and order management platform used by eCommerce businesses to manage orders, shipments, and fulfillment across multiple sales channels. Many organizations need ShipStation data in SQL Server for reporting, logistics analytics, and fulfillment performance tracking. In this tutorial, you will learn how to connect to the ShipStation REST API using […]

How to get data from Hivebrite into Power BI

Introduction Hivebrite is a community management platform used for memberships, events, directories, and engagement workflows. Many organizations store operational data in Hivebrite and need to migrate it to Power BI for reporting, analytics, and business intelligence. In this tutorial, you will learn how to read Hivebrite API data directly from Power BI by using the […]

How to get data from Spotify into Power BI

Introduction Spotify Web API exposes rich data for artists, albums, tracks, playlists, and categories. If you want to build dashboards from this data, you can connect Spotify to Power BI through an ODBC layer and query API responses using SQL. In this tutorial, you will learn how to configure the ZappySys ODBC Driver for REST […]

SSIS Tutorial: How to get data from Spotify

Introduction Spotify provides rich music and podcast metadata through its Web API, including artists, albums, tracks, playlists, and categories. Many data teams need this data in SQL Server for analytics, trend reporting, and catalog enrichment. In this tutorial, you will learn how to connect Spotify API data to SQL Server Integration Services (SSIS) by using […]

SSIS Tutorial: How to get data from Hivebrite

Introduction Hivebrite is a community management platform used for memberships, events, directories, and engagement workflows. Many teams need Hivebrite data in SQL Server for reporting, segmentation, and operational analytics. In this tutorial, you will learn how to connect Hivebrite API data to SQL Server Integration Services (SSIS) by using ZappySys SSIS PowerPack. You can then […]

How to get data from Cin7 into Power BI

Introduction Cin7 is a connected inventory and order management platform used by growing businesses to synchronise products, stock, orders, and customer data across sales channels. Many organisations need Cin7 data in Power BI to monitor inventory health, order trends, and fulfilment performance. Using the ZappySys ODBC Driver for REST APIs, you can query Cin7 REST […]

SSIS Tutorial: How to get data from Cin7

Introduction Cin7 is a connected inventory and order management platform used by growing businesses to synchronise products, stock, orders, and customer data across multiple sales channels. Many organisations need Cin7 data in SQL Server for reporting, demand planning, fulfilment tracking, and analytics. In this tutorial, you will learn how to connect to Cin7 REST APIs […]