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 […]
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 […]
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 […]
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 […]
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 […]
Many ETL workflows require generating JSON files and storing them in Amazon S3 for downstream applications, data lakes, backups, or API integrations. While ZappySys SSIS PowerPack includes a dedicated Amazon S3 CSV File Destination, many users ask whether there is a dedicated JSON destination for Amazon S3. The good news is that you can already […]
Introduction Birdeye is a customer experience and reputation management platform that helps businesses manage reviews, listings, messages, and customer interactions across channels. Many organisations need Birdeye data in Power BI to track review trends, location performance, customer sentiment, and service responsiveness. Using the ZappySys ODBC Driver for REST APIs, you can connect to Birdeye APIs, […]
Introduction Birdeye is a customer experience and reputation management platform that helps businesses manage reviews, listings, messages, and customer interactions across channels. Many organisations need Birdeye data in SQL Server for reporting, sentiment tracking, location performance analysis, and operational dashboards. In this tutorial, you will learn how to connect Birdeye APIs to SQL Server Integration […]
Introduction Pipedrive is a CRM platform used by sales teams to manage leads, deals, contacts, activities, and pipelines. Many organisations need this data in Power BI to monitor sales performance, pipeline health, conversion rates, and team productivity. Using ZappySys ODBC Driver for REST APIs, you can connect to Pipedrive APIs, query CRM data with SQL, […]
Introduction Pipedrive is a popular CRM platform used by sales teams to manage deals, leads, contacts, activities, and pipelines. It offers REST APIs that let you access CRM data programmatically. Many organisations extract Pipedrive data into SQL Server for operational reporting, sales dashboards, and analytics. In this tutorial, you will learn how to connect Pipedrive […]