CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Power BI Connector for Datadog
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automate Superchat Data Replication to Couchbase
Use CData Sync to Customize and automate Superchat data replication to Couchbase.
-
How to work with PolarTeamPro Data in Apache Spark using SQL
Access and process PolarTeamPro Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for Pinecone
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pinecone.
-
Access Live Sage 200 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 Sage 200 data through MCP integration.
-
DataBind Email Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Email with the DevExpress Windows Forms and Web controls to provide Email data to a chart.
-
Build CockroachDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for CockroachDB Data and create custom apps in Bubble.
-
How to work with Sendwithus Data in Apache Spark using SQL
Access and process Sendwithus Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Shortcut Data Replication to Azure Data Lake
Use CData Sync to customize and automate Shortcut data replication to Azure Data Lake.
-
ZohoMarketingHub Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZohoMarketingHub facts in real time.
-
Build AI/ML Models with Live Samanage Data using Dataiku
Connect Samanage Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Shopify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Shopify replication to PostgreSQL.
-
How to Connect to Authorize.Net Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Authorize.Net data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Live MongoDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MongoDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MongoDB data.
-
Integrating GitHub Copilot with Aircall 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 Elorus Data from PowerBuilder via ADO.NET
This article demonstrates how to access Elorus data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to create Azure Synapse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Synapse data in MySQL .
-
How to Connect to Redshift Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Redshift data. Leverage the pyodbc module for ODBC in Python.
-
Access iContact Data from MySQL in Amazon QuickSight
Connect to iContact and build visualizations of iContact data using a MySQL Connection in Amazon QuickSight.
-
Publish HDFS-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live HDFS data.
-
Access Impala 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 Impala data.
-
Analyze Amazon S3 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon S3 data in Microsoft R Open.
-
Connect to Sybase IQ Data in RazorSQL
Connect to Sybase IQ from wizards and query Sybase IQ data from the GUI in the RazorSQL database management tool.
-
Build Semantic Layer Views for iContact Data in APOS Live Data Gateway
Use the CData Connector for iContact in APOS Live Data Gateway to build Semantic Layer Views for iContact data.
-
Automate Teamgate Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Teamgate data from PowerShell? This article demonstrates how to utilize the Teamgate Cmdlets for tasks like connecting to Teamgate data, automating operations, downloading data, and more.
-
Connect to Dropbox Data in JRuby
Create a simple JRuby app with access to live Dropbox data.
-
Connect to Salesforce Data 360 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Salesforce Data 360 data from Appeon PowerBuilder using the CData ADO.NET Provider for Salesforce Data 360.
-
Analyze Aircall Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Aircall data in Microsoft R Open.
-
Access Live Pushbullet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pushbullet data into the statistical analysis tools available in SAS JMP. This article shows how to use Pushbullet data in the Graph Builder and Query Builder.
-
Model Oracle SCM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle SCM, enabling the direct import of real-time Oracle SCM data.
-
Access Pipeliner CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pipeliner CRM data from your Oracle system.
-
Connect to PostgreSQL Data from a Connection Pool in Jetty
The PostgreSQL JDBC Driver supports connection pooling: This article shows how to connect faster to PostgreSQL data from Web apps in Jetty.
-
Integrate Stripe with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Stripe with External Services.
-
Connect to HubSpot Data in Claris FileMaker Pro
Use the CData ODBC Driver for HubSpot in FileMaker Pro to connect to HubSpot and work with HubSpot data in your FileMaker applications.
-
Connect MailerLite to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MailerLite data using the CData Python MCP Server.
-
Write a Simple Go Application to work with Chargebee Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Chargebee data.
-
Automated Continuous Shopify Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Shopify replication to Google BigQuery.
-
Analyze ZohoPeople Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoPeople from Power Pivot. You will use the Table Import Wizard to load ZohoPeople data. You can visually build the import query or use any SQL supported by the driver.
-
Access TaxJar Data from MySQL in Amazon QuickSight
Connect to TaxJar and build visualizations of TaxJar data using a MySQL Connection in Amazon QuickSight.
-
Integrate OpenCode with Live BigCommerce Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live BigCommerce data from within your AI coding agent.
-
Automate Teamgate Data Replication to Couchbase
Use CData Sync to Customize and automate Teamgate data replication to Couchbase.
-
Connect to Office 365 Data from HeidiSQL
Use CData Connect AI to connect to and query live Office 365 data from HeidiSQL.
-
Connect to xBase Data from a Connection Pool in JBoss
Integrate xBase data into Java servlets: Use the Management Console in JBoss to install the xBase JDBC Driver.
-
Build AI Agents with Confluence 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 Confluence data through CData Connect AI.
-
Integrate Real-Time Access to Slack in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Slack data in real time.
-
Connect to Missive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Missive data using standard SQL.
-
Use Grok to Talk to Your RSS Feeds 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 RSS feeds for you.
-
Automated Continuous Twitter Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Databricks.
-
Create Dashboards and Visualize Live Wave Financial Data in Geckoboard
Use CData Connect AI to connect to live Wave Financial data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
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 data.
-
Create Informatica Mappings From/To an ODBC Data Source for Dotmailer
Create an ODBC connection to Dotmailer in Informatica and browse and transfer Dotmailer data.
-
Build Oracle Sales-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Sales data 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 data in the Pentaho Data Integration tool.
-
Automated Continuous NASA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable NASA replication to Google BigQuery.
-
Connect to Testmonitor Data in RazorSQL
Connect to Testmonitor from wizards and query Testmonitor data 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 data in Microsoft R Open.
-
Build SAP Fieldglass Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Fieldglass data and build visualizations in Tableau Cloud.
-
How to Query Shortcut Data in MySQL Workbench
Execute MySQL queries against live Shortcut data 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 Cloudant data in Power Apps.
-
Connect to FHIR Data in RapidMiner
Integrate FHIR data with standard components and data source configuration wizards in RapidMiner Studio.
-
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 data 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 data 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 Phoenix data to your embedded analytics.
-
Connect to AfterShip from a Connection Pool in WebLogic
Use the CData JDBC Driver for AfterShip to connect to AfterShip data from Web applications running on WebLogic.
-
Automated Continuous Brex Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Brex replication to Apache Cassandra.
-
Integrating OpenCode 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 data 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 data 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 data.
-
Publish Crystal Reports on ZohoMarketingHub Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoMarketingHub data.
-
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 data 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 results to a JSON file on disk.
-
Connect to Attio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Attio data 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 data 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 data 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 data 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.
-
Interact with Live AfterShip Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live AfterShip data.
-
Build Data Flows from Foursquare to SQL Server using SSIS
Easily back up Foursquare data 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.
-
Integrating Dataiku with Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Optimizely data.
-
Use the CData Software JDBC Driver for Jodoo in MicroStrategy
Connect to Jodoo data 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 CouchDB data for you.
-
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 Excel Online data 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 data 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 Cloudant data.
-
Use the CData Software JDBC Driver for Jira in MicroStrategy
Connect to Jira data in MicroStrategy Developer using the CData Software JDBC Driver for Jira.
-
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 data.
-
Connect to Odoo Data in Ruby
Connect to Odoo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Cursor 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.