CData Software - Knowledge Base
Recent Articles
-
Replicate ZarMoney Data to Multiple Databases
Replicate ZarMoney data to disparate databases with a point-and-click configuration.
-
Connect and Query Live Salesforce Data 360 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesforce Data 360 data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData Software JDBC Driver for CampaignMonitor in MicroStrategy Desktop
Connect to CampaignMonitor data in MicroStrategy Desktop using the CData Software JDBC Driver for CampaignMonitor.
-
Build an OLAP Cube in SSAS from Dropbox Data
Establish a connection to Dropbox data data from SQL Server Analysis Services, and use the Dropbox Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Real-Time Authorize.Net Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Authorize.Net and Dataflow to import and use Authorize.Net data in Power Apps.
-
Automated Continuous Oracle Eloqua Reporting Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to SQL Server.
-
Extract, Transform, and Load Discourse Data in Informatica PowerCenter
Create a simple Workflow for Discourse data in Informatica PowerCenter.
-
Write a Simple Go Application to work with FormSite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to FormSite data.
-
ETL Square in Oracle Data Integrator
This article shows how to transfer Square data into a data warehouse using Oracle Data Integrator.
-
Work with HubDB Data in FoxPro
Load HubDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bridge QuickBooks Time Connectivity with Apache NiFi
Access and process QuickBooks Time data in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for MarkLogic
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MarkLogic.
-
Import MariaDB Data Using Azure Data Factory
Use CData Connect AI to connect to MariaDB Data from Azure Data Factory and import live MariaDB data.
-
Edit and Search External AlloyDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of AlloyDB data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create AlloyDB Data objects that you can access from apps and the dashboard.
-
Bidirectional Access to Workday Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Workday data in Filemaker Pro for Mac or Windows.
-
Build a Singer.io Tap for Confluence With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Confluence data using the CData Python Connector.
-
Integrate with Mailjet Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Mailjet data in SnapLogic.
-
Interact with Live MailChimp Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live MailChimp data.
-
Build Semantic Layer Views for Lakebase Data in APOS Live Data Gateway
Use the CData Connector for Lakebase in APOS Live Data Gateway to build Semantic Layer Views for Lakebase data.
-
Build Charts with ScrapingBee Data in Clear Analytics
Create dynamic charts and perform analytics based on ScrapingBee data in Clear Analytics.
-
Connect to SAP ByDesign Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP ByDesign in FileMaker Pro to connect to SAP ByDesign and work with SAP ByDesign data in your FileMaker applications.
-
Visualize Live Sendwithus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sendwithus data.
-
Edit and Search External Acumatica Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Acumatica data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Acumatica Data objects that you can access from apps and the dashboard.
-
How to Connect to & Open Dynamics 365 Data in Microsoft Excel
This article uses the CData ODBC driver for Dynamics 365 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to Live Microsoft Dataverse 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 Microsoft Dataverse data for you.
-
Getting Started with the CData ODBC Driver for Confluence
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Confluence.
-
DataBind Controls to PagerDuty Data in Delphi
DataBind to PagerDuty data in Delphi with standard data access components and controls.
-
Connect to Accelo in SpagoBI
Create reports featuring live Accelo data in SpagoBI Studio. Host Accelo reports on SpagoBI Server.
-
Connect to LaunchDarkly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to LaunchDarkly and work with LaunchDarkly data in your FileMaker applications.
-
How to publish and share Cassandra Data dashboards with Tableau Server
The CData ODBC driver for Cassandra enables you integrate Cassandra data into Tableau dashboards.
-
Connect to Hacker News Data from a Connection Pool in Jetty
The Hacker News JDBC Driver supports connection pooling: This article shows how to connect faster to Hacker News data from Web apps in Jetty.
-
Getting Started with the CData Python Connector for FTP
Learn to install and license the CData Python Connector and configure a connection to live FTP data.
-
Replicate ADP Data from PowerShell
Write a quick PowerShell script to query ADP data. Use connectivity to the live data to replicate ADP data to SQL Server.
-
Integrate Google's Vertex AI Agent with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Drive data within intelligent workflows.
-
Create Discord-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Discord Data from Klipfolio and build custom visualizations using live Discord data.
-
Connect to Sendwithus Data in JRuby
Create a simple JRuby app with access to live Sendwithus data.
-
Query Live Hive Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Hive data through a conversational interface.
-
Automated Continuous Microsoft Dataverse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Google Cloud SQL.
-
Instantly Reporting in OBIEE with the Instantly JDBC Driver
Deploy the Instantly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to Invoiced Data from IntelliJ
Integrate connectivity to Invoiced data with wizards in IntelliJ.
-
Bind Live Zoho Books Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Books data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create Data Visualizations in Cognos BI with Elorus Data
Access Elorus data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect Hugging Face to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Hugging Face with IBM WebSphere for seamless data integration and connectivity.
-
Build Zoho Inventory Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho Inventory data and build visualizations in Tableau Cloud.
-
Use the CData Software ODBC Driver for ZohoDesk in MicroStrategy
Connect to ZohoDesk data in MicroStrategy Developer using the CData Software ODBC Driver for ZohoDesk.
-
Prepare, Blend, and Analyze Azure Analysis Services Data in Alteryx Designer (ODBC)
Build workflows to access live Azure Analysis Services data for self-service data analytics.
-
How to create ZohoSubscriptions federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ZohoSubscriptions data in MySQL .
-
Access Live Sybase IQ Data in Excel 365 Online (Excel for the web)
Connect to Sybase IQ data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for QuickBooks Time in MicroStrategy Desktop
Connect to QuickBooks Time data in MicroStrategy Desktop using the CData Software ODBC Driver for QuickBooks Time.
-
Build Semantic Layer Views for Attio Data in APOS Live Data Gateway
Use the CData Connector for Attio in APOS Live Data Gateway to build Semantic Layer Views for Attio data.
-
Access Clari Data from MySQL in PHP
Connect to Clari through the standard MySQL libraries in PHP.
-
Connect to Adobe Experience Manager Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Experience Manager data in the Denodo Virtual DataPort Administrator.
-
How to Connect the Power BI Service to HubSpot: Complete Guide
Connect to the CData Software Power BI Connector for HubSpot from PowerBI.com to provide real-time HubSpot data across the organization.
-
Build Pipeline CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Pipeline CRM data and build web apps with connectivity to live Pipeline CRM data.
-
Stream Facebook Ads Data into Apache Kafka Topics
Access and stream Facebook Ads data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Azure Data Lake Storage Data in Cognos Analytics
Use CData Connect AI to connect to Azure Data Lake Storage Data from Cognos Analytics and analyze live Azure Data Lake Storage data.
-
Publish Adobe Commerce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Adobe Commerce data.
-
Use the CData ODBC Driver for Box from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Box to connect to Box data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Box data in Excel.
-
Consume Cassandra OData Feeds in PowerBuilder
This article demonstrates how to consume Cassandra data as OData feeds from PowerBuilder using the API Server.
-
Automate xBase Data Replication to Azure Data Lake
Use CData Sync to customize and automate xBase data replication to Azure Data Lake.
-
Integrate Google's Antigravity Agent with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Jira data using the Model Context Protocol.
-
How to update Google Ad Manager from Excel
This article explains how to transfer data from Excel to Google Ad Manager using the Excel Add-In for Google Ad Manager.
-
Automated Continuous MailerLite Replication to SQLite
Use CData Sync for automated, continuous, customizable MailerLite replication to SQLite.
-
Integrate CapsuleCRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CapsuleCRM data from Informatica Cloud.
-
Connect to Microsoft Dataverse Data in RapidMiner
Integrate Microsoft Dataverse data with standard components and data source configuration wizards in RapidMiner Studio.
-
ETL Smartsheet in Oracle Data Integrator
This article shows how to transfer Smartsheet data into a data warehouse using Oracle Data Integrator.
-
Automated PabblySubscriptions Data Replication to Teradata
Use CData Sync to Customize and automate PabblySubscriptions data replication to Teradata.
-
How to integrate Sendwithus with Apache Airflow
Access and process Sendwithus data in Apache Airflow using the CData JDBC Driver.
-
Import Real-Time Cloudant Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cloudant data in ColdFusion.
-
Integrating Kiro with Pipeline CRM 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 Manus AI to Talk to Your TaxJar 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 TaxJar data.
-
How to connect SharePoint with NetSuite Data through external lists
Provide NetSuite data to SharePoint users as an external list.
-
Build Apps with Live Wistia Data Using the Low-Code Development Platform of Mendix
Connect Wistia data with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize ElevenLabs Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ElevenLabs data.
-
A PostgreSQL Interface for Superchat Data using the CData ODBC Driver
Use the SQL Gateway and Superchat ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating OpenCode with WooCommerce 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 Everhour Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Everhour.
-
How to work with Webex Data in Apache Spark using SQL
Access and process Webex Data in Apache Spark using the CData Software JDBC Driver.
-
Enable the Impala JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Impala data.
-
Prepare, Blend, and Analyze Active Directory Data in Alteryx Designer (Connect AI)
Build workflows to access live Active Directory data for self-service data analytics.
-
Build Voice Agents in ElevenLabs with access to Live Omnisend Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Omnisend data.
-
Automated Continuous Pipeline CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Oracle.
-
Build Splunk-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Splunk Data from Zoho Analytics and import live Splunk data.
-
Integrate with Copper Data in JReport Designer
Create charts and reports based on Copper data in JReport Designer.
-
Connect to NetSuite Data in NetBeans
Connect to NetSuite data in NetBeans with the data source configuration wizard.
-
Query Live IBM Informix Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live IBM Informix data through a conversational interface.
-
Natively Connect to Databricks Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Databricks data. Leverage the native support for ODBC in PHP.
-
How to integrate Suadeo with Apache Airflow
Access and process Suadeo data in Apache Airflow using the CData JDBC Driver.
-
Use Claude to Talk to Your Hive 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 Hive data for you.
-
Automated Continuous SAP Netweaver Gateway Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to PostgreSQL.
-
Integrate with live Google Spanner Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Spanner data in Jitterbit.
-
Build MVC Applications with Connectivity to RabbitMQ Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access RabbitMQ from an ASP.NET MVC application.
-
Integrate Trae with Live Paymo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Paymo data from within the AI-powered IDE.
-
Build Agents in Relevance AI with Access to Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on API data within intelligent agent workflows.
-
Integrate with Greenplum Data in JReport Designer
Create charts and reports based on Greenplum data in JReport Designer.
-
Build AI/ML Models with Live ElevenLabs Data using Dataiku
Connect ElevenLabs Data with Dataiku using the CData API Driver for JDBC.
-
Getting Started with the CData SSIS Components for Short.io
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Short.io.
-
Analyze QuickBooks Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of QuickBooks data and visualize live QuickBooks data in Infragistics Reveal.
-
Extract, Transform, and Load Amazon Athena Data in Informatica PowerCenter
Create a simple Workflow for Amazon Athena data in Informatica PowerCenter.
-
Access Live Miro Data in Coginiti Pro
Connect to and query live Miro data from the GUI in the Coginiti Pro: SQL Analytics Tool.