CData Software - Knowledge Base
Recent Articles
-
Create SSAS Tabular Models from Cvent Data
How to build a SQL Server Analysis Service Tabular Model from Cvent using CData drivers.
-
DataBind Mistral AI Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mistral AI to a chart.
-
Integrating Claude Code CLI with Parquet 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.
-
Manage AdRoll Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for AdRoll.
-
Use the CData Software JDBC Driver for Tanda in MicroStrategy Desktop
Connect to Tanda in MicroStrategy Desktop using the CData Software JDBC Driver for Tanda.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce Marketing
Create an ODBC connection to Salesforce Marketing in Informatica and browse and transfer Salesforce Marketing Cloud.
-
Build Excel Online-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Excel Online.
-
Automated Continuous Odoo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Odoo replication to SingleStore.
-
Use the CData Software ODBC Driver for Discord in SAS for Real-Time Reporting and Analytics
Connect to real-time Discord in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Discord.
-
Build MySQL-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MySQL and build MySQL-connected web apps with Axios.
-
Automated Continuous Eventbrite Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Eventbrite replication to delimited files (CSV/TSV).
-
Integrating Kiro CLI with Avaza 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 Query Omnisend Data in MySQL Workbench
Execute MySQL queries against live Omnisend from MySQL Workbench.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Cvent within intelligent workflows.
-
Import and Visualize LightSpeedRetail Data in Power View
Create data visualizations based on LightSpeedRetail in Excel.
-
Build Dashboards with Snowflake Data in DBxtra
Create dynamic dashboards and perform analytics based on Snowflake in DBxtra.
-
Use the CData Software ODBC Driver for Front in MicroStrategy
Connect to Front in MicroStrategy Developer using the CData Software ODBC Driver for Front.
-
Connect to Guru Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Guru and work with Guru in your FileMaker application.
-
Automated Continuous OnePageCrm Replication to SQLite
Use CData Sync for automated, continuous, customizable OnePageCrm replication to SQLite.
-
Build Data Flows from IBM Informix to SQL Server using SSIS
Easily back up IBM Informix to SQL Server using the SSIS components for IBM Informix.
-
Connect to and Query Codat Data in QlikView over ODBC
Create data visualizations with Codat in QlikView.
-
Automate MarkLogic Data Replication to Azure Data Lake
Use CData Sync to customize and automate MarkLogic replication to Azure Data Lake.
-
LINQ to LDAP Objects
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the LDAP Data Provider.
-
Establish a Live Connection with MarkLogic Data using Tableau Bridge
The CData ODBC Driver for MarkLogic enables you to integrate live MarkLogic into Tableau Cloud dashboards using the Tableau Bridge.
-
Build AI/ML Models with Live Moosend Data using Dataiku
Connect Moosend Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Typeform Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Typeform replication to OneLake in Microsoft Fabric.
-
Build Vault CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Vault CRM Data and create custom apps in Mendix.
-
Use the CData Software JDBC Driver for Active Directory in MicroStrategy
Connect to Active Directory in MicroStrategy Developer using the CData Software JDBC Driver for Active Directory.
-
Getting Started with the CData Tableau Connector for Everhour
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Live SAP HANA Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP HANA using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Zoho Recruit 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 Zoho Recruit into TIBCO Spotfire.
-
Add OnePageCrm Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for OnePageCrm with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Browserless Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Browserless and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData Software ODBC Driver for Freshservice in MicroStrategy Web
Connect to Freshservice in MicroStrategy Web using the CData Software ODBC Driver for Freshservice.
-
Connect to Microsoft Entra ID Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft Entra ID Data and connect to Microsoft Entra ID in Akorbi Digital RunMyProcess.
-
Connect to Discord Data from a Connection Pool in JBoss
Integrate Discord into Java servlets: Use the Management Console in JBoss to install the Discord JDBC Driver.
-
Build Dashboards with Workable Data in Dundas BI
Create dynamic dashboards and perform analytics based on Workable in Dundas BI.
-
Enable the CapsuleCRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CapsuleCRM.
-
Create Dynamic ConvertAPI Grids Using the Infragistics XamDataGrid
Learn how you can connect ConvertAPI to Infragistics XamDataGrid to build dynamic grids.
-
Query Zoho Books Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Books from Node.js.
-
Use the CData Software ODBC Driver for CampaignMonitor in SAS for Real-Time Reporting and Analytics
Connect to real-time CampaignMonitor in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CampaignMonitor.
-
Analyze Instantly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Instantly in Microsoft R Open.
-
Access Elasticsearch Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Elasticsearch from HeidiSQL.
-
Connect to Pushbullet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pushbullet to connect to Pushbullet from Web applications running on WebLogic.
-
How to create Google Campaign Manager 360 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Campaign Manager 360 in MySQL .
-
Connect to SharePoint Data from a Connection Pool in Jetty
The SharePoint JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft SharePoint from Web apps in Jetty.
-
Analyze Workday Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Workday and visualize live Workday in Infragistics Reveal.
-
Build a PostgreSQL Interface for Azure Data Catalog Data using the CData JDBC Driver
Use the Remoting features of the Azure Data Catalog JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Aircall Data in DataGrip
Create a Data Source for Aircall in DataGrip and use SQL to query live Aircall.
-
Publish Stack Exchange-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Stack Exchange.
-
Connect to and Visualize Live YouTube Analytics Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live YouTube Analytics.
-
Build Snowflake-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Snowflake Data and create custom apps in Bubble.
-
Import Real-Time Act CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Act CRM in ColdFusion.
-
Create Dashboards and Visualize Live SendGrid Data in Geckoboard
Use CData Connect AI to connect to live SendGrid and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Adobe Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Oracle.
-
Import Real-Time SAP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP ERP/NetWeaver in ColdFusion.
-
Connect to Testmonitor Data in Aqua Data Studio
Access Testmonitor from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect SharePoint with Google Cloud Storage Data through external lists
Provide Google Cloud Storage to SharePoint users as an external list.
-
Getting Started with the CData ODBC Driver for Campaigner
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Campaigner.
-
Building Dynamic Web Pages with Sage Intacct Data Using AngularJS
Create single-page applications with live connectivity to Sage Intacct using the CData API Server.
-
Consume Stripe OData Feeds in PowerBuilder
This article demonstrates how to consume Stripe as OData feeds from PowerBuilder using the API Server.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SendPulse to Power BI dashboards. Simply drag and drop SendPulse into data visuals on the Power BI canvas.
-
Using the CData Software ODBC Driver for Google Search in PyCharm
Connect to Google Search as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Search.
-
Automated Continuous Pipedrive Replication to SQLite
Use CData Sync for automated, continuous, customizable Pipedrive replication to SQLite.
-
Getting Started with the CData JDBC Driver for BambooHR
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for BambooHR.
-
Build Charts with Outreach.io Data in Clear Analytics
Create dynamic charts and perform analytics based on Outreach.io in Clear Analytics.
-
How to Connect Flowise AI Agents to Live Gong 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 Gong without replication.
-
Query Retently Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Retently from Node.js.
-
Provide OData Services of ZohoMarketingHub Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoMarketingHub by developing a WCF Service Application.
-
Integrate SharePoint with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SharePoint with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft SharePoint.
-
Build AI/ML Models with Live Dynamics NAV Data using Dataiku
Connect Dynamics NAV Data with Dataiku using the CData JDBC Driver for Dynamics NAV.
-
Connect to Tanda Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Tanda to connect to Tanda and execute queries in PowerBuilder.
-
Stream SAP Concur Data into Apache Kafka Topics
Access and stream SAP Concur in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Write a Simple Go Application to work with ServiceNow Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ServiceNow.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sugar CRM
Provide connectivity to Sugar CRM through an SAP BusinessObjects universe.
-
DataBind Moosend Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Moosend to a chart.
-
Integrate with Moosend Data in JReport Designer
Create charts and reports based on Moosend in JReport Designer.
-
Create Highrise-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Highrise Data from OutSystems and build custom enterprise apps using live Highrise CRM.
-
Perform Batch Operations with Quickbase Data in Apache NiFi
Connect to Quickbase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Apps with Live Neo4J Data Using the Low-Code Development Platform of Mendix
Connect Neo4J with Mendix to build apps using the CData JDBC Driver for Neo4J.
-
Integrate SendGrid Data in the Pentaho Report Designer
Publish reports based on SendGrid in the Pentaho BI tool.
-
Create Cvent-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Cvent Data from Klipfolio and build custom visualizations using live Cvent.
-
Connect to Presto Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Presto.
-
Create Google Spanner-Connected Business Apps in AppSheet
Connect to Google Spanner Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Spanner.
-
Query Twilio Data in DataGrip
Create a Data Source for Twilio in DataGrip and use SQL to query live Twilio.
-
Connect to Exa Data in Jaspersoft Studio
Execute SQL to remote Exa in Jaspersoft Studio.
-
Query Exa Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Exa from Node.js.
-
Automate Reckon Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Reckon from PowerShell? This article demonstrates how to utilize the Reckon Cmdlets for tasks like connecting to Reckon, automating operations, downloading data, and more.
-
Building Dynamic Web Pages with Suadeo Data Using AngularJS
Create single-page applications with live connectivity to Suadeo using the CData API Server.
-
Automated Continuous SendPulse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SendPulse replication to Amazon Redshift.
-
Create Google Tasks Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Tasks from PowerBI.com to create Power BI Dataflows with real-time data.
-
Migrating data from CloudConvert to Google BigQuery using CData SSIS Components.
Easily push CloudConvert to Google BigQuery using the CData SSIS Tasks for CloudConvert and Google BigQuery.
-
Build Apps with Live Salesforce CRM Analytics Data Using the Low-Code Development Platform of Mendix
Connect Salesforce CRM Analytics with Mendix to build apps using the CData JDBC Driver for Salesforce CRM Analytics.
-
Use Databricks Agent Bricks to Talk to Your Azure DevOps Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure DevOps for you.
-
Getting Started with the CData Power BI Connector for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Import Real-Time SQL Analysis Services Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SQL Analysis Services in ColdFusion.
-
Build a PostgreSQL Interface for LionDesk Data using the CData JDBC Driver
Use the Remoting features of the LionDesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from ChargeOver to Google BigQuery using CData SSIS Components.
Easily push ChargeOver to Google BigQuery using the CData SSIS Tasks for ChargeOver and Google BigQuery.
-
Extend Google Sheets with Clari Data
Make calls to Clari from Google Apps Script via the API Server.
-
Build Visualizations of Humanity Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Humanity in Birst.