CData Software - Knowledge Base
Recent Articles
-
Access Live Aweber Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Aweber data into the statistical analysis tools available in SAS JMP. This article shows how to use Aweber data in the Graph Builder and Query Builder.
-
DataBind Xero Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Xero with the DevExpress Windows Forms and Web controls to provide Xero data to a chart.
-
Integrating Codex with Oracle Eloqua 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.
-
How to Visualize Aweber Data in Python with pandas
Use pandas and other modules to analyze and visualize live Aweber data in Python.
-
Integrate with GitHub Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy GitHub data to a JSON file on disk.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Ariba Source
Provide connectivity to SAP Ariba Source data through an SAP BusinessObjects universe.
-
DataBind Charts to Amazon S3 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon S3 data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate Devin with Live Azure DevOps 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 Azure DevOps data.
-
Create Salesloft-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesloft Data from Klipfolio and build custom visualizations using live Salesloft data.
-
Query Google Directory Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Directory data from Node.js.
-
Enable the Google Campaign Manager 360 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Campaign Manager 360 data.
-
Automated Continuous Jodoo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Jodoo replication to Google Cloud SQL.
-
Build Data Flows from Bullhorn CRM to SQL Server using SSIS
Easily back up Bullhorn CRM data to SQL Server using the SSIS components for Bullhorn CRM.
-
Connect to Adobe Target Data from HeidiSQL
Use CData Connect AI to connect to and query live Adobe Target data from HeidiSQL.
-
Connect to Box Data in Aqua Data Studio
Access Box data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize Amazon DynamoDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon DynamoDB data in Python.
-
Use the CData Software ODBC Driver for Coda in MicroStrategy Desktop
Connect to Coda data in MicroStrategy Desktop using the CData Software ODBC Driver for Coda.
-
Integrate Trae with Live HubDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live HubDB data from within the AI-powered IDE.
-
Analyze SendGrid Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SendGrid data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Work with Live Freshdesk Data in Power Query
Use CData Connect AI to connect to Freshdesk data and work with live Freshdesk data in Microsoft Power Query.
-
Integrate Trae with Live Pinterest Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Pinterest data from within the AI-powered IDE.
-
Use the CData SSIS Components to Insert New or Update Existing Cloudant Records from SQL Server
Easily push SQL Server data to Cloudant using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cloudant or update existing records with data from a SQL Server database.
-
Work with Live Moosend Data in Power Query
Use CData Connect AI to connect to Moosend data and work with live Moosend data in Microsoft Power Query.
-
Automated Continuous ZohoSubscriptions Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Google BigQuery.
-
How to integrate Notion with Apache Airflow
Access and process Notion data in Apache Airflow using the CData JDBC Driver.
-
FAQ: Licensing and Deploying Builds of Finished Applications
Follow these instructions to test, build, and distribute apps using the CData single developer, royalty-free license.
-
Connecting Agentforce with Zendesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Zendesk data for you.
-
Analyze LinkedIn Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LinkedIn Ads data and visualize live LinkedIn Ads data in Infragistics Reveal.
-
Create Data Visualizations in Cognos BI with LeadDesk Data
Access LeadDesk data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Recurly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Recurly replication to Google BigQuery.
-
How to connect to Paylocity Data in DBVisualizer
Integrate Paylocity data with visual data analysis tools and data connection wizards in DBVisualizer
-
Feed OnePageCrm Data into FineReport
How to set OnePageCrm data as a JDBC data source in FineReport.
-
Access Live Reckon Accounts Hosted Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Reckon Accounts Hosted data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
DataBind Controls to LaunchDarkly Data in C++Builder
DataBind to LaunchDarkly data in C++Builder with standard components and controls.
-
Visualize Foursquare Data in Sisense
Create an ElastiCube in Sisense app with access to Foursquare data.
-
Automated Continuous Keap Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Keap replication to delimited files (CSV/TSV).
-
Create Typeform-Connected Business Apps in AppSheet
Connect to Typeform Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Typeform data.
-
A PostgreSQL Interface for Tavily Data (MySQL Remoting via JDBC)
Use the Remoting features of the Tavily JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Devin with Live WordPress 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 WordPress data.
-
Connect ZohoDesk to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoDesk with IBM WebSphere for seamless data integration and connectivity.
-
Analyze SAS xpt Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAS xpt data and visualize live SAS xpt data in Infragistics Reveal.
-
Build Automated Workflows with Live Azure DevOps Data in Workato
Use CData Connect AI to connect to live Azure DevOps data and build automated workflows in Workato.
-
Integrate with Avro Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Avro data to a JSON file on disk.
-
Integrate with Dropbox Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Dropbox data in SnapLogic.
-
Connect to Strava Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Strava data.
-
Integrate LibreChat with Live MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MySQL data from within the chat interface.
-
Access Pipeliner CRM Data from MySQL in PHP
Connect to Pipeliner CRM through the standard MySQL libraries in PHP.
-
Automated Continuous Phoenix Replication to Databricks
Use CData Sync for automated, continuous, customizable Phoenix replication to Databricks.
-
Integrating LlamaIndex with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle SCM data in real time.
-
How to connect to Bright Data Data from IntelliJ
Integrate connectivity to Bright Data data with wizards in IntelliJ.
-
Automated Continuous Greenplum Replication to Oracle
Use CData Sync for automated, continuous, customizable Greenplum replication to Oracle.
-
How to Connect to Live Asana Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Asana data for you.
-
Connect to Adobe Target Data in RazorSQL
Connect to Adobe Target from wizards and query Adobe Target data from the GUI in the RazorSQL database management tool.
-
Visualize Live Certinia Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Certinia data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Claude Code CLI with IBM Cloud Object 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.
-
Object-Relational Mapping (ORM) with DocuSign 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 DocuSign data into a Java-based ORM framework, Hibernate.
-
Moving Data from Salesforce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create MariaDB-Connected Dashboards in Grafana
Connect to MariaDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MariaDB data.
-
Replicate EnterpriseDB Data to Multiple Databases via the CData Sync CLI
Replicate EnterpriseDB data to disparate databases with a single configuration.
-
Create FreshBooks-Connected Nintex Workflows
Use CData Connect AI to connect to FreshBooks Data from Nintex Workflow Cloud and build custom workflows using live FreshBooks data.
-
Create Power BI Reports on Real-Time Odoo Data
Use the CData ODBC Driver for Odoo to visualize Odoo data in Power BI Desktop.
-
Load Azure Data Catalog Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Data Catalog data to a database.
-
Use the CData Software ODBC Driver for ConvertAPI in MicroStrategy Desktop
Connect to ConvertAPI data in MicroStrategy Desktop using the CData Software ODBC Driver for ConvertAPI.
-
Build MariaDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MariaDB data and build visualizations in Tableau.
-
Integrating Cursor with JotForm 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.
-
Prepare, Blend, and Analyze Templated Data in Alteryx Designer (ODBC)
Build workflows to access live Templated data for self-service data analytics.
-
How to Query LightSpeedRetail Data in MySQL Workbench
Execute MySQL queries against live LightSpeedRetail data from MySQL Workbench.
-
Access Live Adobe Commerce Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Adobe Commerce data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Access Live Front Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Front enables you to integrate Front data into workflows built using Microsoft Power Automate Desktop.
-
Create Data Visualizations Based On SQL Analysis Services Data in Mode
Use CData Connect AI to connect to SQL Analysis Services Data from Mode and build visualizations using live SQL Analysis Services data.
-
Automated Continuous Aweber Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Aweber replication to IBM DB2.
-
How to Work with SageHR Data in AWS Glue Jobs Using JDBC
Connect to SageHR from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Natively Connect to Dynamics NAV Data in PHP
The CData ODBC driver for Dynamics NAV enables you to create PHP applications with connectivity to Dynamics NAV data. Leverage the native support for ODBC in PHP.
-
Connect to Bright Data Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Bright Data data in Airbyte.
-
How to Connect to Live Gmail Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Gmail data for you.
-
DataBind Charts to Webflow Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Webflow data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build Redshift-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Redshift data.
-
Automated Continuous ZohoMarketingHub Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Databricks.
-
Build a Singer.io Tap for Reckon With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Reckon data using the CData Python Connector.
-
How to Connect Flowise AI Agents to Live Zoho Creator 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 Zoho Creator data without replication.
-
Build Power BI XMLA-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Power BI XMLA data.
-
Visualize Exa Data in TIBCO Spotfire through ADO.NET
Integrate Exa data into dashboards in TIBCO Spotfire.
-
Import and Visualize Highrise Data in Power View
Create data visualizations based on Highrise data in Excel.
-
How to Query Live Moosend Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Moosend data data in natural language using Python.
-
How to Connect to Live Dynamics NAV 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 Dynamics NAV data for you.
-
Analyze Clari Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Clari data in Microsoft R Open.
-
Query NetSuite Data through ODBC in Node.js
Use node-odbc to execute SQL queries against NetSuite data from Node.js.
-
Connect to Jumpseller Data in Ruby
Connect to Jumpseller data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Suadeo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Suadeo data from Appeon PowerBuilder using the CData ADO.NET Provider for Suadeo.
-
Visualize Live Adobe Analytics Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Analytics data.
-
Automate Email Data Replication to Azure Data Lake
Use CData Sync to customize and automate Email data replication to Azure Data Lake.
-
Stream Active Directory Data into Apache Kafka Topics
Access and stream Active Directory data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Codat Data in DBVisualizer
Integrate Codat data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Procore Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Procore Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Create Power BI Visual Reports with Real-Time MailerLite Data
Use CData Power BI Connectors to visualize MailerLite data in Power BI.
-
Build an OLAP Cube in SSAS from SAP ByDesign Data
Establish a connection to SAP ByDesign data data from SQL Server Analysis Services, and use the SAP ByDesign Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Dynamics 365 Business Central Data in DBArtisan
Use wizards in DBArtisan to configure Dynamics 365 Business Central data as a data source.
-
How to Connect the Power BI Service to Email: Complete Guide
Connect to the CData Software Power BI Connector for Email from PowerBI.com to provide real-time Email data across the organization.
-
Integrate Goose with Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live PayPal data from within the local AI agent.
-
How to use SQLAlchemy ORM to access Yelp Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Yelp data.