CData Software - Knowledge Base
Recent Articles
-
Use Claude to Talk to Your Instagram 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 Instagram for you.
-
Build GitLab-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live GitLab.
-
Use ChatGPT to Talk to Your Oracle Service Cloud 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 Oracle Service Cloud for you.
-
How to Query Live Basecamp Data in Claude Desktop
Connect to and query live Basecamp Data in Claude Desktop using CData MCP Server.
-
Analyze Spotify Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Spotify with the CData JDBC Driver for Spotify.
-
Connect to Stripe from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Stripe, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Mistral AI Data in DBeaver
Use the CData ODBC Driver to connect to Mistral AI in DBeaver.
-
Integrate with live Oracle SCM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle SCM in Jitterbit.
-
Use Dash to Build to Web Apps on Wrike Data
Create Python applications that use pandas and Dash to build Wrike-connected web apps.
-
Automated Continuous ConvertKit Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ConvertKit replication to delimited files (CSV/TSV).
-
Connect to Reckon Accounts Hosted Data in Claris FileMaker Pro
Use the CData ODBC Driver for Reckon Accounts Hosted in FileMaker Pro to connect to Reckon Accounts Hosted and work with Reckon Accounts Hosted in your FileMaker applications.
-
How to Visualize CouchDB Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Apache CouchDB in Python.
-
Import and Visualize PabblySubscriptions Data in Power View
Create data visualizations based on PabblySubscriptions in Excel.
-
Automated Continuous Microsoft Entra ID Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Apache Kafka.
-
Query OnePageCrm Data as a MySQL Database in Node.js
Execute MySQL queries against OnePageCrm from Node.js.
-
Integrating LangChain with Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft OneDrive within automated workflows.
-
Integrate Acumatica with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Acumatica with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Acumatica ERP.
-
Integrating OpenCode Terminal with Odoo 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 OneNote from a Connection Pool in WebLogic
Use the CData JDBC Driver for OneNote to connect to Microsoft OneNote from Web applications running on WebLogic.
-
Build a Simple VCL Application for Clio Data
How to build a simple VCL Application to view Clio in RAD Studio using the CData ODBC Driver for Clio.
-
Integrating OpenCode Terminal with Sybase 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.
-
DataBind Spotify Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Spotify to a chart.
-
Replicate On-Premises Data to Microsoft Fabric with Compliance Controls using CData Sync
Learn how to selectively replicate on-premises data to Microsoft Fabric OneLake using CData Sync while maintaining compliance with HIPAA, SOX, and data sovereignty regulations
-
Use the CData SSIS Components to Insert New or Update Existing Couchbase Records from SQL Server
Easily push SQL Server data to Couchbase using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Couchbase or update existing records with data from a SQL Server database.
-
Integrating OpenCode Terminal with Shopify 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 XML Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume XML entities in PHP by modeling them as objects.
-
Visualize SQL Server Data in TIBCO Spotfire through OData
Integrate Microsoft SQL Server into dashboards in TIBCO Spotfire.
-
How to update Twilio from Excel
This article explains how to transfer data from Excel to Twilio using the Excel Add-In for Twilio.
-
Build Semantic Layer Views for Guru Data in APOS Live Data Gateway
Use the CData Connector for Guru in APOS Live Data Gateway to build Semantic Layer Views for Guru.
-
Build Dashboards with Adobe Analytics Data in Dundas BI
Create dynamic dashboards and perform analytics based on Adobe Analytics in Dundas BI.
-
Building Dynamic Web Pages with Phoenix Data Using AngularJS
Create single-page applications with live connectivity to Phoenix using the CData API Server.
-
Automate Monday.com Data Replication to SAP HANA
Use CData Sync to customize and automate Monday.com replication to SAP HANA.
-
Using the CData Software ODBC Driver for ConvertAPI in PyCharm
Connect to ConvertAPI as an ODBC data source in PyCharm using the CData Software ODBC Driver for ConvertAPI.
-
Integrating LangGraph with SAS Data Sets Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAS Data Sets within automated workflows.
-
Publish Lakebase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Lakebase.
-
Query Sage Intacct Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sage Intacct from Node.js.
-
Query CircleCI Data in DataGrip
Create a Data Source for CircleCI in DataGrip and use SQL to query live CircleCI.
-
Integrating OpenCode Terminal with Datadog 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 ChargeOver Replication to MySQL
Use CData Sync for automated, continuous, customizable ChargeOver replication to MySQL.
-
How to Connect Google Ad Manager Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Ad Manager data in real time using natural language.
-
Automated Continuous Salesforce Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesforce replication to SingleStore.
-
Trigger Spark IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Spark with standard wizards in Logic Apps.
-
Visualize Live Epicor Kinetic Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Epicor Kinetic into custom reports in Power BI.
-
Automated Continuous QuickBooks Replication to SQLite
Use CData Sync for automated, continuous, customizable QuickBooks replication to SQLite.
-
Object-Relational Mapping (ORM) with MarkLogic 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 MarkLogic into a Java-based ORM framework, Hibernate.
-
Use JayDeBeApi to access Bitbucket Data in Python
Use standard Python scripting and the development environment of your choice to access live Bitbucket.
-
Analyze NetSuite Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for NetSuite from Power Pivot. You will use the Table Import Wizard to load NetSuite CRM & ERP. You can visually build the import query or use any SQL supported by the driver.
-
Create Reports with Act CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act CRM.
-
Stream QuickBooks Data into Apache Kafka Topics
Access and stream QuickBooks Desktop in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Theia IDE with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Connect to Live Zoom Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Zoom for you.
-
Integrating Claude Code with Salesforce Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Salesforce & Force.com within assisted coding and automated development workflows.
-
Build Charts with SAP Fieldglass Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Fieldglass in Clear Analytics.
-
Integrating Codex CLI with Reply.io 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.
-
Automate CouchDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache CouchDB from PowerShell? This article demonstrates how to utilize the CouchDB Cmdlets for tasks like connecting to Apache CouchDB, automating operations, downloading data, and more.
-
Build SFTP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SFTP.
-
Replicate ZohoExpense Data from PowerShell
Write a quick PowerShell script to query ZohoExpense. Use connectivity to the live data to replicate ZohoExpense to SQL Server.
-
How to connect to Procore Data with Squirrel SQL client
Connect to Procore and execute queries in the Squirrel SQL Client.
-
Connect to Aha! Data from PowerBuilder via JDBC
This article demonstrates how to access Aha! from PowerBuilder using the Aha! JDBC Driver.
-
Build ZohoSubscriptions-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoSubscriptions.
-
Build Spark Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Apache Spark SQL and build visualizations in Tableau.
-
Integrating Cursor CLI with Wrike 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.
-
Connecting Moonlit Workflow with Amazon Athena Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Amazon Athena in real time.
-
Automated Continuous YouTube Analytics Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to delimited files (CSV/TSV).
-
How to Build an ETL App for ADP Data in Python with CData Connect AI
Build ETL pipelines that read and write live ADP in Python with petl and the CData Connect AI Python SDK.
-
Integrating Dataiku with Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Lakebase.
-
How to Connect to Live Oracle Eloqua 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 Oracle Eloqua without replication.
-
Design BIRT Reports on ZohoInvoice Data
Provide current ZohoInvoice to your embedded analytics.
-
Connect to Facebook Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Facebook Ads in Airbyte.
-
Build Semantic Layer Views for Campaigner Data in APOS Live Data Gateway
Use the CData Connector for Campaigner in APOS Live Data Gateway to build Semantic Layer Views for Campaigner.
-
Create SSAS Tabular Models from GraphQL Data
How to build a SQL Server Analysis Service Tabular Model from GraphQL using CData drivers.
-
How to Access Live iContact Data in Power Automate Desktop via ODBC
The CData ODBC Driver for iContact enables you to integrate iContact into workflows built using Microsoft Power Automate Desktop.
-
Configure the CData JDBC Driver for Redis in a Connection Pool in Tomcat
Connect to Redis from a connection pool in Tomcat.
-
Getting Started with the CData JDBC Driver for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Hybris C4C.
-
Migrating data from Sybase to Snowflake using CData SSIS Components.
Easily push Sybase to Snowflake using the CData SSIS Tasks for Sybase and Snowflake.
-
DataBind Oracle Sales Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle Sales with the DevExpress Windows Forms and Web controls to provide Oracle Sales to a chart.
-
Automated Continuous Azure Synapse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Synapse replication to OneLake in Microsoft Fabric.
-
Migrating data from Spark to Databricks using CData SSIS Components.
Easily push Apache Spark SQL to Databricks using the CData SSIS Tasks for Spark and Databricks.
-
Publish Reports with Google Ad Manager Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ad Manager.
-
Establish a Live Connection with Everhour Data using Tableau Bridge
The CData ODBC Driver for Everhour enables you to integrate live Everhour into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Query Live Stripe Data in Perplexity MacOS Desktop
Connect to and query live Stripe Data in Perplexity Desktop using CData MCP Server.
-
Connect to Suadeo Data in RazorSQL
Connect to Suadeo from wizards and query Suadeo from the GUI in the RazorSQL database management tool.
-
Prepare, Blend, and Analyze Flowlu Data in Alteryx Designer (ODBC)
Build workflows to access live Flowlu for self-service data analytics.
-
Connect to Oracle Service Cloud Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Service Cloud in DBeaver.
-
Build a Simple VCL Application for PabblySubscriptions Data
How to build a simple VCL Application to view PabblySubscriptions in RAD Studio using the CData ODBC Driver for PabblySubscriptions.
-
Connect to and Visualize Live WooCommerce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live WooCommerce.
-
Access Live Oracle Service Cloud Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Oracle Service Cloud through MCP integration.
-
Connect to EnterpriseDB Data in HULFT Integrate
Connect to EnterpriseDB as a JDBC data source in HULFT Integrate
-
Connect to Tanda Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Tanda in the Denodo Virtual DataPort Administrator.
-
Integrating Kiro CLI with Acumatica 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.
-
Migrating data from Ontraport to Snowflake using CData SSIS Components.
Easily push Ontraport to Snowflake using the CData SSIS Tasks for Ontraport and Snowflake.
-
Explore Geographical Relationships in Toggl Data with Power Map
Create data visualizations with Toggl in Power Map.
-
Connect to Apollo Data from HeidiSQL
Use CData Connect AI to connect to and query live Apollo from HeidiSQL.
-
Integrating GitHub Copilot CLI with Avaza 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.
-
Manage Superchat Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Superchat.
-
Automated Continuous SharePoint Excel Services Replication to Vertica
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Vertica.
-
Connect to Real-Time Acumatica Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Acumatica and Dataflow to import and use Acumatica ERP in Power Apps.
-
How to Use a Microsoft Access Database to Update Quickbase Data in Real Time
Update Quickbase data by creating a linked table in Microsoft Access with the CData Quickbase ODBC Driver.
-
Integrating Codex CLI with PingOne 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 FreeAgent Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your FreeAgent using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.