CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Billsby Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Billsby replication to Google BigQuery.
-
Access Live Elasticsearch Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Elasticsearch from your Google Sheets.
-
Use Dash to Build to Web Apps on MySQL Data
Create Python applications that use pandas and Dash to build MySQL-connected web apps.
-
Create Reports with Datadog Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Datadog.
-
Use the CData Software ODBC Driver for Square in SAS for Real-Time Reporting and Analytics
Connect to real-time Square in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Square.
-
Use Microsoft Copilot Studio to talk to your Oracle Eloqua 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 Oracle Eloqua for you.
-
Create Bullhorn CRM-Connected Dashboards in Grafana
Connect to Bullhorn CRM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Bullhorn CRM.
-
Build AI/ML Models with Live Delighted Data using Dataiku
Connect Delighted Data with Dataiku using the CData API Driver for JDBC.
-
Analyze Live Google Contacts Data in SAS Viya
Use CData Connect AI to connect to Google Contacts from SAS Viya and deploy self-service analytics using live Google Contacts.
-
Connect to Real-Time Supabase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Supabase in Power Apps.
-
Automated Continuous Google Sheets Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Sheets replication to MongoDB.
-
Create Keap Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Keap from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create MYOB AccountRight-Connected Dashboards in Grafana
Connect to MYOB AccountRight Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MYOB AccountRight.
-
Build Visualizations of Shortcut Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Shortcut in Birst.
-
Process & Analyze Oracle HCM Cloud Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle HCM Cloud Data.
-
Replicate Workable Data from PowerShell
Write a quick PowerShell script to query Workable. Use connectivity to the live data to replicate Workable to SQL Server.
-
How to Design MySQL Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to MySQL from mobile and tablet Power Apps.
-
Visualize AlloyDB Data in Tableau
The CData ODBC driver for AlloyDB enables you integrate Google AlloyDB into Tableau dashboards.
-
Integrate Cursor with Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Office 365 from within the editor.
-
Integrating Kiro CLI with Workday 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.
-
Establish a Live Connection with ZarMoney Data using Tableau Bridge
The CData ODBC Driver for ZarMoney enables you to integrate live ZarMoney into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Dynamics NAV Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Azure SQL Database.
-
Integrating Cursor CLI with SAP Netweaver Gateway 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.
-
Integrate with FHIR Data in JReport Designer
Create charts and reports based on FHIR in JReport Designer.
-
Visualize Square Data in TIBCO Spotfire through ADO.NET
Integrate Square into dashboards in TIBCO Spotfire.
-
Integrate with Google Ads Data in JReport Designer
Create charts and reports based on Google Ads in JReport Designer.
-
Use Biml to Build SSIS Tasks to Replicate Jumpseller Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jumpseller to SQL Server.
-
Build Voice Agents in ElevenLabs with access to Live Greenplum Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Pivotal GreenPlum.
-
Natively Connect to ConstantContact Data in PHP
The CData ODBC driver for ConstantContact enables you to create PHP applications with connectivity to ConstantContact. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for ZohoMarketingHub in MicroStrategy
Connect to ZohoMarketingHub in MicroStrategy Developer using the CData Software ODBC Driver for ZohoMarketingHub.
-
Integrating Claude Code with Zoho Inventory Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zoho Inventory within assisted coding and automated development workflows.
-
Connect Bitly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bitly using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Box 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 Box.
-
Analyze Smartsheet Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Smartsheet with the CData JDBC Driver for Smartsheet.
-
Connect Short.io to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Short.io using the CData Python MCP Server.
-
Creating Zoho Creator-Connected Applications in Unqork
You can use CData Connect AI to feed Zoho Creator to Unqork and build custom business apps.
-
Use the CData Software JDBC Driver for Access in MicroStrategy
Connect to Microsoft Access in MicroStrategy Developer using the CData Software JDBC Driver for Access.
-
Visualize Yelp Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Yelp into TIBCO Spotfire.
-
Integrate Live HubSpot Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to HubSpot and integrate live HubSpot into apps built in Microsoft Power Apps.
-
View Reports on Real-Time BenchmarkEmail Data in Power BI Report Server
Use the CData ODBC Driver for BenchmarkEmail to visualize BenchmarkEmail in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live ZohoExpense Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZohoExpense into the statistical analysis tools available in SAS JMP. This article shows how to use ZohoExpense in the Graph Builder and Query Builder.
-
Getting Started with the CData SSIS Components for Vault CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Vault CRM.
-
Integrate Azure Data Catalog Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Data Catalog from Informatica Cloud.
-
Use Databricks Agent Bricks to Talk to Your Power BI XMLA Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Power BI XMLA for you.
-
Integrate CloudConvert Data in the Pentaho Report Designer
Publish reports based on CloudConvert in the Pentaho BI tool.
-
Access Live Reckon Data in Coginiti Pro
Connect to and query live Reckon from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Data Flows from Zoho Books to SQL Server using SSIS
Easily back up Zoho Books to SQL Server using the SSIS components for Zoho Books.
-
ETL Contentful in Oracle Data Integrator
This article shows how to transfer Contentful into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Oracle Eloqua Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to MySQL.
-
A PostgreSQL Interface for Zoho Projects Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Projects JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Teamgate Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Teamgate replication to Azure SQL Database.
-
Import Real-Time TigerGraph Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use TigerGraph in ColdFusion.
-
Use JayDeBeApi to access Brex Data in Python
Use standard Python scripting and the development environment of your choice to access live Brex.
-
Connect to and Visualize Live Everhour Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Everhour.
-
Integrate with live Salesforce CRM Analytics Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce CRM Analytics in Jitterbit.
-
DataBind Controls to Klipfolio Data in Delphi
DataBind to Klipfolio in Delphi with standard data access components and controls.
-
Analyze Act CRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Act CRM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Google Sheets Data in RazorSQL
Connect to Google Sheets from wizards and query Google Sheets from the GUI in the RazorSQL database management tool.
-
Create Airtable Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Airtable from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Excel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Excel to Blue Prism using the CData ODBC Driver for Excel to create automated workflows for repetitive business tasks.
-
Connect to Reckon Accounts Hosted Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Reckon Accounts Hosted to connect to Reckon Accounts Hosted and execute queries in PowerBuilder.
-
How to Work with LionDesk Data in AWS Glue Jobs Using JDBC
Connect to LionDesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use JayDeBeApi to access MySQL Data in Python
Use standard Python scripting and the development environment of your choice to access live MySQL.
-
Prepare, Blend, and Analyze Tanda Data in Alteryx Designer (ODBC)
Build workflows to access live Tanda for self-service data analytics.
-
Replicate Google Search Results to Multiple Databases
Replicate Google Search to disparate databases with a point-and-click configuration.
-
Create Greenplum-Connected Nintex Workflows
Use CData Connect AI to connect to Greenplum Data from Nintex Workflow Cloud and build custom workflows using live Pivotal GreenPlum.
-
Process & Analyze MessageBird Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MessageBird Data.
-
Connect Freshteam to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Freshteam using the CData Python MCP Server.
-
Integrating Dataiku with Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Snapchat Ads.
-
Getting Started with the CData Power BI Connector for Cassandra
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Cassandra.
-
Process & Analyze OData Services in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live OData Services.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SurveyMonkey
Provide connectivity to SurveyMonkey through an SAP BusinessObjects universe.
-
Automated Continuous Bannerbear Replication to Snowflake
Use CData Sync for automated, continuous, customizable Bannerbear replication to Snowflake.
-
How to Connect the Power BI Service to Mode: Complete Guide
Connect to the CData Software Power BI Connector for Mode from PowerBI.com to provide real-time Mode across the organization.
-
How to import QuickBooks Online Data into Apache Solr
Use the CData Software JDBC Driver for QuickBooks Online in Data Import Handler and create an automated import of QuickBooks Online to Apache Solr Enterprise Search platform.
-
Connect to Amazon DynamoDB Data from HeidiSQL
Use CData Connect AI to connect to and query live Amazon DynamoDB from HeidiSQL.
-
Getting Started with the CData Tableau Connector for Keap
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Prepare, Blend, and Analyze Box Data in Alteryx Designer (ODBC)
Build workflows to access live Box for self-service data analytics.
-
Connect to MarkLogic Data in JRuby
Create a simple JRuby app with access to live MarkLogic.
-
How to Connect to Dynamics CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Dynamics CRM. Leverage the pyodbc module for ODBC in Python.
-
Connect to Marketo Data in DBArtisan
Use wizards in DBArtisan to configure Marketo as a data source.
-
Create Informatica Mappings From/To a JDBC Data Source for Campaigner
Create Campaigner data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Dotmailer Replication to Oracle
Use CData Sync for automated, continuous, customizable Dotmailer replication to Oracle.
-
Stream JotForm Data into Apache Kafka Topics
Access and stream JotForm in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Zuora Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zuora and visualize live Zuora in Infragistics Reveal.
-
How to Connect to Live SQL Server 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 SQL Server for you.
-
How to Access Live HelloSign Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HelloSign enables you to integrate HelloSign into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAP Fieldglass Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass and execute queries in PowerBuilder.
-
Import Google Drive Data Using Azure Data Factory
Use CData Connect AI to connect to Google Drive Data from Azure Data Factory and import live Google Drive.
-
Use the CData Software ODBC Driver for BambooHR in SAS for Real-Time Reporting and Analytics
Connect to real-time BambooHR in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for BambooHR.
-
Analyze Trello Data in Looker
Use CData Connect AI to connect to Trello Data from Looker and build custom apps using live Trello.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Couchbase
Provide connectivity to Couchbase through an SAP BusinessObjects universe.
-
Automated Continuous GitHub Replication to SingleStore
Use CData Sync for automated, continuous, customizable GitHub replication to SingleStore.
-
How to Connect to Teamwork Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Teamwork. Leverage the pyodbc module for ODBC in Python.
-
Integrating Boomi Agentstudio with Twilio Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Twilio, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
A PostgreSQL Interface for Grafana Data using the CData ODBC Driver
Use the SQL Gateway and Grafana ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Sugar CRM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Sugar CRM Data and create custom apps in Bubble.
-
How to Connect to Live SAP Hybris C4C Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Hybris C4C securely in real time.
-
Automated Continuous Blackbaud FE NXT Replication to Snowflake
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Snowflake.
-
Automated Continuous Recurly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Recurly replication to Apache Cassandra.