CData Software - Knowledge Base
Recent Articles
-
Connect to CampaignMonitor Data from a Connection Pool in Jetty
The CampaignMonitor JDBC Driver supports connection pooling: This article shows how to connect faster to CampaignMonitor data from Web apps in Jetty.
-
How to Build an ETL App for Hive Data in Python with CData
Create ETL applications and real-time data pipelines for Hive data in Python with petl.
-
How to Build an ETL App for Clio Data in Python with CData
Create ETL applications and real-time data pipelines for Clio data in Python with petl.
-
How to Connect the Power BI Service to Nuclia: Complete Guide
Connect to the CData Software Power BI Connector for Nuclia from PowerBI.com to provide real-time Nuclia data across the organization.
-
Build AI/ML Models with Live ZohoPeople Data using Dataiku
Connect ZohoPeople Data with Dataiku using the CData API Driver for JDBC.
-
Connect to PhantomBuster Data in DBArtisan
Use wizards in DBArtisan to configure PhantomBuster data as a data source.
-
Integrating Dataiku with SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP SuccessFactors LMS data.
-
Stream Greenhouse Data into Apache Kafka Topics
Access and stream Greenhouse data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Contentful Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Contentful and work with Contentful data in your FileMaker applications.
-
Connect to Adobe Analytics Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Analytics to connect to Adobe Analytics data and execute queries in PowerBuilder.
-
Integrate SuiteCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SuiteCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SuiteCRM data.
-
Integrating LangGraph with Avalara AvaTax Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Avalara AvaTax data within automated workflows.
-
Operational Reporting on JotForm Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote JotForm data.
-
How to Connect Flowise AI Agents to Live PolarTeamPro 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 PolarTeamPro data without replication.
-
Integrate Cline with Live Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Airtable data from within your IDE.
-
Connect to Workday from Asprova with CData Software ODBC Driver for Workday
This article shows how to connect faster to Workday data from Asprova.
-
Access Bannerbear Data from MySQL in Amazon QuickSight
Connect to Bannerbear and build visualizations of Bannerbear data using a MySQL Connection in Amazon QuickSight.
-
Connect to and Query MailChimp Data in QlikView over ODBC
Create data visualizations with MailChimp data in QlikView.
-
Visualize Wrike Data in Sisense
Create an ElastiCube in Sisense app with access to Wrike data.
-
Build Agents in Relevance AI with Access to Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on CouchDB data within intelligent agent workflows.
-
Connect to Oracle Sales Data in CloverDX (formerly CloverETL)
Transfer Oracle Sales data using the visual workflow in the CloverDX data integration tool.
-
Build AI Agents with Exa Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Exa data through CData Connect AI.
-
Natively Connect to Samanage Data in PHP
The CData ODBC driver for Samanage enables you to create PHP applications with connectivity to Samanage data. Leverage the native support for ODBC in PHP.
-
Create Freshdesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Freshdesk data access from reports, embedded analytics, and more.
-
Automated Continuous Wrike Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Wrike replication to AlloyDB.
-
Integrating Gong Data in Talend Cloud Data Management Platform
Connect Gong Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to EnterpriseDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access EnterpriseDB data from Appeon PowerBuilder using the CData ADO.NET Provider for EnterpriseDB.
-
Use the CData Software JDBC Driver for Factorial in MicroStrategy Desktop
Connect to Factorial data in MicroStrategy Desktop using the CData Software JDBC Driver for Factorial.
-
How to connect PolyBase to Humanity
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Humanity data.
-
How to Query Clari Data in MySQL Workbench
Execute MySQL queries against live Clari data from MySQL Workbench.
-
Connect to ZohoDesk Data in JRuby
Create a simple JRuby app with access to live ZohoDesk data.
-
Connect to Active Directory Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Active Directory data.
-
How to Query Live Jumpseller Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Jumpseller data data in natural language using Python.
-
Integrate Trae with Live Excel Online Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Excel Online data from within the AI-powered IDE.
-
Working with Front Data in LINQPad
Execute LINQ queries to Front data in LINQPad.
-
Create Data Visualizations in Cognos BI with Gong Data
Access Gong data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Cursor with Paylocity 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.
-
Access Live SAP Business Warehouse Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Business Warehouse data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to create Accelo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Accelo data in MySQL .
-
Analyze Telegram Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Telegram from Power Pivot. You will use the Table Import Wizard to load Telegram data. You can visually build the import query or use any SQL supported by the driver.
-
How to work with SAP HANA Data in Apache Spark using SQL
Access and process SAP HANA Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Azure Data Catalog Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Azure SQL Database.
-
Connect to Shopify Data in Aqua Data Studio
Access Shopify data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Claude Code with Google Sheets Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Sheets data within assisted coding and automated development workflows.
-
Connect to Printful Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Printful and work with Printful data in your FileMaker applications.
-
Replicate BambooHR Data to Multiple Databases
Replicate BambooHR data to disparate databases with a point-and-click configuration.
-
Use Microsoft Copilot Studio to talk to your Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Vertica data for you.
-
Import Real-Time Salesforce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce data in ColdFusion.
-
Configure the CData JDBC Driver for JSON in a Connection Pool in Tomcat
Connect to JSON services from a connection pool in Tomcat.
-
Automate Authorize.Net Data Replication to Azure Synapse
Use CData Sync to customize and automate Authorize.Net data replication to Azure Synapse.
-
Build Salesforce Pardot Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce Pardot data and build visualizations in Tableau Cloud.
-
Import Salesforce Data into Google Spreadsheets
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to get data from Salesforce (plus 80+ other sources). These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into a Google Spreadsheet.
-
How to Access GraphQL Data Using Entity Framework
This article shows how to access GraphQL data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Live Trello Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Trello from the MuleSoft Anypoint Platform to integrate live Trello data into custom reports and dashboards.
-
Analyze ConvertKit Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ConvertKit from Power Pivot. You will use the Table Import Wizard to load ConvertKit data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Google Cloud Storage Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Cloud Storage data.
-
Automated Continuous Float Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Float replication to Amazon S3.
-
Connect to SAP Business One Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Business One data from Crystal Reports.
-
Connect to Active Directory Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Active Directory data in the Denodo Virtual DataPort Administrator.
-
Access Live Sendwithus Data in Excel 365 Online (Excel for the web)
Connect to Sendwithus data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Attio Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Attio data.
-
Build a Simple VCL Application for Mocean Data
How to build a simple VCL Application to view Mocean data in RAD Studio using the CData ODBC Driver for Mocean.
-
Automated Continuous Landbot Replication to Vertica
Use CData Sync for automated, continuous, customizable Landbot replication to Vertica.
-
Access Snowflake Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Snowflake data from HeidiSQL.
-
Create Reports with GitHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitHub data.
-
Automated Continuous eBay Replication to SQL Server
Use CData Sync for automated, continuous, customizable eBay replication to SQL Server.
-
Getting Started with the CData ODBC Driver for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Authorize.Net.
-
Query ActiveCampaign Data in DataGrip
Create a Data Source for ActiveCampaign in DataGrip and use SQL to query live ActiveCampaign data.
-
Use the CData Software JDBC Driver for AdRoll in MicroStrategy
Connect to AdRoll data in MicroStrategy Developer using the CData Software JDBC Driver for AdRoll.
-
Automated Continuous BenchmarkEmail Replication to SQLite
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to SQLite.
-
Integrating Cursor with Google Tasks 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.
-
Publish Microsoft Teams-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Teams data.
-
Create Power BI Reports on Real-Time Jira Data
Use the CData ODBC Driver for Jira to visualize Jira data in Power BI Desktop.
-
Build Dashboards with SuiteCRM Data in DBxtra
Create dynamic dashboards and perform analytics based on SuiteCRM data in DBxtra.
-
Integrating Boomi Agentstudio with Microsoft Dataverse Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Dataverse data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze ZohoMarketingHub Data in Cognos Analytics
Use CData Connect AI to connect to ZohoMarketingHub Data from Cognos Analytics and analyze live ZohoMarketingHub data.
-
Operational Reporting on Missive Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Missive data.
-
How to create Aweber federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aweber data in MySQL .
-
How to work with Oracle Data in Apache Spark using SQL
Access and process Oracle Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Anaplan in MicroStrategy Web
Connect to Anaplan data in MicroStrategy Web using the CData Software ODBC Driver for Anaplan.
-
Access Live Suadeo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Suadeo data into the statistical analysis tools available in SAS JMP. This article shows how to use Suadeo data in the Graph Builder and Query Builder.
-
Create a Data Access Object for Jira Data using JDBI
A brief overview of creating a SQL Object API for Jira data in JDBI.
-
Integrate with Dynamics CRM Data in JReport Designer
Create charts and reports based on Dynamics CRM data in JReport Designer.
-
Integrating Codex with Access 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.
-
Editing API Driver API Profiles
Edit existing API Profiles to enable more SQL access to APIs.
-
Connect to Workday Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Workday data.
-
Access GitHub Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for GitHub data.
-
How to Query Exact Online Data in MySQL Workbench
Execute MySQL queries against live Exact Online data from MySQL Workbench.
-
Connect to Mocean from Asprova with CData Software ODBC Driver for Mocean
This article shows how to connect faster to Mocean data from Asprova.
-
How to Access Stripe Data Using Entity Framework
This article shows how to access Stripe data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Trigger Google Directory IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Directory with standard wizards in Logic Apps.
-
Query Zoho Inventory Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Inventory data from Node.js.
-
Use the CData Software ODBC Driver for Twitter Ads in MicroStrategy Desktop
Connect to Twitter Ads data in MicroStrategy Desktop using the CData Software ODBC Driver for Twitter Ads.
-
Integrating Gumloop with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Facebook Ads data within automated workflows.
-
Connect to Zoho Projects Data from a Connection Pool in JBoss
Integrate Zoho Projects data into Java servlets: Use the Management Console in JBoss to install the Zoho Projects JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Rootly
Create an ODBC connection to Rootly in Informatica and browse and transfer Rootly data.
-
Import and Visualize Calendly Data in Power View
Create data visualizations based on Calendly data in Excel.
-
How to Connect HCL Domino 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 HCL Domino data in real time using natural language.
-
Access Live FreshBooks 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 FreshBooks data through MCP integration.
-
Automated Continuous GitLab Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable GitLab replication to Apache Kafka.