CData Software - Knowledge Base
Recent Articles
-
Connect to Google Ad Manager Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Ad Manager in Airbyte.
-
Migrating data from Greenhouse to Google BigQuery using CData SSIS Components.
Easily push Greenhouse to Google BigQuery using the CData SSIS Tasks for Greenhouse and Google BigQuery.
-
Deploy the ADO.NET Provider for Invoiced on an SSRS Report Server
Connect to Invoiced from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Getting Started with the CData Excel Add-In for Gumroad
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Gumroad.
-
Extend Google Sheets with Parquet Data
Make calls to Parquet from Google Apps Script via the API Server.
-
Connect to Live Databricks Data in MicroStrategy through CData Connect AI
Create a live connection to Databricks Data in CData Connect AI and connect to your Databricks from MicroStrategy.
-
Automated Continuous Zendesk Replication to Databricks
Use CData Sync for automated, continuous, customizable Zendesk replication to Databricks.
-
Replicate Multiple Teamwork Accounts
Replicate multiple Teamwork accounts to one or many databases.
-
Validate Google Cloud Storage Data with QuerySurge
Access and validate Google Cloud Storage in QuerySurge using the CData JDBC Driver.
-
Connect to Clari Data in DBeaver
Use the CData ODBC Driver to connect to Clari in DBeaver.
-
How to Access Attio Data Using Entity Framework
This article shows how to access Attio using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Zoho Inventory Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho Inventory through CData Connect AI using different applications and tools.
-
Import Real-Time xBase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use xBase in ColdFusion.
-
Create WooCommerce-Connected Business Apps in AppSheet
Connect to WooCommerce Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to WooCommerce.
-
How to Connect to Live Google Directory Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Directory securely in real time.
-
Back Up Wave Financial to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Wave Financial. In this article, we will employ an SSIS workflow to populate a database with Wave Financial data.
-
Analyze Airtable Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Airtable and visualize live Airtable in Infragistics Reveal.
-
Feed ZendeskSell Data into FineReport
How to set ZendeskSell as a JDBC data source in FineReport.
-
Analyze Google Campaign Manager 360 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Campaign Manager 360 and visualize live Google Campaign Manager 360 in Infragistics Reveal.
-
Getting Started with the CData ADO.NET Provider for Jodoo
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Sybase IQ Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sybase IQ through CData Connect AI using different applications and tools.
-
DataBind Controls to Reckon Accounts Hosted Data in C++Builder
DataBind to Reckon Accounts Hosted in C++Builder with standard components and controls.
-
Build Charts with Codat Data in Clear Analytics
Create dynamic charts and perform analytics based on Codat in Clear Analytics.
-
Natively Connect to SharePoint Excel Services Data in PHP
The CData ODBC driver for SharePoint Excel Services enables you to create PHP applications with connectivity to SharePoint Excel Services. Leverage the native support for ODBC in PHP.
-
Create Pinecone Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pinecone from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect PolyBase to SAP Hybris C4C
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Hybris C4C.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Shopify to Power BI dashboards. Simply drag and drop Shopify into data visuals on the Power BI canvas.
-
Access ServiceNow Data from MySQL in Amazon QuickSight
Connect to ServiceNow and build visualizations of ServiceNow using a MySQL Connection in Amazon QuickSight.
-
Migrating data from MailerLite to Databricks using CData SSIS Components.
Easily push MailerLite to Databricks using the CData SSIS Tasks for MailerLite and Databricks.
-
How to load Placid data into Elasticsearch via Logstash
Introducing a simple method to load Placid data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Cursor CLI with Customer.io 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.
-
Integrating LangChain with Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Ads within automated workflows.
-
How to Query Live Jira Assets Data in Perplexity MacOS Desktop
Connect to and query live Jira Assets Data in Perplexity Desktop using CData MCP Server.
-
Build Epicor Kinetic-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Epicor Kinetic Data from Zoho Analytics and import live Epicor Kinetic.
-
How to create Blackbaud FE NXT federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Blackbaud FE NXT in MySQL .
-
Automated Continuous Shippo Replication to MySQL
Use CData Sync for automated, continuous, customizable Shippo replication to MySQL.
-
Write a Simple Go Application to work with Spark Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache Spark SQL.
-
Build Highrise-Connected Apps in Choreo
Use CData Connect AI to connect to Highrise Data from Choreo and build custom apps using live Highrise CRM.
-
Moving Data from Shortcut to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Shortcut data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Prepare, Blend, and Analyze Microsoft OneDrive Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft OneDrive for self-service data analytics.
-
Replicate Procore Data in Heroku for Use in Salesforce Connect
Replicate Procore to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create a Data Access Object for Freshsales Data using JDBI
A brief overview of creating a SQL Object API for Freshsales in JDBI.
-
Automated Continuous Salesforce Pardot Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to IBM DB2.
-
Integrating Kiro CLI with CloudConvert 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 Invoiced to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Invoiced using the CData Python MCP Server.
-
Connect to Hacker News Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Hacker News and the SQL Gateway to access Hacker News from Google Apps Script.
-
How to connect and process Invoiced from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Invoiced.
-
How to import GitHub Data into Apache Solr
Use the CData Software JDBC Driver for GitHub in Data Import Handler and create an automated import of GitHub to Apache Solr Enterprise Search platform.
-
Build Active Directory-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Active Directory to explore live Active Directory Data in Cursor to assist with building Active Directory-powered applications.
-
Validate Dynamics 365 Business Central Data with QuerySurge
Access and validate Dynamics 365 Business Central in QuerySurge using the CData JDBC Driver.
-
Build Data Flows from SQL Server to SFTP through SSIS
Easily push SQL Server data to SFTP using the CData SSIS Tasks for SFTP.
-
Query Mixpanel Data in DataGrip
Create a Data Source for Mixpanel in DataGrip and use SQL to query live Mixpanel.
-
SendGrid Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SendGrid through CData Connect AI using different applications and tools.
-
Connect to Kintone Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Kintone Data and connect to Kintone in Akorbi Digital RunMyProcess.
-
Seamlessly Bring Elasticsearch Data into Retool Using CData Connect AI
Integrate Elasticsearch data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData Software ODBC Driver for ZohoPeople in MicroStrategy Desktop
Connect to ZohoPeople in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoPeople.
-
Access Live Blackbaud FE NXT Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Blackbaud FE NXT data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Dashboards with ShipStation Data in DBxtra
Create dynamic dashboards and perform analytics based on ShipStation in DBxtra.
-
Integrating Kiro CLI with MailChimp 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.
-
Bridge SparkPost Connectivity with Apache NiFi
Access and process SparkPost in Apache NiFi using the CData JDBC Driver.
-
Integrate with ConvertKit Data in JReport Designer
Create charts and reports based on ConvertKit in JReport Designer.
-
Access Live SAP HANA Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP HANA from your Excel spreadsheets.
-
Build CapsuleCRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CapsuleCRM.
-
Automated Continuous Facebook Replication to SingleStore
Use CData Sync for automated, continuous, customizable Facebook replication to SingleStore.
-
Use Claude to Talk to Your Epicor Kinetic 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 Epicor Kinetic for you.
-
How to import Airtable Data into Apache Solr
Use the CData Software JDBC Driver for Airtable in Data Import Handler and create an automated import of Airtable to Apache Solr Enterprise Search platform.
-
Connect to Live Office 365 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Office 365 in CData Connect AI and connect to your Microsoft Office 365 from PostgreSQL.
-
Integrate Live GitLab Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to GitLab from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live GitLab.
-
Getting Started with the CData Tableau Connector for Odoo
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Odoo.
-
Build Dynamics 365 Business Central-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dynamics 365 Business Central Data and create custom apps in Mendix.
-
Analyze Authorize.Net Data in Looker
Use CData Connect AI to connect to Authorize.Net Data from Looker and build custom apps using live Authorize.Net.
-
How to load Zoho Creator data into Elasticsearch via Logstash
Introducing a simple method to load Zoho Creator data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with Pipedrive Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Pipedrive in SnapLogic.
-
Publish Crystal Reports on BenchmarkEmail Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date BenchmarkEmail.
-
Query MariaDB Data as a MySQL Database in Node.js
Execute MySQL queries against MariaDB from Node.js.
-
Feed SAP Business Warehouse Data into FineReport
How to set SAP Business Warehouse as a JDBC data source in FineReport.
-
Deploy the ADO.NET Provider for Discourse on an SSRS Report Server
Connect to Discourse from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
DataBind SAP Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP with the DevExpress Windows Forms and Web controls to provide SAP ERP/NetWeaver to a chart.
-
Integrating Dataiku with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Acumatica ERP.
-
Use the CData Software ODBC Driver for SuiteCRM in MicroStrategy Web
Connect to SuiteCRM in MicroStrategy Web using the CData Software ODBC Driver for SuiteCRM.
-
Use the CData API Server to Access Airtable Data in Microsoft PowerPivot
Use the CData API Server to connect to live Airtable in the Power Pivot business intelligence tool.
-
Build Apps with Live Kafka Data Using the Low-Code Development Platform of Mendix
Connect Apache Kafka with Mendix to build apps using the CData JDBC Driver for Kafka.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy
Connect to Adobe Analytics in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Analytics.
-
Build Apps with Live Zoho Books in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoho Books into the Adalo platform and build custom mobile and web applications with real-time Zoho Books.
-
Automated Continuous Aircall Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Aircall replication to AlloyDB.
-
Create Data Visualizations in Cognos BI with DocuSign Data
Access DocuSign as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Paddle Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Paddle in the Denodo Virtual DataPort Administrator.
-
Object-Relational Mapping (ORM) with Mailjet 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 Mailjet into a Java-based ORM framework, Hibernate.
-
Access Elorus Data from MySQL in PHP
Connect to Elorus through the standard MySQL libraries in PHP.
-
Integrate Live Azure Analysis Services Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Analysis Services to Blue Prism using the CData ODBC Driver for Azure Analysis Services to create automated workflows for repetitive business tasks.
-
Access Live Monday.com Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Monday.com through MCP integration.
-
Visualize Monday.com 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 Monday.com into TIBCO Spotfire.
-
Stream Coda Data into Apache Kafka Topics
Access and stream Coda in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with Invoiced Data in ETL Validator JDBC
Connect to Invoiced from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Zoho Books Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoho Books in Google Apps Script.
-
Connect to SendInBlue Data in RapidMiner
Integrate SendInBlue with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Live API Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live API directly from the development environment.
-
Build Apps with Live CockroachDB Data Using the Low-Code Development Platform of Mendix
Connect CockroachDB with Mendix to build apps using the CData JDBC Driver for CockroachDB.
-
Connect to Greenhouse Data in Jaspersoft Studio
Execute SQL to remote Greenhouse in Jaspersoft Studio.
-
Automate Tasks in Power Automate Using the CData API Server
Automate PostgreSQL actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.