Learn more
 

CData Software - Knowledge Base

Recent JSON ODBC Articles

Use the CData ODBC Driver for JSON in Microsoft Power Query

You can use the CData JSON ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import JSON into Microsoft Power Query.

How to Connect to & Open JSON Services in Microsoft Excel

This article uses the CData ODBC driver for JSON to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Extract, Transform, and Load JSON Services in Informatica PowerCenter

Create a simple Workflow for JSON in Informatica PowerCenter.

Standards-Based Access to NoSQL Data Sources

Create a schema to access MongoDB objects from any CData driver technology.

Visualize JSON Services in Tableau

The CData ODBC driver for JSON enables you integrate JSON into Tableau dashboards.

Author and Share Power BI Reports on Real-Time JSON Services

Use the CData ODBC Driver for JSON to visualize JSON in Power BI Desktop and then upload to the Power BI service.

Import and Visualize JSON Services in Power View

Create data visualizations based on JSON in Excel.

How to connect PolyBase to JSON

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live JSON.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Use the CData ODBC Driver for JSON from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for JSON to connect to JSON from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring JSON in Excel.

Analyze JSON Services in R

Create data visualizations and use high-performance statistical functions to analyze JSON in Microsoft R Open.

Query JSON Services as a MySQL Database in Node.js

Execute MySQL queries against JSON from Node.js.

Natively Connect to JSON Services in PHP

Create PHP applications on Linux/UNIX machines with connectivity to JSON. Leverage the native support for ODBC in PHP.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for JSON

Provide connectivity to JSON through an SAP BusinessObjects universe.

Explore Geographical Relationships in JSON Services with Power Map

Create data visualizations with JSON in Power Map.