CData Software - Knowledge Base
Recent Articles
-
Connect to Invoiced Data in Jaspersoft Studio
Execute SQL to remote Invoiced data in Jaspersoft Studio.
-
Connect to Freshdesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshdesk data using standard SQL.
-
Connect to Redis Data in Google Apps Script via Connect AI
Use CData Connect AI to access Redis data in Google Apps Script.
-
Deploy the ADO.NET Provider for MySQL on an SSRS Report Server
Connect to MySQL data 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.
-
Deploy the ADO.NET Provider for Oracle Financials Cloud on an SSRS Report Server
Connect to Oracle Financials Cloud data 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.
-
Manage Templated Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Templated.
-
Replicate Multiple Nethunt Accounts via the CData Sync CLI
Replicate multiple Nethunt accounts to one or many databases.
-
How to create MySQL federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MySQL data in MySQL .
-
Excel Spreadsheet Automation on Highrise Data with the QUERY Formula
Pull data from Highrise, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Office 365 Replication to Vertica
Use CData Sync for automated, continuous, customizable Office 365 replication to Vertica.
-
Connect to Adobe Target Data in Aqua Data Studio
Access Adobe Target data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live PayPal Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live PayPal data without replication.
-
Write a Simple Go Application to work with Sybase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sybase data.
-
Validate Airtable Data with QuerySurge
Access and validate Airtable data in QuerySurge using the CData JDBC Driver.
-
Natively Connect to SAP Ariba Procurement Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Ariba Procurement data. Leverage the native support for ODBC in PHP.
-
Migrating data from Telegram to Google BigQuery using CData SSIS Components.
Easily push Telegram data to Google BigQuery using the CData SSIS Tasks for Telegram and Google BigQuery.
-
Automated Continuous Azure Data Catalog Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to AlloyDB.
-
Integrate Dify with Live Zoho Projects Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Zoho Projects data.
-
Automated Continuous SAP Ariba Procurement Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to AlloyDB.
-
Access SAP SuccessFactors LMS Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP SuccessFactors LMS data from your Oracle system.
-
How to Access Live WordPress Data in Power Automate Desktop via ODBC
The CData ODBC Driver for WordPress enables you to integrate WordPress data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Printify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Printify data replication to OneLake in Microsoft Fabric.
-
Build Data Flows from Jumpseller to SQL Server using SSIS
Easily back up Jumpseller data to SQL Server using the SSIS components for Jumpseller.
-
Publish ZohoMarketingHub-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoMarketingHub data.
-
Automated Continuous Marketo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Marketo replication to SingleStore.
-
Connect to Clockify Data in Jaspersoft Studio
Execute SQL to remote Clockify data in Jaspersoft Studio.
-
Create SAS xpt-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAS xpt Data from OutSystems and build custom enterprise apps using live SAS xpt data.
-
Automate Raisers Edge NXT Data Replication to Couchbase
Use CData Sync to Customize and automate Raisers Edge NXT data replication to Couchbase.
-
Publish Reports with ZarMoney Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZarMoney data.
-
Object-Relational Mapping (ORM) with MYOB AccountRight 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 MYOB AccountRight data into a Java-based ORM framework, Hibernate.
-
Connect to Freshdesk Data in JRuby
Create a simple JRuby app with access to live Freshdesk data.
-
Write a Simple Go Application to work with Vercel Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Vercel data.
-
Connect to Spark Data from HeidiSQL
Use CData Connect AI to connect to and query live Spark data from HeidiSQL.
-
DataBind Controls to Exa Data in Delphi
DataBind to Exa data in Delphi with standard data access components and controls.
-
Write a Simple Go Application to work with Supabase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Supabase data.
-
How to Connect the Power BI Service to Nethunt: Complete Guide
Connect to the CData Software Power BI Connector for Nethunt from PowerBI.com to provide real-time Nethunt data across the organization.
-
Connect to Pipeline CRM Data in DBArtisan
Use wizards in DBArtisan to configure Pipeline CRM data as a data source.
-
Visualize Live ActiveCampaign Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ActiveCampaign data.
-
Integrate Google's Antigravity Agent with Live Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Jumpseller data using the Model Context Protocol.
-
How to Connect to Live Coda Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Coda data through natural language.
-
Connect to Live Oracle Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle in CData Connect AI and connect to your Oracle data from PostgreSQL.
-
Extract, Transform, and Load Cassandra Data in Informatica PowerCenter
Create a simple Workflow for Cassandra data in Informatica PowerCenter.
-
Use Manus AI to Talk to Your Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Oracle SCM data.
-
Connect to MYOB AccountRight Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for MYOB AccountRight and the Script function in FileMaker Pro to connect to MYOB AccountRight and work with MYOB AccountRight data in your FileMaker application.
-
Connect to Real-Time Reckon Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Reckon and Dataflow to import and use Reckon data in Power Apps.
-
Build Simplesat-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Simplesat data and build web apps with connectivity to live Simplesat data.
-
Enable the GraphQL JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with GraphQL data.
-
How to Access Live Deel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Deel enables you to integrate Deel data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Microsoft Entra ID in MicroStrategy Desktop
Connect to Microsoft Entra ID data in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Entra ID.
-
Publish Avalara AvaTax-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Avalara AvaTax data.
-
Replicate Multiple Harvest Accounts via the CData Sync CLI
Replicate multiple Harvest accounts to one or many databases.
-
Natively Connect to Autopilot Data in PHP
The CData ODBC driver for Autopilot enables you to create PHP applications with connectivity to Autopilot data. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for Demio in Microsoft Power Query
You can use the CData Demio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Demio data into Microsoft Power Query.
-
Perform Batch Operations with Sybase IQ Data in Apache NiFi
Connect to Sybase IQ data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Live Mocean Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mocean data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Salesforce Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce and the Script function in FileMaker Pro to connect to Salesforce and work with Salesforce data in your FileMaker application.
-
How to Connect the Power BI Service to Bannerbear: Complete Guide
Connect to the CData Software Power BI Connector for Bannerbear from PowerBI.com to provide real-time Bannerbear data across the organization.
-
Replicate Multiple Phoenix Accounts via the CData Sync CLI
Replicate multiple Phoenix accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for Tanda
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tanda.
-
Build an OLAP Cube in SSAS from Microsoft Dataverse Data
Establish a connection to Microsoft Dataverse data data from SQL Server Analysis Services, and use the Microsoft Dataverse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to HelloSign Data from PowerBuilder via ADO.NET
This article demonstrates how to access HelloSign data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Aha! Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Aha! facts in real time.
-
How to Connect the Power BI Service to ServiceNow: Complete Guide
Connect to the CData Software Power BI Connector for ServiceNow from PowerBI.com to provide real-time ServiceNow data across the organization.
-
Use Databricks Agent Bricks to Talk to Your WordPress Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your WordPress data for you.
-
Connect Sybase IQ to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sybase IQ with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Freshservice Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Freshservice data securely in real time.
-
Integrating Claude Code CLI with Snapchat Ads 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 PagerDuty 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 PagerDuty and work with PagerDuty data in your FileMaker application.
-
Use Azure AI Foundry to Talk to Your Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Zendesk data for you.
-
Perform Batch Operations with Cloudant Data in Apache NiFi
Connect to Cloudant data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build AI/ML Models with Live Campaigner Data using Dataiku
Connect Campaigner Data with Dataiku using the CData API Driver for JDBC.
-
Build Google Forms Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Forms data and build visualizations in Tableau.
-
Connect to Avalara AvaTax Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Avalara AvaTax and the SQL Gateway to access Avalara AvaTax data from Google Apps Script.
-
Integrating GitHub Copilot with Teamgate 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.
-
Use Dash to Build Web Apps on Salesforce Data via CData Connect AI
Build interactive Dash web apps on live Salesforce data using pandas and the CData Connect AI Python SDK.
-
Integrate Real-Time Access to SAP SuccessFactors LMS in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP SuccessFactors LMS data in real time.
-
Connect to Epicor Kinetic Data in CloverDX (formerly CloverETL)
Transfer Epicor Kinetic data using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Tickspot to Google BigQuery using CData SSIS Components.
Easily push Tickspot data to Google BigQuery using the CData SSIS Tasks for Tickspot and Google BigQuery.
-
How to Access SuiteCRM Data Using Entity Framework
This article shows how to access SuiteCRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connecting Mastra with GitHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time GitHub data, no replication required.
-
Integrate Oracle Data into Power Automate Desktop using CData Connect
CData Connect for Oracle Data enables you to integrate Oracle data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Hacker News Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Hacker News data replication to OneLake in Microsoft Fabric.
-
Build a Simple VCL Application for Vault CRM Data
How to build a simple VCL Application to view Vault CRM data in RAD Studio using the CData ODBC Driver for Vault CRM.
-
How to load Sybase IQ data into Elasticsearch via Logstash
Introducing a simple method to load Sybase IQ data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Easily Query QuickBooks Time Data in OpenOffice Base
Connect to QuickBooks Time data in OpenOffice Base using the CData ODBC Driver for QuickBooks Time and generate reports with live data insights.
-
Integrate Live MariaDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live MariaDB data from within the IDE.
-
Access Live Sage Cloud Accounting Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage Cloud Accounting data into the statistical analysis tools available in SAS JMP. This article shows how to use Sage Cloud Accounting data in the Graph Builder and Query Builder.
-
Connect to Zoho Inventory Data from a Connection Pool in JBoss
Integrate Zoho Inventory data into Java servlets: Use the Management Console in JBoss to install the Zoho Inventory JDBC Driver.
-
How to connect and process Gorgias data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Gorgias data.
-
Create Customer.io Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Customer.io data access from reports, embedded analytics, and more.
-
Create Dashboards and Visualize Live ZohoExpense Data in Geckoboard
Use CData Connect AI to connect to live ZohoExpense data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Work with Mixpanel Data in AWS Glue Jobs Using JDBC
Connect to Mixpanel from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create TigerGraph Dataflows on PowerBI.com
Connect to the CData Power BI Connector for TigerGraph from PowerBI.com to create Power BI Dataflows with real-time data.
-
Load Keap Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Keap data to a database.
-
Integrate OpenCode with Live Google Directory Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Google Directory data from within your AI coding agent.
-
Connect to Freshteam Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Freshteam data.
-
How to work with Guru Data in Apache Spark using SQL
Access and process Guru Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to TaxJar 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 TaxJar data.
-
Connect to Redshift Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Redshift to connect to Redshift data and execute queries in PowerBuilder.
-
Build Oracle Financials Cloud-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle Financials Cloud Data and create custom apps in Mendix.