CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Raisers Edge NXT Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Google BigQuery.
-
Integrate Cline with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Reckon Accounts Hosted data from within your IDE.
-
Getting Started with the CData SSIS Components for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon Athena.
-
Import Real-Time Google Campaign Manager 360 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Campaign Manager 360 data in ColdFusion.
-
DataBind Controls to Google Directory Data in C++Builder
DataBind to Google Directory data in C++Builder with standard components and controls.
-
Automate Recurly Data Replication to SAP HANA
Use CData Sync to customize and automate Recurly data replication to SAP HANA.
-
Moving Data from MYOB AccountRight to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MYOB AccountRight data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Greenplum Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Greenplum data for you.
-
Automated Continuous FreshBooks Replication to SQL Server
Use CData Sync for automated, continuous, customizable FreshBooks replication to SQL Server.
-
Connecting Mastra with Mailgun 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 Mailgun data, no replication required.
-
Analyze PDFMonkey Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PDFMonkey data in Microsoft R Open.
-
How to Access Live Amazon DynamoDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon DynamoDB enables you to integrate Amazon DynamoDB data into workflows built using Microsoft Power Automate Desktop.
-
Build Cosmos DB-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 Cosmos DB data without replication.
-
Connect to CapsuleCRM Data in Aqua Data Studio
Access CapsuleCRM data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Tanda Data from PowerBuilder via ADO.NET
This article demonstrates how to access Tanda data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Live ServiceDesk Plus Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your ServiceDesk Plus data for you.
-
Easily Integrate SQL Analysis Services Data in Lazarus Pascal IDE
Learn how to easily integrate live SQL Analysis Services data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Simplesat Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Simplesat facts in real time.
-
Validate VWO Data with QuerySurge
Access and validate VWO data in QuerySurge using the CData JDBC Driver.
-
Access Live Google Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ads data from your Excel spreadsheets.
-
Integrating LlamaIndex with Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Dynamics CRM data in real time.
-
Create Dashboards and Visualize Live Anaplan Data in Geckoboard
Use CData Connect AI to connect to live Anaplan data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Keap Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Keap replication to PostgreSQL.
-
Automated Continuous Google Sheets Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Sheets replication to delimited files (CSV/TSV).
-
How to Work with Acumatica Data in ETL Validator JDBC
Connect to Acumatica from ETL Validator jobs using the CData Software JDBC Driver.
-
Explore Geographical Relationships in SAP Hybris C4C Data with Power Map
Create data visualizations with SAP Hybris C4C data in Power Map.
-
Use Dash to Build Web Apps on Xero Data via CData Connect AI
Build interactive Dash web apps on live Xero data using pandas and the CData Connect AI Python SDK.
-
Bridge Contentful Connectivity with Apache NiFi
Access and process Contentful data in Apache NiFi using the CData JDBC Driver.
-
Use Agno to Talk to Your Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Toggl data for you.
-
Visualize Live PostgreSQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live PostgreSQL data into custom reports in Power BI.
-
How to integrate Metabase with Snapchat Ads Data
Use CData Connect AI to connect to live Snapchat Ads data and create an interactive dashboard in Metabase from Snapchat Ads data.
-
Automated Continuous BambooHR Replication to MySQL
Use CData Sync for automated, continuous, customizable BambooHR replication to MySQL.
-
Visualize Google Ads Data in TIBCO Spotfire through ADO.NET
Integrate Google Ads data into dashboards in TIBCO Spotfire.
-
Query Live Reckon Accounts Hosted 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 Reckon Accounts Hosted data directly from the development environment.
-
Create Reports from SageHR Data in Looker Studio
Use CData Connect AI to gain access to live SageHR data and create custom reports in Looker Studio.
-
DataBind Controls to SAP Business Warehouse Data in Delphi
DataBind to SAP Business Warehouse data in Delphi with standard data access components and controls.
-
Use CData Connect AI to Access Square Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Square data in the Power Pivot business intelligence tool.
-
Build Dynamics 365-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Dynamics 365 Data from Zoho Analytics and import live Dynamics 365 data.
-
Create Apps from Oracle SCM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle SCM Data and build apps from live Oracle SCM data in Qlik Sense Cloud.
-
Integrate Close Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Close data from Informatica Cloud.
-
Integrating Claude Code CLI with ZeroBounce 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.
-
Analyze Monday.com Data in Looker
Use CData Connect AI to connect to Monday.com Data from Looker and build custom apps using live Monday.com data.
-
Integrate Trae with Live GitHub Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live GitHub data from within the AI-powered IDE.
-
Access Live Microsoft Dataverse Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Dataverse data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Insightly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Insightly data from Informatica Cloud.
-
How to connect PolyBase to ShipStation
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ShipStation data.
-
Integrate Devin with Live Databricks Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Databricks data.
-
Bind Live MYOB AccountRight Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MYOB AccountRight data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate Moosend with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Moosend with External Services.
-
Automated Continuous ServiceNow Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ServiceNow replication to Amazon Redshift.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Spanner
Provide connectivity to Google Spanner data through an SAP BusinessObjects universe.
-
Create Snowflake-Connected Nintex Workflows
Use CData Connect AI to connect to Snowflake Data from Nintex Workflow Cloud and build custom workflows using live Snowflake data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Spark
Provide connectivity to Spark data through an SAP BusinessObjects universe.
-
Integrate Blackbaud FE NXT Data in Pentaho Data Integration
Build ETL pipelines based on Blackbaud FE NXT data in the Pentaho Data Integration tool.
-
Automated Continuous Placid Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Placid replication to IBM DB2.
-
Build Omnisend-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Omnisend data and build Omnisend-connected web apps with Axios.
-
Link Qualaroo with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Qualaroo data in Filemaker Pro for Mac or Windows.
-
Automated Continuous FormSite Replication to Databricks
Use CData Sync for automated, continuous, customizable FormSite replication to Databricks.
-
Migrating data from Google Ad Manager to Google BigQuery using CData SSIS Components.
Easily push Google Ad Manager data to Google BigQuery using the CData SSIS Tasks for Google Ad Manager and Google BigQuery.
-
Enable the Mouseflow JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mouseflow data.
-
ETL SpaceX in Oracle Data Integrator
This article shows how to transfer SpaceX data into a data warehouse using Oracle Data Integrator.
-
Connect to OData Services from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for OData to connect to OData services and execute queries in PowerBuilder.
-
Connect and Visualize Live Sendwithus Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sendwithus data into the Databricks platform and create visualization dashboards with real-time Sendwithus data.
-
DataBind Controls to Marketo Data in C++Builder
DataBind to Marketo data in C++Builder with standard components and controls.
-
Integrate Omnisend Data into Power Automate Desktop using CData Connect
CData Connect for Omnisend Data enables you to integrate Omnisend data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live Close Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Close data.
-
Access Live ZohoSubscriptions Data in AWS Lambda
Connect to live ZohoSubscriptions data in AWS Lambda using the CData JDBC Driver.
-
Analyze Power BI XMLA Data in Cognos Analytics
Use CData Connect AI to connect to Power BI XMLA Data from Cognos Analytics and analyze live Power BI XMLA data.
-
Automated Continuous Cassandra Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Cassandra replication to Google Cloud SQL.
-
How to Work with Google Translate Data in AWS Glue Jobs Using JDBC
Connect to Google Translate from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Moving Data from AgileCRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live AgileCRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Link FreshBooks with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate FreshBooks data in Filemaker Pro for Mac or Windows.
-
Automated Continuous Excel Online Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Excel Online replication to PostgreSQL.
-
How to connect to Databricks Data from Spring Boot
Connect to Databricks in a Spring Boot Application using the CData JDBC Driver for Databricks
-
Excel Spreadsheet Automation on Azure Analysis Services Data with the QUERY Formula
Pull data from Azure Analysis Services, automate spreadsheets, and more with the QUERY formula.
-
Build AI/ML Models with Live Accelo Data using Dataiku
Connect Accelo Data with Dataiku using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for HCL Domino
Create HCL Domino data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Natively Connect to Helpscout Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Helpscout data. Leverage the native support for ODBC in PHP.
-
Connect to MySQL from Asprova with CData Software ODBC Driver for MySQL
This article shows how to connect faster to MySQL data from Asprova.
-
Analyze MariaDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MariaDB data and visualize live MariaDB data in Infragistics Reveal.
-
Link Shortcut with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Shortcut data in Filemaker Pro for Mac or Windows.
-
How to connect and process PagerDuty data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PagerDuty data.
-
Use the CData Software JDBC Driver for GraphQL in MicroStrategy Desktop
Connect to GraphQL data in MicroStrategy Desktop using the CData Software JDBC Driver for GraphQL.
-
How to Connect Flowise AI Agents to Live BambooHR Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live BambooHR data without replication.
-
Build Paymo-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Paymo Data and create custom apps in Bubble.
-
Create Zuora-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zuora Data from OutSystems and build custom enterprise apps using live Zuora data.
-
Automated Continuous Quaderno Replication to MySQL
Use CData Sync for automated, continuous, customizable Quaderno replication to MySQL.
-
Use Dash to Build to Web Apps on ZohoPeople Data
Create Python applications that use pandas and Dash to build ZohoPeople-connected web apps.
-
Natively Connect to Planio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Planio data. Leverage the native support for ODBC in PHP.
-
Connect and Visualize Live Jumpseller Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Jumpseller data into the Databricks platform and create visualization dashboards with real-time Jumpseller data.
-
Build a Simple VCL Application for Salesforce CRM Analytics Data
How to build a simple VCL Application to view Salesforce CRM Analytics data in RAD Studio using the CData ODBC Driver for Salesforce CRM Analytics.
-
Replicate Multiple XML Accounts
Replicate multiple XML accounts to one or many databases.
-
How to load DocuSign data into Elasticsearch via Logstash
Introducing a simple method to load DocuSign data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate Spark Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Spark data from PowerShell? This article demonstrates how to utilize the Spark Cmdlets for tasks like connecting to Spark data, automating operations, downloading data, and more.
-
Connect to Elasticsearch Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Elasticsearch data in Airbyte.
-
Connect to Elorus Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Elorus as an External Source in Dremio.
-
Build an OLAP Cube in SSAS from SQL Analysis Services Data
Establish a connection to SQL Analysis Services data data from SQL Server Analysis Services, and use the SQL Analysis Services Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Controls to MailChimp Data in Delphi
DataBind to MailChimp data in Delphi with standard data access components and controls.
-
How to Query Billsby Data in MySQL Workbench
Execute MySQL queries against live Billsby data from MySQL Workbench.
-
Integrate Guru with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Guru with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Guru data.