CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Snapchat Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Azure SQL Database.
-
How to Connect to & Open NASA Data in Microsoft Excel
This article uses the CData ODBC driver for NASA to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Teamgate Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teamgate replication to Google Cloud SQL.
-
Automate Access Data Replication to SAP HANA
Use CData Sync to customize and automate Access data replication to SAP HANA.
-
Consume Twitter Ads OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Twitter Ads feeds that reflect any changes in SAP Lumira.
-
Integrating GitHub Copilot with Unbounce 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 Slack Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Slack data in Airbyte.
-
Build a Simple VCL Application for SAP Concur Data
How to build a simple VCL Application to view SAP Concur data in RAD Studio using the CData ODBC Driver for SAP Concur.
-
Integrating Claude Code CLI with SAS xpt 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.
-
Access Live Avro 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 Avro data through MCP integration.
-
Integrate OpenCode with Live SAP SuccessFactors Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP SuccessFactors data from within your AI coding agent.
-
Build Visualizations of Timely Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Timely data in Birst.
-
How to Access Salesforce Marketing Data Using Entity Framework
This article shows how to access Salesforce Marketing data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Working with HBase Data in LINQPad
Execute LINQ queries to HBase data in LINQPad.
-
Automate Tanda Data Replication to SAP HANA
Use CData Sync to customize and automate Tanda data replication to SAP HANA.
-
Work with Live Outreach.io Data in Power Query
Use CData Connect AI to connect to Outreach.io data and work with live Outreach.io data in Microsoft Power Query.
-
Bind Live BigCommerce Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live BigCommerce data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build AI Agents with Trello Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Trello data through CData Connect AI.
-
Access Live Float Data in Coginiti Pro
Connect to and query live Float data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Jira Data in Tableau
The CData ODBC driver for Jira enables you integrate Jira data into Tableau dashboards.
-
Integrating LangChain with SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Business Warehouse data within automated workflows.
-
Interact with Live Dynamics 365 Business Central Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Dynamics 365 Business Central data.
-
Bind Live Xero Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Xero data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Connect DBeaver to SAP Business Warehouse via a JDBC Driver
Manage SAP Business Warehouse data with visual tools in DBeaver like the query browser.
-
Access Live Active Directory Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Active Directory data through MCP integration.
-
Build Charts with Gorgias Data in Clear Analytics
Create dynamic charts and perform analytics based on Gorgias data in Clear Analytics.
-
Connect to CloudConvert Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CloudConvert as an External Source in Dremio.
-
Stream ConstantContact Data into Apache Kafka Topics
Access and stream ConstantContact data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Zoom Data in DBeaver
Use the CData ODBC Driver to connect to Zoom data in DBeaver.
-
Connect to Azure DevOps Data from a Connection Pool in Jetty
The Azure DevOps JDBC Driver supports connection pooling: This article shows how to connect faster to Azure DevOps data from Web apps in Jetty.
-
Connect to Real-Time Grafana Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Grafana data in Power Apps.
-
Build Dashboards with Aircall Data in DBxtra
Create dynamic dashboards and perform analytics based on Aircall data in DBxtra.
-
Build Apps with Live Autopilot Data Using the Low-Code Development Platform of Mendix
Connect Autopilot data with Mendix to build apps using the CData API Driver for JDBC.
-
How to create Teamwork federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Teamwork data in MySQL .
-
Moving Data from SAP Concur to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Concur data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Scrapfly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Scrapfly replication to Snowflake.
-
Automate Oracle Eloqua Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Eloqua data replication to Couchbase.
-
Build AI Agents with JSON Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live JSON services through CData Connect AI.
-
How to connect to Aha! Data from Spring Boot
Connect to Aha! in a Spring Boot Application using the CData API Driver for JDBC
-
Visualize SendGrid Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SendGrid data.
-
Connect to PolarTeamPro Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for PolarTeamPro to connect to PolarTeamPro data and execute queries in PowerBuilder.
-
Access SAP 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 SAP data.
-
Getting Started with the CData ADO.NET Provider for Strava
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Oracle Data in CloverDX (formerly CloverETL)
Transfer Oracle data using the visual workflow in the CloverDX data integration tool.
-
How to work with Telegram Data in Apache Spark using SQL
Access and process Telegram Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live QuickBooks Time 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 QuickBooks Time data for you.
-
How to Connect SAP SuccessFactors 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 SAP SuccessFactors data in real time using natural language.
-
Access Freshdesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Freshdesk data from HeidiSQL.
-
Visualize Codat Data in TIBCO Spotfire through ADO.NET
Integrate Codat data into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot with ZohoInvoice 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 the CData Software JDBC Driver for Zoho Inventory in MicroStrategy
Connect to Zoho Inventory data in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Inventory.
-
Connect to Exact Online Data from AWS Glue
Use CData Connect AI to gain access to live Exact Online data from your AWS Glue jobs.
-
Connect to and Query Keap Data in QlikView over ODBC
Create data visualizations with Keap data in QlikView.
-
Build Charts with Shopify Data in Clear Analytics
Create dynamic charts and perform analytics based on Shopify data in Clear Analytics.
-
Automate SparkPost Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SparkPost data from PowerShell? This article demonstrates how to utilize the SparkPost Cmdlets for tasks like connecting to SparkPost data, automating operations, downloading data, and more.
-
Using the CData Software ODBC Driver for Elasticsearch in PyCharm
Connect to Elasticsearch as an ODBC data source in PyCharm using the CData Software ODBC Driver for Elasticsearch.
-
Access FormSite Data from MySQL in PHP
Connect to FormSite through the standard MySQL libraries in PHP.
-
Connect to and Visualize Live Neo4J Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Neo4J data.
-
Getting Started with the CData Tableau Connector for CouchDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for CouchDB.
-
Build Dashboards with Pushbullet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pushbullet data in Dundas BI.
-
Connect to Adobe Experience Manager Data from a Connection Pool in Jetty
The Adobe Experience Manager JDBC Driver supports connection pooling: This article shows how to connect faster to Adobe Experience Manager data from Web apps in Jetty.
-
Connect to and Visualize Live IBM Informix Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live IBM Informix data.
-
Enable the Aweber JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Aweber data.
-
Use Azure AI Foundry to Talk to Your Monday.com 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 Monday.com data for you.
-
Use Biml to Build SSIS Tasks to Replicate Redshift Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Redshift data to SQL Server.
-
Build Dashboards with FHIR Data in DBxtra
Create dynamic dashboards and perform analytics based on FHIR data in DBxtra.
-
Build MVC Applications with Connectivity to BigCommerce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigCommerce from an ASP.NET MVC application.
-
Access AfterShip Data from MySQL in PHP
Connect to AfterShip through the standard MySQL libraries in PHP.
-
Publish Reports with Bannerbear Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bannerbear data.
-
Integrate with LeadDesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LeadDesk data to a JSON file on disk.
-
Migrating data from Clio to Google BigQuery using CData SSIS Components.
Easily push Clio data to Google BigQuery using the CData SSIS Tasks for Clio and Google BigQuery.
-
How to Easily Query Zoho Books Data in OpenOffice Base
Connect to Zoho Books data in OpenOffice Base using the CData ODBC Driver for Zoho Books and generate reports with live data insights.
-
Visualize eBay Analytics Data in Tableau
The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics data into Tableau dashboards.
-
How to Connect the Power BI Service to MYOB AccountRight: Complete Guide
Connect to the CData Software Power BI Connector for MYOB AccountRight from PowerBI.com to provide real-time MYOB AccountRight data across the organization.
-
Connect to Slack Data in HULFT Integrate
Connect to Slack as a JDBC data source in HULFT Integrate
-
Use Azure AI Foundry to Talk to Your Azure DevOps 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 Azure DevOps data for you.
-
Integrate Gumroad with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Gumroad with External Services.
-
Build Dashboards with Raisers Edge NXT Data in Dundas BI
Create dynamic dashboards and perform analytics based on Raisers Edge NXT data in Dundas BI.
-
Connect to Freshsales in SpagoBI
Create reports featuring live Freshsales data in SpagoBI Studio. Host Freshsales reports on SpagoBI Server.
-
Process & Analyze YouTube Analytics Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live YouTube Analytics Data.
-
Create Apps from Google Drive Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Drive Data and build apps from live Google Drive data in Qlik Sense Cloud.
-
A PostgreSQL Interface for Hive Data using the CData ODBC Driver
Use the SQL Gateway and Hive ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to import PDFMonkey Data into Apache Solr
Use the CData Software JDBC Driver for PDFMonkey in Data Import Handler and create an automated import of PDFMonkey data to Apache Solr Enterprise Search platform.
-
Build Pipelines with Live SAP BusinessObjects BI Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP BusinessObjects BI from Google Cloud Data Fusion, enabling the integration of live SAP BusinessObjects BI data into the building and management of effective data pipelines.
-
Build a Singer.io Tap for ZohoInvoice With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZohoInvoice data using the CData Python Connector.
-
Integrate with SAP Fieldglass Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Fieldglass data in SnapLogic.
-
Access Live Zendesk Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zendesk data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect/Disconnect the QuickBooks Online Products
In this entry you will learn to use the CData Excel Add-In for QuickBooks Online or the CData Sync Application for QuickBooks Online to connect to or disconnect from your QuickBooks Online data.
-
Build Oracle-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle data and build Oracle-connected web apps with Axios.
-
How to create MYOB AccountRight federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MYOB AccountRight data in MySQL .
-
Query Bitly Data in ColdFusion
Write standard ColdFusion data access code to connect to Bitly data.
-
Migrating data from Lakebase to Databricks using CData SSIS Components.
Easily push Lakebase data to Databricks using the CData SSIS Tasks for Lakebase and Databricks.
-
How to Work with Authorize.Net Data in ETL Validator JDBC
Connect to Authorize.Net from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Harvest Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Harvest replication to delimited files (CSV/TSV).
-
Connect to Real-Time Instagram Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Instagram and Dataflow to import and use Instagram data in Power Apps.
-
Integrating Gumloop with Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft OneDrive data within automated workflows.
-
Connecting Mastra with Wave Financial 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 Wave Financial data, no replication required.
-
Access Live MariaDB Data in Coginiti Pro
Connect to and query live MariaDB data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Google Contacts Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Contacts replication to IBM DB2.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigCommerce
Provide connectivity to BigCommerce data through an SAP BusinessObjects universe.