Home » json driver

Read data from QuickBooks Online into SQL Server via ODBC Driver

Posted on January 23, 2019September 26, 2023 by ZappySys

Introduction QuickBooks Online is a well-known Cloud-based Accounting Software. In this post, you will learn how to implement QuickBooks Online API Integration with SQL Server or any other RDBMS (e.g. Oracle, MySQL, Postgresql) using ODBC in few clicks. We will use ODBC JSON / REST API Driver to read data from QuickBooks Online and Load into SQL Server / other targets (Using OAuth […]

Load JIRA data into SQL Server with ODBC – Call REST API

Posted on November 17, 2018June 9, 2021 by ZappySys

Introduction In this blog, we will learn How to Load JIRA data in ODBC and load JIRA data into SQL Server Table, along with few other topics such as how to generate an API Token using Atlassian Account for JIRA REST API Call, how to read all Issues data from JIRA with ODBC. We will go through […]