CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Kintone Data
Create Python applications that use pandas and Dash to build Kintone-connected web apps.
-
Automated Continuous Salesforce Pardot Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to MySQL.
-
Visualize Freshteam Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Freshteam data into TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with Sybase IQ 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 Sybase IQ data into a Java-based ORM framework, Hibernate.
-
How to integrate Metabase with ServiceNow Data
Use CData Connect AI to connect to live ServiceNow data and create an interactive dashboard in Metabase from ServiceNow data.
-
Connect to and Query Aha! Data in QlikView over ODBC
Create data visualizations with Aha! data in QlikView.
-
Manage Shippo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Shippo.
-
Integrate with live Adobe Commerce Data in Jitterbit
Use CData Connect AI to connect to and integrate live Adobe Commerce data in Jitterbit.
-
Prepare, Blend, and Analyze BigCommerce Data in Alteryx Designer (ODBC)
Build workflows to access live BigCommerce data for self-service data analytics.
-
How to Connect Flowise AI Agents to Live Impala Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Impala data without replication.
-
Query, Visualize, and Share live CouchDB Data in Redash
Use CData Connect AI to connect to live CouchDB data in Redash for querying, visualizing, and sharing.
-
Use Claude to Talk to Your GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your GitLab data for you.
-
Integrating LangGraph with IBM Informix Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on IBM Informix data within automated workflows.
-
Connect to Azure Data Catalog Data in JRuby
Create a simple JRuby app with access to live Azure Data Catalog data.
-
Query Clockify Data in ColdFusion
Write standard ColdFusion data access code to connect to Clockify data.
-
Use the CData Software JDBC Driver for Facebook in MicroStrategy Web
Connect to Facebook data in MicroStrategy Web using the CData Software JDBC Driver for Facebook.
-
Replicate Notion Data to Multiple Databases via the CData Sync CLI
Replicate Notion data to disparate databases with a single configuration.
-
Access Wave Financial Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Wave Financial data from your Oracle system.
-
Use Claude to Talk to Your Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Campaign Manager 360 data for you.
-
Automate Yelp Data Replication to Couchbase
Use CData Sync to Customize and automate Yelp data replication to Couchbase.
-
Connect to LDAP Objects in RazorSQL
Connect to LDAP from wizards and query LDAP objects from the GUI in the RazorSQL database management tool.
-
How to connect to FreshBooks Data from Spring Boot
Connect to FreshBooks in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Live ZohoInvoice Data in MicroStrategy through CData Connect AI
Create a live connection to ZohoInvoice Data in CData Connect AI and connect to your ZohoInvoice data from MicroStrategy.
-
Automate Elasticsearch Data Replication to Azure Synapse
Use CData Sync to customize and automate Elasticsearch data replication to Azure Synapse.
-
Create Data Visualizations in Cognos BI with iContact Data
Access iContact data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Migrating data from AgileCRM to Snowflake using CData SSIS Components.
Easily push AgileCRM data to Snowflake using the CData SSIS Tasks for AgileCRM and Snowflake.
-
Query Raisers Edge NXT Data as a MySQL Database in Node.js
Execute MySQL queries against Raisers Edge NXT data from Node.js.
-
Analyze Aircall Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Aircall from Power Pivot. You will use the Table Import Wizard to load Aircall data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Live Oracle HCM Cloud Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Oracle HCM Cloud data from within the IDE.
-
Use the CData Software ODBC Driver for Monday.com in SAS for Real-Time Reporting and Analytics
Connect to real-time Monday.com data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Monday.com.
-
Connect Sentry to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sentry with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Devin with Live Google Campaign Manager 360 Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Google Campaign Manager 360 data.
-
How to connect to Neo4J Data in DBVisualizer
Integrate Neo4J data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Google Sheets-Connected Applications in Appsmith
Connect to Google Sheets Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Sheets data.
-
Build MariaDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MariaDB data and build visualizations in Tableau Cloud.
-
Design BIRT Reports on Discourse Data
Provide current Discourse data to your embedded analytics.
-
Connect to Azure DevOps Data from AWS Glue
Use CData Connect AI to gain access to live Azure DevOps data from your AWS Glue jobs.
-
Build a Singer.io Tap for Teamwork With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Teamwork data using the CData Python Connector.
-
Provide OData Services of BambooHR Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for BambooHR data by developing a WCF Service Application.
-
Connect to Azure DevOps Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Azure DevOps and the Script function in FileMaker Pro to connect to Azure DevOps and work with Azure DevOps data in your FileMaker application.
-
Connect to Discord Data in Ruby
Connect to Discord data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Establish a Live Connection with SendPulse Data using Tableau Bridge
The CData ODBC Driver for SendPulse enables you to integrate live SendPulse data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Informatica Mappings From/To a JDBC Data Source for SQL Server
Create SQL Server data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
DataBind Controls to Avalara AvaTax Data in Delphi
DataBind to Avalara AvaTax data in Delphi with standard data access components and controls.
-
Connect to Salesforce CRM Analytics Data from HeidiSQL
Use CData Connect AI to connect to and query live Salesforce CRM Analytics data from HeidiSQL.
-
Integrate Live QuickBooks Online Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to QuickBooks Online data and integrate live QuickBooks Online data into apps built in Microsoft Power Apps.
-
Consume BigQuery OData Feeds in PowerBuilder
This article demonstrates how to consume BigQuery data as OData feeds from PowerBuilder using the API Server.
-
Create a Data Access Object for Tanda Data using JDBI
A brief overview of creating a SQL Object API for Tanda data in JDBI.
-
Publish Crystal Reports on Teamwork Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teamwork data.
-
How to Visualize Azure Analysis Services Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Analysis Services data in Python.
-
Manage DB2 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for DB2.
-
Connect to Google Directory Data from a Connection Pool in Jetty
The Google Directory JDBC Driver supports connection pooling: This article shows how to connect faster to Google Directory data from Web apps in Jetty.
-
Connect and Query Live Outreach.io Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Outreach.io data into Databricks and enable direct, live querying and analysis without replication.
-
Visualize Live Zoho Books Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoho Books data into custom reports in Power BI.
-
Connect to and Visualize Live Facebook Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Facebook Ads data.
-
Configure the CData JDBC Driver for Zoho Creator in a Connection Pool in Tomcat
Connect to Zoho Creator data from a connection pool in Tomcat.
-
Analyze Asana Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Asana data and visualize Asana data in SAP Analytics Cloud.
-
Model, Search, and Visualize Live Adobe Target Data in ThoughtSpot
Use CData Connect AI to connect to live Adobe Target data for modeling, searching, and visualizing.
-
Build a Singer.io Tap for Anaplan With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Anaplan data using the CData Python Connector.
-
Using the CData Software ODBC Driver for SharePoint in PyCharm
Connect to SharePoint as an ODBC data source in PyCharm using the CData Software ODBC Driver for SharePoint.
-
Integrating LangGraph with Oracle Eloqua Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Eloqua data within automated workflows.
-
Migrating data from SurveyMonkey to Databricks using CData SSIS Components.
Easily push SurveyMonkey data to Databricks using the CData SSIS Tasks for SurveyMonkey and Databricks.
-
Validate Retently Data with QuerySurge
Access and validate Retently data in QuerySurge using the CData JDBC Driver.
-
Integrating Cursor with Highrise 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.
-
Automated Continuous Templated Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Templated replication to AlloyDB.
-
Connect to Mailgun Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mailgun data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software JDBC Driver for Pipeliner CRM in MicroStrategy Web
Connect to Pipeliner CRM data in MicroStrategy Web using the CData Software JDBC Driver for Pipeliner CRM.
-
Connect to Clari Data in JRuby
Create a simple JRuby app with access to live Clari data.
-
How to create Visio diagrams from Sybase Data
Automatically update Sybase data with the changes you make to Visio master shapes.
-
Object-Relational Mapping (ORM) with ShipEngine 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 ShipEngine data into a Java-based ORM framework, Hibernate.
-
Interact with Live Mailgun Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Mailgun data.
-
Visualize Live Impala Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Impala data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple GetResponse Accounts
Replicate multiple GetResponse accounts to one or many databases.
-
Connect to eBay Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with eBay Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating Claude Code CLI with Azure Data Lake Storage 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.
-
Using the CData Software ODBC Driver for Missive in PyCharm
Connect to Missive as an ODBC data source in PyCharm using the CData Software ODBC Driver for Missive.
-
Getting Started with the CData Python Connector for HBase
Learn to install and license the CData Python Connector and configure a connection to live HBase data.
-
How to Connect to Live Microsoft OneDrive Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft OneDrive data securely in real time.
-
How to Connect to Live Klipfolio Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Klipfolio data for you.
-
How to integrate Metabase with Active Directory Data
Use CData Connect AI to connect to live Active Directory data and create an interactive dashboard in Metabase from Active Directory data.
-
Migrating data from Couchbase to Google BigQuery using CData SSIS Components.
Easily push Couchbase data to Google BigQuery using the CData SSIS Tasks for Couchbase and Google BigQuery.
-
Use the CData Software ODBC Driver for Elasticsearch in MicroStrategy Web
Connect to Elasticsearch data in MicroStrategy Web using the CData Software ODBC Driver for Elasticsearch.
-
Visualize ScrapingBee Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ScrapingBee data into TIBCO Spotfire.
-
A PostgreSQL Interface for Calendly Data using the CData ODBC Driver
Use the SQL Gateway and Calendly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Manage SQL Analysis Services Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SQL Analysis Services.
-
Integrate with Live Dynamics 365 Business Central Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 Business Central from the MuleSoft Anypoint Platform to integrate live Dynamics 365 Business Central data into custom reports and dashboards.
-
Query Databricks Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Databricks data from Node.js.
-
Stream SAP Business One Data into Apache Kafka Topics
Access and stream SAP Business One data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to load QuickBooks Time data into Elasticsearch via Logstash
Introducing a simple method to load QuickBooks Time data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous ZohoDesk Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Databricks.
-
Import Real-Time SingleStore Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SingleStore data in ColdFusion.
-
Use ChatGPT to Talk to Your Google Sheets 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 Google Sheets data for you.
-
How to Query Live Zoho Projects Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho Projects data data in natural language using Python.
-
Integrating LangChain with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on PayPal data within automated workflows.
-
Connect to Paymo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Paymo and the SQL Gateway to access Paymo data from Google Apps Script.
-
Access Demio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Demio data from HeidiSQL.
-
Connect to Real-Time Templated Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Templated data in Power Apps.
-
Connect to OneNote Data from a Connection Pool in JBoss
Integrate OneNote data into Java servlets: Use the Management Console in JBoss to install the OneNote JDBC Driver.
-
Automate CSV Data Replication to Azure Data Lake
Use CData Sync to customize and automate CSV data replication to Azure Data Lake.
-
Create Yelp-Connected Dashboards in Grafana
Connect to Yelp Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Yelp data.