CData Software - Knowledge Base
Recent Articles
-
Integrate Theia IDE with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live API data from within the development environment.
-
How to Connect to Live Google Ads 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 Google Ads data for you.
-
Use Dash to Build to Web Apps on iContact Data
Create Python applications that use pandas and Dash to build iContact-connected web apps.
-
How to connect Amazon QuickSight to Jira Assets Data
Create a connection to Jira Assets data in CData Connect AI and insert Jira Assets data into Amazon QuickSight SPICE to build interactive dashboards.
-
Load Freshservice Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Freshservice data to a database.
-
How to connect to Teamwork Data with Squirrel SQL client
Connect to Teamwork data and execute queries in the Squirrel SQL Client.
-
Build Semantic Layer Views for Bullhorn CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Bullhorn CRM data.
-
Visualize Act-On Data in TIBCO Spotfire through OData
Integrate Act-On data into dashboards in TIBCO Spotfire.
-
How to connect to Spotify Data with Squirrel SQL client
Connect to Spotify data and execute queries in the Squirrel SQL Client.
-
Build Semantic Layer Views for AlloyDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for AlloyDB data.
-
Build Spotify-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Spotify data.
-
Create Power BI Reports on Real-Time Attio Data
Use the CData ODBC Driver for Attio to visualize Attio data in Power BI Desktop.
-
Automated Continuous Placid Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Placid replication to Apache Kafka.
-
Build LinkedIn-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LinkedIn data.
-
Building Dynamic Web Pages with Avro Data Using AngularJS
Create single-page applications with live connectivity to Avro using the CData API Server.
-
Connect to Cloudant Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Cloudant data in Airbyte.
-
Excel Spreadsheet Automation on SpaceX Data with the QUERY Formula
Pull data from SpaceX, automate spreadsheets, and more with the QUERY formula.
-
Connect to Contentful Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Contentful as an External Source in Dremio.
-
Extract, Transform, and Load Salesforce Data in Informatica PowerCenter
Create a simple Workflow for Salesforce data in Informatica PowerCenter.
-
Automated Continuous Calendly Replication to Oracle
Use CData Sync for automated, continuous, customizable Calendly replication to Oracle.
-
Connect to Workday Data from Crystal Reports
Use CData Connect AI to connect to and report on live Workday data from Crystal Reports.
-
Create HDFS-Connected Dashboards in Grafana
Connect to HDFS Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to HDFS data.
-
Connect to MySQL Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MySQL data from Filemaker Pro on Mac.
-
Connect to Hive Data in DBeaver
Use the CData ODBC Driver to connect to Hive data in DBeaver.
-
How to connect PolyBase to Recurly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Recurly data.
-
Access Live Microsoft Dataverse Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Dataverse data from your Google Sheets.
-
How to Query Exa Data in MySQL Workbench
Execute MySQL queries against live Exa data from MySQL Workbench.
-
How to work with PDFMonkey Data in Apache Spark using SQL
Access and process PDFMonkey Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous WooCommerce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable WooCommerce replication to IBM DB2.
-
Work with Freshteam Data in FoxPro
Load Freshteam data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Semantic Layer Views for Salesforce Data 360 Data in APOS Live Data Gateway
Use the CData Connector for Salesforce Data 360 in APOS Live Data Gateway to build Semantic Layer Views for Salesforce Data 360 data.
-
Connect to Invoiced from a Connection Pool in WebLogic
Use the CData JDBC Driver for Invoiced to connect to Invoiced data from Web applications running on WebLogic.
-
Build a Simple VCL Application for Landbot Data
How to build a simple VCL Application to view Landbot data in RAD Studio using the CData ODBC Driver for Landbot.
-
Import Discord Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Discord Data and provide access to live Discord data for custom reports in the Power BI Service.
-
A PostgreSQL Interface for ZohoSubscriptions Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZohoSubscriptions JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Codex with PostgreSQL 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 Charts with LinkedIn Data in Clear Analytics
Create dynamic charts and perform analytics based on LinkedIn data in Clear Analytics.
-
Use the CData Software ODBC Driver for Quickbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Quickbase data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Quickbase.
-
Build SAP SuccessFactors LMS-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SAP SuccessFactors LMS data without replication.
-
Create Dynamic Short.io Grids Using the Infragistics XamDataGrid
Learn how you can connect Short.io to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live SurveyMonkey Data in the Power BI Service
Use CData Connect AI to connect to live SurveyMonkey data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Operational Reporting on Mixpanel Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mixpanel data.
-
Use Claude to Talk to Your HubDB 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 HubDB data for you.
-
Integrate with ZohoDesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoDesk data to a JSON file on disk.
-
Getting Started with the CData SSIS Components for OData
Complete guide to installing, licensing, and connecting with the CData SSIS Components for OData.
-
A PostgreSQL Interface for BigCommerce Data (MySQL Remoting via JDBC)
Use the Remoting features of the BigCommerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Aweber Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Aweber data with the CData JDBC Driver for Aweber.
-
Explore Geographical Relationships in Anaplan Data with Power Map
Create data visualizations with Anaplan data in Power Map.
-
Integrating Claude Code CLI with ZarMoney 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.
-
Gumroad Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gumroad facts in real time.
-
Integrate Marketo Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Marketo data and integrate live Marketo data into your Power Automate tasks.
-
Integrate with Google Sheets Data in JReport Designer
Create charts and reports based on Google Sheets data in JReport Designer.
-
Automated Continuous Perigon Replication to Vertica
Use CData Sync for automated, continuous, customizable Perigon replication to Vertica.
-
Use Claude to Talk to Your Basecamp 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 Basecamp data for you.
-
Using the CData Software ODBC Driver for Google Campaign Manager 360 in PyCharm
Connect to Google Campaign Manager 360 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Automate Oracle HCM Cloud Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle HCM Cloud data replication to Azure Synapse.
-
Build a Singer.io Tap for Amazon S3 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amazon S3 data using the CData Python Connector.
-
Create Dashboards and Visualize Live Oracle Sales Data in Geckoboard
Use CData Connect AI to connect to live Oracle Sales data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to load FTP data into Elasticsearch via Logstash
Introducing a simple method to load FTP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to ClickTime Data in RazorSQL
Connect to ClickTime from wizards and query ClickTime data from the GUI in the RazorSQL database management tool.
-
Connect to MessageBird Data from a Connection Pool in JBoss
Integrate MessageBird data into Java servlets: Use the Management Console in JBoss to install the MessageBird JDBC Driver.
-
How to publish and share HelloSign Data dashboards with Tableau Server
The CData ODBC driver for HelloSign enables you integrate HelloSign data into Tableau dashboards.
-
Getting Started with the CData Power BI Connector for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Ariba Source.
-
Use Azure AI Foundry to Talk to Your Google Ads 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 Google Ads data for you.
-
Connecting Mastra with ServiceDesk Plus 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 ServiceDesk Plus data, no replication required.
-
Automated DB2 for i Data Replication to Teradata
Use CData Sync to Customize and automate DB2 for i data replication to Teradata.
-
How to Use a Microsoft Access Database to Update Snowflake Data in Real Time
Update Snowflake data by creating a linked table in Microsoft Access with the CData Snowflake ODBC Driver.
-
Databricks: Option to Disable SELECT version() Execution
Learn how to disable the execution of SELECT version() in Databricks to improve performance and avoid unnecessary queries.
-
How to Access Live Square Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Square enables you to integrate Square data into workflows built using Microsoft Power Automate Desktop.
-
Access Basecamp 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 Basecamp data.
-
Write a Simple Go Application to work with YouTube Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to YouTube Analytics data.
-
ETL Egnyte in Oracle Data Integrator
This article shows how to transfer Egnyte data into a data warehouse using Oracle Data Integrator.
-
Migrating data from Azure Data Lake Storage to Google BigQuery using CData SSIS Components.
Easily push Azure Data Lake Storage data to Google BigQuery using the CData SSIS Tasks for Azure Data Lake Storage and Google BigQuery.
-
Load SharePoint Excel Services Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SharePoint Excel Services data to a database.
-
Build Quickbase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Quickbase data.
-
Build MVC Applications with Connectivity to Epicor Kinetic Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Epicor Kinetic from an ASP.NET MVC application.
-
Create Dynamic Sage 200 Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage 200 to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Clari Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Clari replication to PostgreSQL.
-
Integrating OpenCode with OData services 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 the CData Software JDBC Driver for Postmark in MicroStrategy
Connect to Postmark data in MicroStrategy Developer using the CData Software JDBC Driver for Postmark.
-
Use Microsoft Copilot Studio to talk to your VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your VWO data for you.
-
Use Databricks Agent Bricks to Talk to Your NetSuite SuiteAnalytics Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your NetSuite SuiteAnalytics data for you.
-
How to Easily Query FTP Data in OpenOffice Base
Connect to FTP data in OpenOffice Base using the CData ODBC Driver for FTP and generate reports with live data insights.
-
How to Access Live Office 365 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Office 365 enables you to integrate Office 365 data into workflows built using Microsoft Power Automate Desktop.
-
Automate Confluence Data Replication to SAP HANA
Use CData Sync to customize and automate Confluence data replication to SAP HANA.
-
Connect to Adobe Experience Manager Data in NetBeans
Connect to Adobe Experience Manager data in NetBeans with the data source configuration wizard.
-
Visualize SAP Ariba Procurement Data in TIBCO Spotfire through ADO.NET
Integrate SAP Ariba Procurement data into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Impala in MicroStrategy Desktop
Connect to Impala data in MicroStrategy Desktop using the CData Software JDBC Driver for Impala.
-
Visualize MYOB AccountRight Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MYOB AccountRight data.
-
Getting Started with the CData Python Connector for Missive
Learn to install and license the CData Python Connector and configure a connection to live Missive data.
-
Query Box Data as a SQL Server Database in Node.js
Execute SQL Server queries against Box data from Node.js.
-
Build BigQuery Visualizations in Tableau Desktop
Use CData Connect AI to connect to live BigQuery data and build visualizations in Tableau.
-
Use the CData Software ODBC Driver for Typeform in MicroStrategy Desktop
Connect to Typeform data in MicroStrategy Desktop using the CData Software ODBC Driver for Typeform.
-
Use Databricks Agent Bricks to Talk to Your Raisers Edge NXT Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Raisers Edge NXT data for you.
-
Use Biml to Build SSIS Tasks to Replicate Twitter Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Twitter Ads data to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dotmailer
Provide connectivity to Dotmailer data through an SAP BusinessObjects universe.
-
Natively Connect to WordPress Data in PHP
The CData ODBC driver for WordPress enables you to create PHP applications with connectivity to WordPress data. Leverage the native support for ODBC in PHP.
-
Connect to Adobe Target Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Adobe Target as an External Source in Dremio.
-
Getting Started with the CData Connect AI Python SDK for ConstantContact
Install the CData Connect AI Python SDK to read live ConstantContact data with standard DB-API 2.0 Python code.
-
Create Reports from Oracle HCM Cloud Data in Looker Studio
Use CData Connect AI to gain access to live Oracle HCM Cloud data and create custom reports in Looker Studio.