CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Twitter Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Databricks.
-
Build Discourse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Discourse.
-
Create Informatica Mappings From/To an ODBC Data Source for Dotmailer
Create an ODBC connection to Dotmailer in Informatica and browse and transfer Dotmailer.
-
Build Oracle Sales-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Sales and build Oracle Sales-connected web apps with Axios.
-
Integrate Oracle HCM Cloud Data in Pentaho Data Integration
Build ETL pipelines based on Oracle HCM Cloud in the Pentaho Data Integration tool.
-
Connect to Testmonitor Data in RazorSQL
Connect to Testmonitor from wizards and query Testmonitor from the GUI in the RazorSQL database management tool.
-
Consume Blackbaud FE NXT OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Blackbaud FE NXT feeds that reflect any changes in SAP Lumira.
-
Analyze Browserless Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Browserless in Microsoft R Open.
-
Build SAP Fieldglass Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Fieldglass and build visualizations in Tableau Cloud.
-
Extend Google Sheets with REST Data
Make calls to REST from Google Apps Script via the API Server.
-
How to Query Shortcut Data in MySQL Workbench
Execute MySQL queries against live Shortcut from MySQL Workbench.
-
Connect to Real-Time Cloudant Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Cloudant and Dataflow to import and use IBM Cloudant in Power Apps.
-
Connect to FHIR Data in RapidMiner
Integrate FHIR with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed JSON to Power BI dashboards. Simply drag and drop JSON into data visuals on the Power BI canvas.
-
Rapidly Develop SAP ByDesign-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 SAP ByDesign.
-
Creating MySQL-Connected Applications in Unqork
You can use CData Connect AI to feed MySQL to Unqork and build custom business apps.
-
How to Connect to & Open Facebook Ads Data in Microsoft Excel
This article uses the CData ODBC driver for Facebook Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Epicor Kinetic Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Amazon S3.
-
DataBind Controls to Cohere Data in Delphi
DataBind to Cohere in Delphi with standard data access components and controls.
-
Automated Continuous Shopify Replication to Oracle
Use CData Sync for automated, continuous, customizable Shopify replication to Oracle.
-
Design BIRT Reports on Phoenix Data
Provide current Apache Phoenix to your embedded analytics.
-
Connect to AfterShip from a Connection Pool in WebLogic
Use the CData JDBC Driver for AfterShip to connect to AfterShip from Web applications running on WebLogic.
-
Integrating OpenCode Terminal with WordPress 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.
-
Automated Continuous Oracle SCM Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle SCM replication to MySQL.
-
Connect to Rebilly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Rebilly using standard SQL.
-
Create a Data Access Object for Active Directory Data using JDBI
A brief overview of creating a SQL Object API for Active Directory in JDBI.
-
Automated Continuous Oracle Service Cloud Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Google BigQuery.
-
Visualize Live Todoist Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Todoist.
-
Publish Crystal Reports on ZohoMarketingHub Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoMarketingHub.
-
Getting Started with the CData Connect AI Python SDK for Zoho Projects
Install the CData Connect AI Python SDK to read and write live Zoho Projects with standard DB-API 2.0 Python code.
-
Integrate with Google Search Results using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Search to a JSON file on disk.
-
Connect to Attio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Attio from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Configure the CData JDBC Driver for Salesforce Marketing in a Connection Pool in Tomcat
Connect to Salesforce Marketing Cloud from a connection pool in Tomcat.
-
Build AI/ML Models with Live Teamwork Data using Dataiku
Connect Teamwork Data with Dataiku using the CData API Driver for JDBC.
-
Automate Bullhorn CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Bullhorn CRM replication to SAP HANA.
-
Create Datasets from xBase in Domo Workbench and Build Visualizations of xBase Data in Domo
Use the CData Software ODBC Driver for xBase to create datasets from xBase in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous NetSuite SuiteAnalytics Replication to SQL Server
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to SQL Server.
-
Build Data Flows from Foursquare to SQL Server using SSIS
Easily back up Foursquare to SQL Server using the SSIS components for Foursquare.
-
Automated Continuous YouTube Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Google BigQuery.
-
Build MVC Applications with Connectivity to Pingdom Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pingdom from an ASP.NET MVC application.
-
Use the CData Software JDBC Driver for Jodoo in MicroStrategy
Connect to Jodoo in MicroStrategy Developer using the CData Software JDBC Driver for Jodoo.
-
Use Grok to Talk to Your CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache CouchDB for you.
-
Access Live Kafka Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Kafka data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous PostgreSQL Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PostgreSQL replication to IBM DB2.
-
Integrate with Live Excel Online Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Excel Online from the MuleSoft Anypoint Platform to integrate live Microsoft Excel Online into custom reports and dashboards.
-
How to Build an ETL App for Google Sheets Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Sheets in Python with petl and the CData Connect AI Python SDK.
-
How to connect PolyBase to Cloudant
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Cloudant.
-
Use the CData Software JDBC Driver for Jira in MicroStrategy
Connect to Atlassian Jira in MicroStrategy Developer using the CData Software JDBC Driver for Jira.
-
Import Teradata Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Teradata. In this article, you will use the OData format to import Teradata into Microsoft Power Query.
-
How to connect PolyBase to AdRoll
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live AdRoll.
-
Connect to Odoo Data in Ruby
Connect to Odoo ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Cursor CLI with Coda 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.
-
Integrating GitHub Copilot CLI with PostgreSQL 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.
-
Access Live Azure Data Catalog Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Catalog data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Sendwithus Data in Pentaho Data Integration
Build ETL pipelines based on Sendwithus in the Pentaho Data Integration tool.
-
Object-Relational Mapping (ORM) with Yelp 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 Yelp into a Java-based ORM framework, Hibernate.
-
Integrating Claude Code CLI with Factorial 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.
-
Import and Visualize SAP BusinessObjects BI Data in Power View
Create data visualizations based on SAP BusinessObjects BI in Excel.
-
Use the CData Software JDBC Driver for Instantly in MicroStrategy Web
Connect to Instantly in MicroStrategy Web using the CData Software JDBC Driver for Instantly.
-
Automated Continuous ZohoExpense Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoExpense replication to IBM DB2.
-
Integrating Cursor CLI with Avalara AvaTax 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 Google Drive Data in HULFT Integrate
Connect to Google Drive as a JDBC data source in HULFT Integrate
-
Integrating Boomi Agentstudio with Salesforce Marketing Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Salesforce Marketing Cloud, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Airtable Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Airtable from HeidiSQL.
-
View Reports on Real-Time Dynamics 365 Business Central Data in Power BI Report Server
Use the CData ODBC Driver for Dynamics 365 Business Central to visualize Dynamics 365 Business Central in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Oracle HCM Cloud Data in CloverDX (formerly CloverETL)
Transfer Oracle HCM Cloud using the visual workflow in the CloverDX data integration tool.
-
How to Seamlessly Import Trello Data into IBM SPSS Modeler
Integrate Trello data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect and Visualize Live Smartsheet Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Smartsheet into the Databricks platform and create visualization dashboards with real-time Smartsheet.
-
Query, Visualize, and Share live IBM Cloud Object Storage Data in Redash
Use CData Connect AI to connect to live IBM Cloud Object Storage in Redash for querying, visualizing, and sharing.
-
Query SAP Netweaver Gateway Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Netweaver Gateway and perform CRUD operations on SAP Netweaver Gateway from Node.js.
-
Replicate Multiple SAS xpt Accounts via the CData Sync CLI
Replicate multiple SAS xpt accounts to one or many databases.
-
Analyze Simplesat Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Simplesat from Power Pivot. You will use the Table Import Wizard to load Simplesat. You can visually build the import query or use any SQL supported by the driver.
-
Use Databricks Agent Bricks to Talk to Your Trello Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Trello for you.
-
Build Automated Workflows with Live Monday.com Data in Workato
Use CData Connect AI to connect to live Monday.com and build automated workflows in Workato.
-
Access Live Google Analytics Data in AWS Lambda
Connect to live Google Analytics in AWS Lambda using the CData JDBC Driver.
-
Use Grok to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your MYOB AccountRight for you.
-
Migrating data from xBase to Google BigQuery using CData SSIS Components.
Easily push xBase to Google BigQuery using the CData SSIS Tasks for xBase and Google BigQuery.
-
Query Live HubSpot 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 HubSpot directly from the development environment.
-
Connect to RSS Feeds in Claris FileMaker Pro
Use the CData ODBC Driver for RSS in FileMaker Pro to connect to RSS and work with RSS Feeds in your FileMaker applications.
-
How to Build an ETL App for GraphQL Data in Python with CData
Create ETL applications and real-time data pipelines for GraphQL in Python with petl.
-
Connect to Miro Data in RazorSQL
Connect to Miro from wizards and query Miro from the GUI in the RazorSQL database management tool.
-
Access Live HBase 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 Apache HBase through MCP integration.
-
Replicate Apollo Data from PowerShell
Write a quick PowerShell script to query Apollo. Use connectivity to the live data to replicate Apollo to SQL Server.
-
Replicate Zoom Data to Multiple Databases via the CData Sync CLI
Replicate Zoom to disparate databases with a single configuration.
-
Build Voice Agents in ElevenLabs with access to Live MYOB AccountRight Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MYOB AccountRight.
-
Integrating Claude Code with BigQuery Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google BigQuery within assisted coding and automated development workflows.
-
Analyze GetResponse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze GetResponse with the CData JDBC Driver for GetResponse.
-
Working with ChargeOver Data in LINQPad
Execute LINQ queries to ChargeOver in LINQPad.
-
Prepare, Blend, and Analyze Delighted Data in Alteryx Designer (ODBC)
Build workflows to access live Delighted for self-service data analytics.
-
Build Presto-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Presto to explore live Presto Data in GitHub Copilot to assist with building Presto-powered applications.
-
How to Connect to Live Redis Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Redis for you.
-
Automated Continuous Microsoft Planner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Apache Cassandra.
-
Viewing Shortcut Data in RAD Studio Data Explorer
How to view Shortcut in RAD Studio Data Explorer using the CData ODBC Driver for Shortcut.
-
Integrate LibreChat with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live BigCommerce from within the chat interface.
-
Integrate SparkPost Data in Pentaho Data Integration
Build ETL pipelines based on SparkPost in the Pentaho Data Integration tool.
-
Model, Search, and Visualize Live Impala Data in ThoughtSpot
Use CData Connect AI to connect to live Apache Impala for modeling, searching, and visualizing.
-
Integrating Codex CLI with Azure Data Lake Storage 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.
-
Automated Continuous Egnyte Replication to MongoDB
Use CData Sync for automated, continuous, customizable Egnyte replication to MongoDB.
-
Query SAS xpt Data in ColdFusion
Write standard ColdFusion data access code to connect to SAS XPORT.
-
How to connect PolyBase to SAP ByDesign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Business ByDesign.