CData Software - Knowledge Base
Recent Articles
-
Connect to Cloudant Data from PowerBuilder via JDBC
This article demonstrates how to access IBM Cloudant from PowerBuilder using the Cloudant JDBC Driver.
-
Build Paylocity-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Paylocity to explore live Paylocity Data in GitHub Copilot to assist with building Paylocity-powered applications.
-
Establish a Live Connection with SAP Ariba Source Data using Tableau Bridge
The CData ODBC Driver for SAP Ariba Source enables you to integrate live SAP Ariba Source into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Seamlessly Import Hubstaff Data into IBM SPSS Modeler
Integrate Hubstaff data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect to LightSpeedRetail Data from IntelliJ
Integrate connectivity to LightSpeedRetail with wizards in IntelliJ.
-
Natively Connect to Twilio Data in PHP
The CData ODBC driver for Twilio enables you to create PHP applications with connectivity to Twilio. Leverage the native support for ODBC in PHP.
-
Query Bright Data Data as a MySQL Database in Node.js
Execute MySQL queries against Bright Data from Node.js.
-
Automate LDAP Objects Replication to Azure Synapse
Use CData Sync to customize and automate LDAP replication to Azure Synapse.
-
Analyze Google Ads Data in Looker
Use CData Connect AI to connect to Google Ads Data from Looker and build custom apps using live Google Ads.
-
How to Connect to Live QuickBooks Online Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live QuickBooks Online securely in real time.
-
Publish Amazon Marketplace-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon Marketplace.
-
Build Automated Workflows with Live Zoho Books Data in Workato
Use CData Connect AI to connect to live Zoho Books and build automated workflows in Workato.
-
Integrating OpenCode Terminal with Presto 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.
-
Build Zoho CRM-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Zoho CRM to explore live Zoho CRM Data in Gemini Code Assist to assist with building Zoho CRM-powered applications.
-
Import OData Services Using Azure Data Factory
Use CData Connect AI to connect to OData Services from Azure Data Factory and import live OData.
-
Work with Live GitLab Data in Power Query
Use CData Connect AI to connect to GitLab and work with live GitLab in Microsoft Power Query.
-
Query Marketo Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Marketo and perform CRUD operations on Marketo from Node.js.
-
Build a Jira Dashboard with C# and MCP Server
Learn how to build a developer-focused Jira ticket monitoring dashboard using CData MCP Server and the CData ADO.NET Provider for Jira.
-
Power BI XMLA Reporting in OBIEE with the Power BI XMLA JDBC Driver
Deploy the Power BI XMLA JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for ServiceNow in MicroStrategy Web
Connect to ServiceNow in MicroStrategy Web using the CData Software ODBC Driver for ServiceNow.
-
Migrating data from SingleStore to Databricks using CData SSIS Components.
Easily push SingleStore to Databricks using the CData SSIS Tasks for SingleStore and Databricks.
-
Migrating data from Vimeo to Snowflake using CData SSIS Components.
Easily push Vimeo to Snowflake using the CData SSIS Tasks for Vimeo and Snowflake.
-
Integrating Boomi Agentstudio with Zoho Creator Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho Creator, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Work with Google Cloud Storage Data in AWS Glue Jobs Using JDBC
Connect to Google Cloud Storage from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Crystal Reports on Zoho Inventory Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Inventory.
-
LINQ to Float Data
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 Float Data Provider.
-
Create Cloudant Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cloudant data access from reports, embedded analytics, and more.
-
Connect to QuickBooks Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for QuickBooks to connect to QuickBooks Desktop and execute queries in PowerBuilder.
-
How to Build an ETL App for CloudConvert Data in Python with CData
Create ETL applications and real-time data pipelines for CloudConvert in Python with petl.
-
Getting Started with the CData Python Connector for Blackbaud FE NXT
Learn to install and license the CData Python Connector
-
Deploy the ADO.NET Provider for Snowflake on an SSRS Report Server
Connect to Snowflake 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.
-
Connect to Exa from a Connection Pool in WebLogic
Use the CData JDBC Driver for Exa to connect to Exa from Web applications running on WebLogic.
-
DataBind Controls to Perplexity Data in C++Builder
DataBind to Perplexity in C++Builder with standard components and controls.
-
Query, Visualize, and Share live Email Data in Redash
Use CData Connect AI to connect to live Email in Redash for querying, visualizing, and sharing.
-
Access Live Google Contacts Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Contacts from your Excel spreadsheets.
-
Connect to Oracle Financials Cloud Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Oracle Financials Cloud.
-
How to Query Live FTP Data in Perplexity MacOS Desktop
Connect to and query live FTP Data in Perplexity Desktop using CData MCP Server.
-
Build Apps with Live Hacker News Data Using the Low-Code Development Platform of Mendix
Connect Hacker News with Mendix to build apps using the CData API Driver for JDBC.
-
Model Snowflake Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Snowflake, enabling the direct import of real-time Snowflake.
-
Automated Continuous ActiveCampaign Replication to Oracle
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Oracle.
-
Establish a Live Connection with SingleStore Data using Tableau Bridge
The CData ODBC Driver for SingleStore enables you to integrate live SingleStore into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Pingdom-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pingdom.
-
Natively Connect to Bullhorn CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bullhorn CRM. Leverage the native support for ODBC in PHP.
-
Connect to QuickBooks Online Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live QuickBooks Online.
-
Connect to ZohoInvoice from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZohoInvoice to connect to ZohoInvoice from Web applications running on WebLogic.
-
Connect to Airtable Data in Ruby
Connect to Airtable in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate SharePoint Excel Services Data from PowerShell
Write a quick PowerShell script to query SharePoint Excel Services. Use connectivity to the live data to replicate SharePoint Excel Services to SQL Server.
-
Perform Batch Operations with Access Data in Apache NiFi
Connect to Microsoft Access and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
DataBind Controls to Microsoft OneDrive Data in Delphi
DataBind to Microsoft OneDrive in Delphi with standard data access components and controls.
-
Import and Visualize PagerDuty Data in Power View
Create data visualizations based on PagerDuty in Excel.
-
Connect to Real-Time SFTP Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SFTP and Dataflow to import and use SFTP in Power Apps.
-
Integrating Claude Code CLI with Opsgenie 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.
-
LINQ to Box Data
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 Box Data Provider.
-
Create SSAS Tabular Models from ZohoSubscriptions Data
How to build a SQL Server Analysis Service Tabular Model from ZohoSubscriptions using CData drivers.
-
Build Apps with Live Apify Data Using the Low-Code Development Platform of Mendix
Connect Apify with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to SQL Analysis Services Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SQL Analysis Services to connect to SQL Analysis Services and execute queries in PowerBuilder.
-
Automate Chargebee Data Replication to Azure Synapse
Use CData Sync to customize and automate Chargebee replication to Azure Synapse.
-
Integrating Boomi Agentstudio with Spark Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Apache Spark SQL, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Jodoo Replication to MySQL
Use CData Sync for automated, continuous, customizable Jodoo replication to MySQL.
-
Work with Keap Data in FoxPro
Load Keap into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Billsby Data in NetBeans
Connect to Billsby in NetBeans with the data source configuration wizard.
-
Create Snowflake-Connected Business Apps in AppSheet
Connect to Snowflake Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Snowflake.
-
Replicate ZohoDesk Data in Heroku for Use in Salesforce Connect
Replicate ZohoDesk to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
FormSite Reporting in OBIEE with the FormSite JDBC Driver
Deploy the FormSite JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Process & Analyze Adobe Analytics Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Adobe Analytics Data.
-
Connect to Vimeo Data in JRuby
Create a simple JRuby app with access to live Vimeo.
-
How to Build an ETL App for Zoho Projects Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho Projects in Python with petl.
-
Analyze Wave Financial Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Wave Financial from Power Pivot. You will use the Table Import Wizard to load Wave Financial. You can visually build the import query or use any SQL supported by the driver.
-
Design BIRT Reports on Clio Data
Provide current Clio to your embedded analytics.
-
Connect Bitly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bitly using the CData Python MCP Server.
-
How to create Visio diagrams from Bullhorn CRM Data
Automatically update Bullhorn CRM with the changes you make to Visio master shapes.
-
Build Dashboards with Oracle Financials Cloud Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle Financials Cloud in DBxtra.
-
Integrate ConstantContact Data in Pentaho Data Integration
Build ETL pipelines based on ConstantContact in the Pentaho Data Integration tool.
-
Use Biml to Build SSIS Tasks to Replicate Act CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Act CRM to SQL Server.
-
How to Connect to & Open Guru Data in Microsoft Excel
This article uses the CData ODBC driver for Guru to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Power BI Reports on Real-Time Confluence Data
Use the CData ODBC Driver for Confluence to visualize Atlassian Confluence in Power BI Desktop.
-
How to Build an ETL App for SurveyMonkey Data in Python with CData Connect AI
Build ETL pipelines that read and write live SurveyMonkey in Python with petl and the CData Connect AI Python SDK.
-
Build a Singer.io Tap for Sybase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sybase data using
-
Write a Simple Go Application to work with MYOB AccountRight Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MYOB AccountRight.
-
Build Freshdesk-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Freshdesk and build Freshdesk-connected web apps with Axios.
-
Create Datasets from Microsoft Entra ID in Domo Workbench and Build Visualizations of Microsoft Entra ID Data in Domo
Use the CData Software ODBC Driver for Microsoft Entra ID to create datasets from Microsoft Entra ID in Domo Workbench and then build visualizations in the Domo service.
-
Connecting Pipedream with Amazon DynamoDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Amazon DynamoDB data in real time.
-
Connect to Microsoft Dataverse Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Dataverse (CDS).
-
How to Connect to Live HCL Domino 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 HCL Domino for you.
-
Analyze Teamgate Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Teamgate in Microsoft R Open.
-
Query Google Calendar Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Calendar and perform CRUD operations on Google Calendar from Node.js.
-
Automated Continuous Excel Online Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Excel Online replication to Amazon S3.
-
Integrate Cursor with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Okta from within the editor.
-
Publish Crystal Reports on BigCommerce Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date BigCommerce.
-
How to Build an ETL App for Gmail Data in Python with CData
Create ETL applications and real-time data pipelines for Gmail in Python with petl.
-
Build an OLAP Cube in SSAS from Teamgate Data
Establish a connection to Teamgate data from SQL Server Analysis Services, and use the Teamgate Data Provider to build OLAP cubes for use in analytics and reporting.
-
Feed ZohoPeople Data into FineReport
How to set ZohoPeople as a JDBC data source in FineReport.
-
Build Couchbase-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Couchbase to explore live Couchbase Data in GitHub Copilot to assist with building Couchbase-powered applications.
-
How to Create Power BI Visual Reports with Real-Time Office 365 Data
Use CData Power BI Connectors to visualize Microsoft Office 365 in Power BI.
-
Integrate Bullhorn CRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Bullhorn CRM from Informatica Cloud.
-
Create Reports with eBay Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date eBay Analytics.
-
How to Visualize Microsoft Teams 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 Microsoft Teams in Python.
-
Automated Continuous Mailjet Replication to SQL Server
Use CData Sync for automated, continuous, customizable Mailjet replication to SQL Server.
-
Build Shortcut-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Shortcut.
-
Getting Started with the CData Excel Add-In for SingleStore
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SingleStore.