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 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 […]
How to read Monday data in PowerBI using ODBC
Introduction Monday.com is a flexible work operating system that helps teams manage projects, workflows, and operations. Its GraphQL API allows you to access boards, items, groups, users, and activity data programmatically. In this tutorial, you will learn how to connect to monday.com using Zappysys ODBC Driver for REST APIs and query data using standard SQL. […]
SSIS tutorial: How to get data from Monday.com
Introduction Monday.com is a work operating system that provides a powerful GraphQL API for accessing boards, items, users, groups, and activity data. In this tutorial, you will learn how to connect monday.com to SQL Server Integration Services (SSIS) using Zappysys connectors and extract data without writing custom code. Because monday.com API uses GraphQL over HTTP, […]
How to extract data from Trello
Introduction Trello is a popular project management platform used by teams worldwide to organize tasks, track progress, and collaborate on projects. Many applications and tools need to integrate with Trello data for reporting, analytics, and business intelligence. Using Zappysys ODBC Driver for Trello, you can easily query card data, lists, and board information from Trello […]
SSIS tutorial: How to retrieve data from Trello
Introduction Trello is a popular project management platform used by teams worldwide to organize tasks, track progress, and collaborate on projects. Many organizations need to integrate Trello data with SQL Server for reporting, analytics, and business intelligence purposes. Using Zappysys SSIS PowerPack, you can easily extract card data, lists, and board information from Trello using […]
SSIS Tutorial: How to Extract Data from Firebase
Introduction Firebase is a popular cloud platform that provides real-time databases, cloud storage, and various backend services. Many organizations use Firebase to store application data and need to integrate it with their SQL Server databases for reporting, analytics, and business intelligence. Using Zappysys SSIS PowerPack, you can easily insert or extract data from Firebase Realtime […]
ODBC tutorial: How to get data from Tripletex
Introduction Tripletex is a cloud-based accounting and enterprise resource planning (ERP) platform designed for small to medium-sized businesses in Norway and other Scandinavian countries. It provides comprehensive financial management, invoicing, project accounting, and inventory management capabilities through a robust REST API. Integrating Tripletex with ODBC enables seamless data access between your accounting system and any […]