CData Software - Knowledge Base
Recent Articles
-
Perform Batch Operations with BigCommerce Data in Apache NiFi
Connect to BigCommerce and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Analyze Google Search Results with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Search from Power Pivot. You will use the Table Import Wizard to load Google Search. You can visually build the import query or use any SQL supported by the driver.
-
Build Quickbase-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Quickbase to explore live Quickbase Data in Cursor to assist with building Quickbase-powered applications.
-
Connect to SAP HANA XS Advanced Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP HANA XS Advanced and the SQL Gateway to access SAP HANA XS Advanced from Google Apps Script.
-
How to Connect NetSuite Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live NetSuite data in real time using natural language.
-
Back Up Clockify to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Clockify data.
-
Build Salesforce-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Salesforce Data and create custom apps in Mendix.
-
A PostgreSQL Interface for Adobe Commerce Data using the CData ODBC Driver
Use the SQL Gateway and Adobe Commerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live OData Services in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to OData from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to ShipStation Data in CloverDX (formerly CloverETL)
Transfer ShipStation using the visual workflow in the CloverDX data integration tool.
-
How to Access RSS Feeds Using Entity Framework
This article shows how to access RSS Feeds using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Manus AI to Talk to Your Microsoft Teams 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 Microsoft Teams.
-
ETL JDBC-ODBC Bridge in Oracle Data Integrator
This article shows how to transfer JDBC-ODBC Bridge into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for Gong in MicroStrategy Web
Connect to Gong in MicroStrategy Web using the CData Software JDBC Driver for Gong.
-
Build a Simple VCL Application for Everhour Data
How to build a simple VCL Application to view Everhour in RAD Studio using the CData ODBC Driver for Everhour.
-
Integrating Gumloop with Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Veeva Vault & Vault CRM within automated workflows.
-
DataBind Controls to ConvertKit Data in Delphi
DataBind to ConvertKit in Delphi with standard data access components and controls.
-
Build MySQL-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MySQL Data from Zoho Analytics and import live MySQL.
-
Connect to Chargebee Data in DBeaver
Use the CData ODBC Driver to connect to Chargebee in DBeaver.
-
Create SSAS Tabular Models from Google Translate Data
How to build a SQL Server Analysis Service Tabular Model from Google Translate using CData drivers.
-
Build Semantic Layer Views for Contentful Data in APOS Live Data Gateway
Use the CData Connector for Contentful in APOS Live Data Gateway to build Semantic Layer Views for Contentful.
-
Analyze Live Outreach.io Data in SAS Viya
Use CData Connect AI to connect to Outreach.io from SAS Viya and deploy self-service analytics using live Outreach.io.
-
Easily Integrate SAS xpt Data in Lazarus Pascal IDE
Learn how to easily integrate live SAS XPORT in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Salesloft Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesloft and the Script function in FileMaker Pro to connect to Salesloft and work with Salesloft in your FileMaker application.
-
Use the CData ODBC Driver for HubDB in Microsoft Power Query
You can use the CData HubDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HubDB into Microsoft Power Query.
-
Access Live Zuora Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zuora from your Excel spreadsheets.
-
Integrate LibreChat with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Box from within the chat interface.
-
A PostgreSQL Interface for SparkPost Data (MySQL Remoting via JDBC)
Use the Remoting features of the SparkPost JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy Web
Connect to Workday in MicroStrategy Web using the CData Software JDBC Driver for Workday.
-
Build a Simple VCL Application for Google Sheets Data
How to build a simple VCL Application to view Google Sheets in RAD Studio using the CData ODBC Driver for Google Sheets.
-
Create SageHR Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SageHR from PowerBI.com to create Power BI Dataflows with real-time data.
-
Design BIRT Reports on Mailjet Data
Provide current Mailjet to your embedded analytics.
-
Integrating GitHub Copilot CLI with Humanity 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 Wistia Data in Aqua Data Studio
Access Wistia from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Seamlessly Import Klaviyo Data into IBM SPSS Modeler
Integrate Klaviyo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Sybase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sybase to connect to Sybase and execute queries in PowerBuilder.
-
Integrating Cursor CLI with Facebook 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.
-
Create Xero-Connected Dashboards in Grafana
Connect to Xero Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Xero Accounting.
-
Publish Accelo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Accelo.
-
Visualize Live Redis Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Redis into custom reports in Power BI.
-
DataBind Controls to Clari Data in C++Builder
DataBind to Clari in C++Builder with standard components and controls.
-
Query EmailOctopus Data in ColdFusion
Write standard ColdFusion data access code to connect to EmailOctopus.
-
Use the CData Software JDBC Driver for Webex in MicroStrategy Web
Connect to Webex in MicroStrategy Web using the CData Software JDBC Driver for Webex.
-
Build a PostgreSQL Interface for HelloSign Data using the CData JDBC Driver
Use the Remoting features of the HelloSign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Goose with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live MailChimp from within the local AI agent.
-
Connect to Google Translate Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Translate in the Denodo Virtual DataPort Administrator.
-
Integrating Antigravity CLI with Amazon S3 via CData CLI
Connect Amazon S3 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Power BI Connector for Sybase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sybase.
-
Integrate Samanage Data in the Pentaho Report Designer
Publish reports based on Samanage in the Pentaho BI tool.
-
Replicate Sugar CRM Data to Multiple Databases
Replicate Sugar CRM to disparate databases with a point-and-click configuration.
-
Integrate SAP ByDesign with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP ByDesign with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Business ByDesign.
-
Connect to Twitter Ads Data in RazorSQL
Connect to Twitter Ads from wizards and query Twitter Ads from the GUI in the RazorSQL database management tool.
-
Access Live ConstantContact Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ConstantContact in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Use a Microsoft Access Database to Update DB2 Data in Real Time
Update DB2 data by creating a linked table in Microsoft Access with the CData DB2 ODBC Driver.
-
How to publish and share Elorus Data dashboards with Tableau Server
The CData ODBC driver for Elorus enables you integrate Elorus into Tableau dashboards.
-
Connecting GenSpark with MarkLogic Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MarkLogic without any replication or custom integration required.
-
Integrate PayPal Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to PayPal and integrate live PayPal into your Power Automate tasks.
-
Integrate with Mailjet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mailjet to a JSON file on disk.
-
Eloqua: HTTP 400 Too Many Campaigns to Run the Report
In this entry you will find the resolution for the Oracle Eloqua API "too many campaigns to run the report" error.
-
Getting Started with the CData ADO.NET Provider for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Service Cloud.
-
Connect to Google Directory Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Directory from Crystal Reports.
-
Automated Continuous Presto Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Presto replication to Amazon S3.
-
Getting Started with the CData ODBC Driver for AgileCRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for AgileCRM.
-
Access Live Couchbase Data in TIBCO Data Virtualization
Use the Couchbase Tibco DV Adapter to create a Couchbase data source in TIBCO Data Virtualization Studio and gain access to live Couchbase from your TDV Server.
-
Access Hubstaff Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Hubstaff.
-
Connect to Auth0 in SpagoBI
Create reports featuring live Auth0 in SpagoBI Studio. Host Auth0 reports on SpagoBI Server.
-
How to Access Live Twitter Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Twitter Ads enables you to integrate Twitter Ads into workflows built using Microsoft Power Automate Desktop.
-
Query Zuora Data in ColdFusion
Write standard ColdFusion data access code to connect to Zuora.
-
Replicate Multiple Google Sheets Accounts via the CData Sync CLI
Replicate multiple Google Sheets accounts to one or many databases.
-
Integrating LangChain with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on DocuSign within automated workflows.
-
Use Biml to Build SSIS Tasks to Replicate Beeminder Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Beeminder to SQL Server.
-
Write a Simple Go Application to work with BigCommerce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to BigCommerce.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for EnterpriseDB
Provide connectivity to EnterpriseDB through an SAP BusinessObjects universe.
-
Visualize ServiceNow 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 ServiceNow into TIBCO Spotfire.
-
Create Power BI Reports on Real-Time Azure DevOps Data
Use the CData ODBC Driver for Azure DevOps to visualize Azure DevOps in Power BI Desktop.
-
Connect Zoho CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Query Live IBM Informix Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live IBM Informix data in natural language using Python.
-
How to create Oracle Financials Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Financials Cloud in MySQL .
-
Migrating data from Mailjet to Databricks using CData SSIS Components.
Easily push Mailjet to Databricks using the CData SSIS Tasks for Mailjet and Databricks.
-
Object-Relational Mapping (ORM) with Beeminder 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 Beeminder into a Java-based ORM framework, Hibernate.
-
Connect to Microsoft Exchange Data in HULFT Integrate
Connect to Microsoft Exchange as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Connect AI Python SDK for Amazon DynamoDB
Install the CData Connect AI Python SDK to read and write live Amazon DynamoDB with standard DB-API 2.0 Python code.
-
Back Up FreshBooks to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with FreshBooks data.
-
Connect to ZohoDesk Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoDesk from PowerBuilder using the ZohoDesk JDBC Driver.
-
Getting Started with the CData Power BI Connector for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure Data Catalog.
-
Build a Singer.io Tap for Office 365 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Office 365 data using
-
How to load Keap data into Elasticsearch via Logstash
Introducing a simple method to load Keap data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect and Query Live Oracle Sales Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Sales into Databricks
-
Connect to Jira Assets Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Jira Assets.
-
Replicate Multiple Oracle HCM Cloud Accounts via the CData Sync CLI
Replicate multiple Oracle HCM Cloud accounts to one or many databases.
-
LINQ to Cohere 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 Cohere Data Provider.
-
Automated Continuous Paymo Replication to MySQL
Use CData Sync for automated, continuous, customizable Paymo replication to MySQL.
-
Work with Live Sage Intacct Data in Power Query
Use CData Connect AI to connect to Sage Intacct and work with live Sage Intacct in Microsoft Power Query.
-
Integrating Databricks Data in Talend Cloud Data Management Platform
Connect Databricks Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Databricks.
-
Use Dash to Build Web Apps on Lakebase Data via CData Connect AI
Build interactive Dash web apps on live Lakebase using pandas and the CData Connect AI Python SDK.
-
Integrating LangGraph with Twitter Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Twitter Ads within automated workflows.
-
Object-Relational Mapping (ORM) with Facebook 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 Facebook into a Java-based ORM framework, Hibernate.
-
Work with Salesforce CRM Analytics Data in FoxPro
Load Salesforce CRM Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Creating SAS Data Sets-Connected Applications in Unqork
You can use CData Connect AI to feed SAS Data Sets to Unqork and build custom business apps.
-
How to Build an ETL App for SAP Business Warehouse Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Business Warehouse in Python with petl.