CData Software - Knowledge Base
Recent Articles
-
Analyze Workday Data in Cognos Analytics
Use CData Connect AI to connect to Workday Data from Cognos Analytics and analyze live Workday.
-
How to Work with Blackbaud FE NXT Data in AWS Glue Jobs Using JDBC
Connect to Blackbaud FE NXT from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Feed Insightly Data into FineReport
How to set Insightly as a JDBC data source in FineReport.
-
Integrate Outreach.io Data in Pentaho Data Integration
Build ETL pipelines based on Outreach.io in the Pentaho Data Integration tool.
-
Connect to Ontraport Data in NetBeans
Connect to Ontraport in NetBeans with the data source configuration wizard.
-
Access Quaderno Data from MySQL in Amazon QuickSight
Connect to Quaderno and build visualizations of Quaderno using a MySQL Connection in Amazon QuickSight.
-
How to Connect to Live CockroachDB Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live CockroachDB without replication.
-
Build a Singer.io Tap for Jira Assets With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Jira Assets data using
-
Connect Instagram to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Instagram using the CData Python MCP Server.
-
Import MarkLogic Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MarkLogic Data and provide access to live MarkLogic for custom reports in the Power BI Service.
-
Automate Humanity Data Replication to Azure Synapse
Use CData Sync to customize and automate Humanity replication to Azure Synapse.
-
Object-Relational Mapping (ORM) with Neo4J Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Neo4J into a Java-based ORM framework, Hibernate.
-
Load Facebook Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Facebook Ads to a database.
-
Connect to and Visualize Live FreeAgent Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live FreeAgent.
-
Using the CData Software ODBC Driver for WooCommerce in PyCharm
Connect to WooCommerce as an ODBC data source in PyCharm using the CData Software ODBC Driver for WooCommerce.
-
Getting Started with the CData Python Connector for Zendesk
Learn to install and license the CData Python Connector
-
Seamlessly Bring Azure DevOps Data into Retool Using CData Connect AI
Integrate Azure DevOps data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build a PostgreSQL Interface for Confluence Data using the CData JDBC Driver
Use the Remoting features of the Confluence JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live SQL Analysis Services Data in the Power BI Service
Use CData Connect AI to connect to live SQL Analysis Services and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Everhour Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Everhour using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Dynamic Bright Data Grids Using the Infragistics XamDataGrid
Learn how you can connect Bright Data to Infragistics XamDataGrid to build dynamic grids.
-
How to connect Amazon QuickSight to Cassandra Data
Create a connection to Apache Cassandra in CData Connect AI and insert Apache Cassandra into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate ZohoDesk Data in Pentaho Data Integration
Build ETL pipelines based on ZohoDesk in the Pentaho Data Integration tool.
-
Connect to Intercom Data in RapidMiner
Integrate Intercom with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Kiro CLI with Email Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to JSON Services in DBeaver
Use the CData ODBC Driver to connect to JSON in DBeaver.
-
Connect to and Visualize Live TigerGraph Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live TigerGraph.
-
Provide OData Services of Pingdom Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Pingdom by developing a WCF Service Application.
-
Using the CData Software ODBC Driver for SendGrid in PyCharm
Connect to SendGrid as an ODBC data source in PyCharm using the CData Software ODBC Driver for SendGrid.
-
Create Dynamic OnePageCrm Grids Using the Infragistics XamDataGrid
Learn how you can connect OnePageCrm to Infragistics XamDataGrid to build dynamic grids.
-
How to Query Live SAP Concur Data in Claude Desktop
Connect to and query live SAP Concur Data in Claude Desktop using CData MCP Server.
-
Migrating data from Amazon Marketplace to Snowflake using CData SSIS Components.
Easily push Amazon Marketplace to Snowflake using the CData SSIS Tasks for Amazon Marketplace and Snowflake.
-
DataBind Controls to Close Data in Delphi
DataBind to Close in Delphi with standard data access components and controls.
-
Integrate Theia IDE with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData Software JDBC Driver for BigQuery in MicroStrategy
Connect to Google BigQuery in MicroStrategy Developer using the CData Software JDBC Driver for BigQuery.
-
Integrate with MariaDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MariaDB to a JSON file on disk.
-
Access Live Pipedrive Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pipedrive into the statistical analysis tools available in SAS JMP. This article shows how to use Pipedrive in the Graph Builder and Query Builder.
-
How to Query Live SAP Business One Data in Perplexity MacOS Desktop
Connect to and query live SAP Business One Data in Perplexity Desktop using CData MCP Server.
-
SQL Access to Redis Data
An article highlighting the available features and functionality of CData Software Drivers for Redis.
-
Integrate Open WebUI with Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live NetSuite SuiteAnalytics from within the chat interface.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon Redshift using the Model Context Protocol.
-
Use the CData Software JDBC Driver for ConvertKit in MicroStrategy Web
Connect to ConvertKit in MicroStrategy Web using the CData Software JDBC Driver for ConvertKit.
-
Access Calendly Data from MySQL in Amazon QuickSight
Connect to Calendly and build visualizations of Calendly using a MySQL Connection in Amazon QuickSight.
-
Connect to Jodoo Data in NetBeans
Connect to Jodoo in NetBeans with the data source configuration wizard.
-
Connect to MYOB AccountRight Data in Ruby
Connect to MYOB AccountRight in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Dynamic Cloudant Grids Using the Infragistics XamDataGrid
Learn how you can connect Cloudant to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData ADO.NET Provider for Attio
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live Pinterest Data in TIBCO Data Virtualization
Use the Pinterest Tibco DV Adapter to create a Pinterest data source in TIBCO Data Virtualization Studio and gain access to live Pinterest from your TDV Server.
-
Connect to Reckon Data from PowerBuilder via ADO.NET
This article demonstrates how to access Reckon from Appeon PowerBuilder using the CData ADO.NET Provider for Reckon.
-
Automate Azure Synapse Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure Synapse and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Apps with Live Avro Data Using the Low-Code Development Platform of Mendix
Connect Apache Avro with Mendix to build apps using the CData JDBC Driver for Avro.
-
Build Parquet-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Parquet to explore live Parquet Data in Claude Code to assist with building Parquet-powered applications.
-
How to Create Power BI Visual Reports with Real-Time ElevenLabs Data
Use CData Power BI Connectors to visualize ElevenLabs in Power BI.
-
Use ChatGPT to Talk to Your Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Apache Impala for you.
-
View Reports on Real-Time Gumroad Data in Power BI Report Server
Use the CData ODBC Driver for Gumroad to visualize Gumroad in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous LinkedIn Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to SingleStore.
-
Using the CData Software ODBC Driver for Instantly in PyCharm
Connect to Instantly as an ODBC data source in PyCharm using the CData Software ODBC Driver for Instantly.
-
Integrate with Access Data in JReport Designer
Create charts and reports based on Microsoft Access in JReport Designer.
-
Create Redshift-Connected Business Apps in AppSheet
Connect to Redshift Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon Redshift.
-
Integrating Kiro CLI with Google Search Results via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Use the CData Software ODBC Driver for Splunk in SAS for Real-Time Reporting and Analytics
Connect to real-time Splunk in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Splunk.
-
Visualize Aircall Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Aircall.
-
Creating Sybase IQ-Connected Applications in Unqork
You can use CData Connect AI to feed Sybase IQ to Unqork and build custom business apps.
-
Configure the CData JDBC Driver for Nuclia in a Connection Pool in Tomcat
Connect to Nuclia from a connection pool in Tomcat.
-
Integrating Claude Code CLI with Printful Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata - all without leaving the terminal.
-
Query CockroachDB Data in ColdFusion
Write standard ColdFusion data access code to connect to CockroachDB.
-
Access Cloudflare Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Cloudflare from HeidiSQL.
-
Work with Sybase Data in FoxPro
Load Sybase into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Google Directory Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Directory replication to Oracle.
-
Natively Connect to Dynamics 365 Business Central Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dynamics 365 Business Central. Leverage the native support for ODBC in PHP.
-
How to connect and process Superchat from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Superchat.
-
Analyze Jumpseller Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Jumpseller from Power Pivot. You will use the Table Import Wizard to load Jumpseller. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP SuccessFactors to Power BI dashboards. Simply drag and drop SAP SuccessFactors into data visuals on the Power BI canvas.
-
Analyze CouchDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache CouchDB in Microsoft R Open.
-
Access Amplitude Data from MySQL in PHP
Connect to Amplitude through the standard MySQL libraries in PHP.
-
Connect to and Query Sage Intacct Data in QlikView over ODBC
Create data visualizations with Sage Intacct in QlikView.
-
Access Live Zoho Books Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho Books from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Real-Time Reply.io Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Reply.io in Power Apps.
-
How to Connect to Deel Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Deel. Leverage the pyodbc module for ODBC in Python.
-
Build Postmark-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Postmark.
-
Connect to Sage Cloud Accounting Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sage Business Cloud Accounting from Crystal Reports.
-
How to Query Live ADP Data in Claude Desktop
Connect to and query live ADP Data in Claude Desktop using CData MCP Server.
-
How to use SQLAlchemy ORM to access HubSpot Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HubSpot.
-
Access Live Hugging Face Data in AWS Lambda
Connect to live Hugging Face in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sage Cloud Accounting.
-
How to Access Live SAP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP enables you to integrate SAP ERP/NetWeaver into workflows built using Microsoft Power Automate Desktop.
-
How to update QuickBooks from Excel
This article explains how to transfer data from Excel to QuickBooks using the Excel Add-In for QuickBooks.
-
DataBind Controls to SAP Fieldglass Data in C++Builder
DataBind to SAP Fieldglass in C++Builder with standard components and controls.
-
Use the CData ODBC Driver for RSS from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for RSS to connect to RSS Feeds from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring RSS Feeds in Excel.
-
Object-Relational Mapping (ORM) with Chargebee Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Chargebee into a Java-based ORM framework, Hibernate.
-
Import and Visualize Amazon S3 Data in Power View
Create data visualizations based on Amazon S3 in Excel.
-
Visualize Everhour Data in Tableau
The CData ODBC driver for Everhour enables you integrate Everhour into Tableau dashboards.
-
Build a PostgreSQL Interface for BambooHR Data using the CData JDBC Driver
Use the Remoting features of the BambooHR JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bind Live Cassandra Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Cassandra data
-
View Reports on Real-Time Testmonitor Data in Power BI Report Server
Use the CData ODBC Driver for Testmonitor to visualize Testmonitor in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for SurveyMonkey in SAS for Real-Time Reporting and Analytics
Connect to real-time SurveyMonkey in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SurveyMonkey.
-
Configure the CData JDBC Driver for SageHR in a Connection Pool in Tomcat
Connect to SageHR from a connection pool in Tomcat.
-
Getting Started with the CData SSIS Components for Act-On
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Act-On.
-
ETL Google Search in Oracle Data Integrator
This article shows how to transfer Google Search into a data warehouse using Oracle Data Integrator.
-
Stream Stack Exchange Data into Apache Kafka Topics
Access and stream Stack Exchange in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.