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 Birdeye into Power BI
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, […]
SSIS Tutorial: How to get data from Birdeye
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 […]
How to get data from Pipedrive into Power BI
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, […]
SSIS tutorial: How export data from Pipedrive
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 […]
How to read WooCommerce data in Power BI using ODBC
Introduction WooCommerce is one of the most widely used eCommerce platforms for WordPress websites. Store owners and analysts often need to combine WooCommerce order, product, and customer data with other business metrics in Power BI for reporting and decision-making. Using Zappysys ODBC Driver for REST APIs, you can connect WooCommerce to Power BI and query […]
SSIS tutorial: How to get data from WooCommerce
Introduction WooCommerce is one of the most popular eCommerce platforms for WordPress. It provides REST APIs to access products, orders, customers, coupons, and other store data. Many teams need to migrate WooCommerce data to SQL Server for reporting, operational dashboards, and analytics. In this tutorial, you will learn how to connect WooCommerce APIs to SQL […]
How to read GitHub data in Power BI using ODBC
Introduction GitHub is a leading platform for source control, CI/CD workflows, and team collaboration. Many organizations need GitHub data in Power BI to monitor engineering performance, repository health, pull request velocity, and issue resolution trends. Using ZappySys ODBC Driver for REST APIs, you can connect to GitHub and query GitHub data with SQL, then load […]
SSIS tutorial: How to get data from Github
Introduction GitHub is one of the most widely used platforms for source control, DevOps collaboration, and software delivery. Teams often need GitHub data, such as repositories, issues, pull requests, and commits, in SQL Server for analytics, reporting, and governance. In this tutorial, you will learn how to connect GitHub REST APIs to SQL Server Integration […]
How to read Notion database table in PowerBI using ODBC
Introduction Notion is a versatile workspace platform that many teams use to manage projects, tasks, documentation, and databases. However, to leverage this data for advanced analytics and business intelligence, you need to connect it to tools like Power BI. Using Zappysys ODBC Driver for Notion, you can seamlessly extract data from Notion databases and visualize […]
SSIS tutorial: How to get data from table in Notion
Introduction Notion is a popular workspace platform used by teams to manage projects, documentation, tasks, and databases in one place. Many organisations store operational data in Notion and need to migrate it to SQL Server for reporting, analytics, and business intelligence. Using Zappysys SSIS PowerPack, you can connect SSIS to Notion REST APIs and extract […]