JSON
 

Connect to JSON Services through easy-to-use bi-directional data drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



Connect to JSON Data from Anywhere!

Easily access live JSON data from BI, Analytics, Reporting, ETL, & Custom Apps.







JSON Integration Guides and Tutorials

BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time JSON data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to JSON data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations


Alteryx Designer: Prepare, Blend, and Analyze JSON in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from JSON in Amazon QuickSight Aqua Data Studio: Connect to JSON in Aqua Data Studio Birst: Build Visualizations of JSON in Birst BIRT: Design BIRT Reports on JSON Clear Analytics: Build Charts with JSON in Clear Analytics DBxtra: Build Dashboards with JSON in DBxtra Domo: Create Datasets from JSON in Domo Workbench Dundas BI: Build Dashboards with JSON in Dundas BI FineReport: Feed JSON into FineReport Google Sheets: Access Live JSON in Google Sheets IBM Cognos BI: Create Data Visualizations in Cognos BI with JSON Infragistics Reveal: Analyze JSON Data in Infragistics Reval JasperServer: Create JSON Reports on JasperReports Server Jaspersoft BI Suite: Connect to JSON in Jaspersoft Studio JReport Designer: Integrate with JSON in JReport Designer Klipfolio: Create JSON-Connected Visualizations in Klipfolio KNIME: Enable the JSON JDBC Driver in KNIME LINQPad: Working with JSON in LINQPad Looker Studio: Create Reports from JSON in Looker Studio Metabase: Create Interactive JSON-Connected Metabase Dashboards Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula Microsoft SSAS: Build an OLAP Cube in SSAS from JSON MicroStrategy: Connect to Live JSON in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for JSON in MicroStrategy OBIEE: JSON Reporting in OBIEE with the JSON JDBC Driver pandas: Use pandas to Visualize JSON in Python Pentaho Report Designer: Integrate JSON in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time JSON Power BI Service: Visualize Live JSON in the Power BI Service QlikView: Connect to and Query JSON in QlikView over ODBC R: Analyze JSON in R RapidMiner: Connect to JSON in RapidMiner SAP Analytics Cloud: Analyze JSON in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for JSON SAP Crystal Reports: Publish Reports with JSON in Crystal Reports SAS: Use the CData ODBC Driver for JSON in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live JSON in Sisense Spago BI: Connect to JSON in SpagoBI Tableau Cloud: Build JSON Visualizations in Tableau Cloud Tableau Server: Publish JSON-Connected Dashboards in Tableau Server Tableau: Visualize JSON in Tableau Desktop TIBCO Spotfire Server: Operational Reporting on JSON from Spotfire Server TIBCO Spotfire: Visualize JSON in TIBCO Spotfire through ADO.NET Visio: Link Visio Shapes to JSON

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with JSON connectivity to ETL/ELT tools for replication — our JSON integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with JSON to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations


Amazon Redshift: Automated Continuous JSON Replication to Amazon Redshift Amazon S3: Automated Continuous JSON Replication to Amazon S3 Apache Camel: Integrate with JSON using Apache Camel Apache NiFi: Bridge JSON Connectivity with Apache NiFi BIML: Use Biml to Build SSIS Tasks to Replicate JSON to SQL Server CloverDX: Connect to JSON in CloverDX (formerly CloverETL) Databricks: Automated Continuous JSON Replication to Databricks FoxPro: Work with JSON in FoxPro Google AlloyDB: Automated Continuous JSON Replication to Google AlloyDB Google BigQuery: Automated Continuous JSON Replication to Google BigQuery Google Cloud SQL: Automated Continuous JSON Replication to Google Cloud SQL Google Data Fusion: Build JSON-Connected ETL Processes in Google Data Fusion HULFT Integrate: Connect to JSON in HULFT Integrate Informatica Cloud: Integrate JSON in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for JSON Jaspersoft ETL: Connect to JSON in Jaspersoft Studio Microsoft Excel: Transfer Data from Excel to JSON Microsoft Power Automate: Build JSON-Connected Automated Tasks with Power Automate (Desktop) Oracle Data Integrator: ETL JSON in Oracle Data Integrator petl: Extract, Transform, and Load JSON in Python Replicate to CSV: Replicate JSON to MySQL with PowerShell SingleStore: Automated Continuous JSON Replication to SingleStore SnapLogic: Integrate JSON with External Services using SnapLogic Snowflake: Automated Continuous JSON Replication to Snowflake SQL Server Linked Server: Connect to JSON as a SQL Server Linked Server Talend: Connect to JSON and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to JSON in UiPath Studio Vertica: Automated Continuous JSON Replication to a Vertica Database

Workflow & Automation Tools


Connect to JSON from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to JSON data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations


MuleSoft Anypoint: Access JSON in Anypoint Using SQL Power Automate: Integrate JSON into Power Automate Automated Tasks SSIS Export: Export Data from SQL Server to JSON through SSIS SSIS Import: Import JSON Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing JSON Records from SQL Server

Developer Tools & Technologies


The easiest way to integrate with JSON from anywhere. Our JSON drivers offer a data-centric model for JSON that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations


.NET Charts: DataBind Charts to JSON .NET QueryBuilder: Rapidly Develop JSON-Driven Apps with Active Query Builder Apache Spark: Work with JSON in Apache Spark Using SQL AppSheet: Create JSON-Connected Business Apps in AppSheet ColdFusion: Query JSON in ColdFusion Dash: Use Dash & Python to Build Web Apps on JSON DevExpress: DataBind JSON to the DevExpress Data Grid EF - Code First: Access JSON with Entity Framework 6 EF - LINQ: LINQ to JSON EF - MVC: Build MVC Applications with Connectivity to JSON Filemaker Pro: Bidirectional Access to JSON from FileMaker Pro Go: Write a Simple Go Application to work with JSON on Linux Google Apps Script: Connect to JSON in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with JSON Entities in Java IntelliJ: Connect to JSON in IntelliJ JBoss: Connect to JSON from a Connection Pool in JBoss JDBI: Create a Data Access Object for JSON using JDBI JRuby: Connect to JSON in JRuby Microsoft Power Apps: Integrate Live JSON into Custom Business Apps Built in Power Apps NodeJS: Query JSON in Node.js (via Connect Server) NodeJS: Query JSON through ODBC in Node.js PHP: Natively Connect to JSON in PHP PowerBuilder: Connect to JSON from PowerBuilder PowerShell: Pipe JSON to CSV in PowerShell PyCharm: Using the CData ODBC Driver for JSON in PyCharm Python: Connect to JSON in Python on Linux/UNIX Ruby: Connect to JSON in Ruby RunMyProcess: Connect to JSON in RunMyProcess Servoy: Build JSON-Connected Apps in Servoy SQLAlchemy: Use SQLAlchemy ORMs to Access JSON in Python Tomcat: Configure the CData JDBC Driver for JSON in a Connection Pool in Tomcat Unqork: Create JSON-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for JSON WebLogic: Connect to JSON from a Connection Pool in WebLogic


When Only the Best JSON Drivers Will Do

See what customers have to say about our products and support.





Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Using the JSON Drivers