CData Software - Knowledge Base
Recent Articles
-
Enable the Auth0 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Auth0.
-
Build a PostgreSQL Interface for Brex Data using the CData JDBC Driver
Use the Remoting features of the Brex JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live SAS xpt Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAS xpt from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAS XPORT.
-
Integrate Zoho Recruit Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Recruit from Informatica Cloud.
-
Getting Started with the CData Python Connector for Elorus
Learn to install and license the CData Python Connector
-
Automated Continuous PolarTeamPro Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to IBM DB2.
-
Getting Started with the CData Tableau Connector for Phoenix
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Phoenix.
-
Publish ZarMoney-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZarMoney.
-
Connect to JSON from a Connection Pool in WebLogic
Use the CData JDBC Driver for JSON to connect to JSON from Web applications running on WebLogic.
-
Use the CData Software JDBC Driver for Excel in MicroStrategy Desktop
Connect to Microsoft Excel in MicroStrategy Desktop using the CData Software JDBC Driver for Excel.
-
Query Live Acumatica 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 Acumatica ERP directly from the development environment.
-
Connect to HCL Domino Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HCL Domino to connect to HCL Domino and execute queries in PowerBuilder.
-
Connect to XML from Asprova with CData Software ODBC Driver for XML
This article shows how to connect faster to XML data from Asprova.
-
Replicate Zoho Creator Data to Multiple Databases
Replicate Zoho Creator to disparate databases with a point-and-click configuration.
-
Access Datadog Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Datadog from HeidiSQL.
-
Build Semantic Layer Views for Xero Data in APOS Live Data Gateway
Use the CData Connector for Xero in APOS Live Data Gateway to build Semantic Layer Views for Xero Accounting.
-
Integrate Microsoft Entra ID Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Entra ID Data enables you to integrate Microsoft Entra ID into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ADO.NET Provider for Suadeo
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Suadeo.
-
Connect to Onfleet Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Onfleet and work with Onfleet in your FileMaker applications.
-
Configure the CData JDBC Driver for Notion in a Connection Pool in Tomcat
Connect to Notion from a connection pool in Tomcat.
-
Visualize Vercel Data in Sisense
Create an ElastiCube in Sisense app with access to Vercel.
-
Automated Continuous Klaviyo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Klaviyo replication to Amazon Redshift.
-
Automated Elorus Data Replication to Teradata
Use CData Sync to Customize and automate Elorus replication to Teradata.
-
How to connect to Unbounce Data from IntelliJ
Integrate connectivity to Unbounce with wizards in IntelliJ.
-
Query SAP HANA XS Advanced Data as a MySQL Database in Node.js
Execute MySQL queries against SAP HANA XS Advanced from Node.js.
-
Build Reckon Accounts Hosted-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Reckon Accounts Hosted Data and create custom apps in Mendix.
-
DataBind Charts to Contentful Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Contentful from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated Continuous PostgreSQL Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Google Cloud SQL.
-
Access Live Outreach.io Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Outreach.io in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate FHIR Data Replication to Azure Data Lake
Use CData Sync to customize and automate FHIR replication to Azure Data Lake.
-
Connect to Zuora Data in RapidMiner
Integrate Zuora with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Goose with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Freshdesk from within the local AI agent.
-
Back Up Zoho Books to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho Books. In this article, we will employ an SSIS workflow to populate a database with Zoho Books data.
-
How to integrate eBay with Apache Airflow
Access and process eBay in Apache Airflow using the CData JDBC Driver.
-
Bidirectional Access to Placid Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Placid in Filemaker Pro for Mac or Windows.
-
Analyze Dynamics 365 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Dynamics 365 and visualize live Microsoft Dynamics 365 in Infragistics Reveal.
-
Build Dashboards with BenchmarkEmail Data in DBxtra
Create dynamic dashboards and perform analytics based on BenchmarkEmail in DBxtra.
-
How to load ZohoInvoice data into Elasticsearch via Logstash
Introducing a simple method to load ZohoInvoice data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Access Live Recurly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Recurly enables you to integrate Recurly into workflows built using Microsoft Power Automate Desktop.
-
Access Live Facebook Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Facebook Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Building Dynamic Web Pages with eBay Data Using AngularJS
Create single-page applications with live connectivity to eBay using the CData API Server.
-
Use Claude to Talk to Your Sage 200 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 Sage 200 for you.
-
Build Elasticsearch-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Elasticsearch to explore live Elasticsearch Data in Cursor to assist with building Elasticsearch-powered applications.
-
Create Raisers Edge NXT-Connected Business Apps in AppSheet
Connect to Raisers Edge NXT Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Raisers Edge NXT.
-
View Reports on Real-Time Zoho CRM Data in Power BI Report Server
Use the CData ODBC Driver for Zoho CRM to visualize Zoho CRM in Power BI Desktop and then publish them to Power BI Report Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Planner
Provide connectivity to Microsoft Planner through an SAP BusinessObjects universe.
-
Access Live Acumatica 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 Acumatica ERP through MCP integration.
-
Integrate Sage Cloud Accounting Data in Pentaho Data Integration
Build ETL pipelines based on Sage Business Cloud Accounting in the Pentaho Data Integration tool.
-
How to Create Power BI Visual Reports with Real-Time Google Analytics Data
Use CData Power BI Connectors to visualize Google Analytics in Power BI.
-
Natively Connect to Oracle Eloqua Data in PHP
The CData ODBC driver for Oracle Eloqua enables you to create PHP applications with connectivity to Oracle Eloqua. Leverage the native support for ODBC in PHP.
-
Integrate Clockify Data in Pentaho Data Integration
Build ETL pipelines based on Clockify in the Pentaho Data Integration tool.
-
Rapidly Develop Autopilot-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Autopilot.
-
How to Query Live Google Cloud Storage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Cloud Storage data in natural language using Python.
-
DataBind Controls to SpaceX Data in Delphi
DataBind to SpaceX in Delphi with standard data access components and controls.
-
Choosing the Best Method to Connect Gmail to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Gmail from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Rebilly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Rebilly from PowerShell? This article demonstrates how to utilize the Rebilly Cmdlets for tasks like connecting to Rebilly, automating operations, downloading data, and more.
-
Create TaxJar Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time TaxJar data access from reports, embedded analytics, and more.
-
Connect to Teamwork Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Teamwork in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData ODBC Driver for Humanity
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Humanity.
-
DataBind Controls to MYOB AccountRight Data in C++Builder
DataBind to MYOB AccountRight in C++Builder with standard components and controls.
-
Natively Connect to Webex Data in PHP
The CData ODBC driver for Webex enables you to create PHP applications with connectivity to Webex. Leverage the native support for ODBC in PHP.
-
Automated Continuous Google Forms Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Forms replication to OneLake in Microsoft Fabric.
-
Analyze ClickTime Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ClickTime with the CData JDBC Driver for ClickTime.
-
Connect to Aircall Data in Ruby
Connect to Aircall in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Reckon Replication to SingleStore
Use CData Sync for automated, continuous, customizable Reckon replication to SingleStore.
-
Integrating Cursor CLI with SAP HANA XS Advanced 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 Paymo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Paymo and work with Paymo in your FileMaker applications.
-
How to import Egnyte Data into Apache Solr
Use the CData Software JDBC Driver for Egnyte in Data Import Handler and create an automated import of Egnyte to Apache Solr Enterprise Search platform.
-
Rapidly Develop PagerDuty-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by PagerDuty.
-
Connect to Shortcut Data from a Connection Pool in Jetty
The Shortcut JDBC Driver supports connection pooling: This article shows how to connect faster to Shortcut from Web apps in Jetty.
-
How to Connect the Power BI Service to Cohere: Complete Guide
Connect to the CData Software Power BI Connector for Cohere from PowerBI.com to provide real-time Cohere across the organization.
-
How to Access Live Azure Synapse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Synapse enables you to integrate Azure Synapse into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAP SuccessFactors LMS Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP SuccessFactors LMS in FileMaker Pro to connect to SAP SuccessFactors LMS and work with SAP SuccessFactors LMS in your FileMaker applications.
-
Create Dynamic YouTube Analytics Grids Using the Infragistics XamDataGrid
Learn how you can connect YouTube Analytics to Infragistics XamDataGrid to build dynamic grids.
-
Integrate with Wistia Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Wistia to a JSON file on disk.
-
Create Campaigner Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Campaigner from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Google Spanner-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Spanner Data from Klipfolio and build custom visualizations using live Google Spanner.
-
Analyze Supabase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Supabase with the CData JDBC Driver for Supabase.
-
Integrate Hacker News Data in Pentaho Data Integration
Build ETL pipelines based on Hacker News in the Pentaho Data Integration tool.
-
Connect to Office 365 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Office 365 from Crystal Reports.
-
Getting Started with the CData Python Connector for ChargeOver
Learn to install and license the CData Python Connector
-
Create SSAS Tabular Models from Bitly Data
How to build a SQL Server Analysis Service Tabular Model from Bitly using CData drivers.
-
Replicate Freshteam Data from PowerShell
Write a quick PowerShell script to query Freshteam. Use connectivity to the live data to replicate Freshteam to SQL Server.
-
Use Manus AI to Talk to Your Stripe 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 Stripe.
-
How to integrate Coinbase with Apache Airflow
Access and process Coinbase in Apache Airflow using the CData JDBC Driver.
-
Create a Data Access Object for Zuora Data using JDBI
A brief overview of creating a SQL Object API for Zuora in JDBI.
-
Stream Yelp Data into Apache Kafka Topics
Access and stream Yelp in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Visualizations of Excel Online Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Excel Online in Birst.
-
Creating IBM Informix-Connected Applications in Unqork
You can use CData Connect AI to feed IBM Informix to Unqork and build custom business apps.
-
Access Nuclia Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Nuclia from your Oracle system.
-
Integrating GitHub Copilot CLI with Ontraport 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.
-
Create Reports with Discord Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Discord.
-
Automated Continuous Google Ads Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Ads replication to PostgreSQL.
-
Automate Asana Data Replication to Azure Data Lake
Use CData Sync to customize and automate Asana replication to Azure Data Lake.
-
Access Bright Data Data from MySQL in Amazon QuickSight
Connect to Bright Data and build visualizations of Bright Data using a MySQL Connection in Amazon QuickSight.
-
Visualize SAP Business Warehouse Data in TIBCO Spotfire through OData
Integrate SAP Business Warehouse into dashboards in TIBCO Spotfire.
-
How to Access Vault CRM Data Using Entity Framework
This article shows how to access Veeva Vault & Vault CRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to ConvertAPI Data from PowerBuilder via JDBC
This article demonstrates how to access ConvertAPI from PowerBuilder using the ConvertAPI JDBC Driver.
-
How to connect to Qualaroo Data from IntelliJ
Integrate connectivity to Qualaroo with wizards in IntelliJ.
-
How to Work with ConvertKit Data in AWS Glue Jobs Using JDBC
Connect to ConvertKit from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.