CData Software - Knowledge Base
Recent Articles
-
Use Agno to Talk to Your Bannerbear 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 Bannerbear data for you.
-
Use the CData Software ODBC Driver for Google Contacts in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Contacts data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Contacts.
-
Import Real-Time SAP BusinessObjects BI Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP BusinessObjects BI data in ColdFusion.
-
Automated Continuous CouchDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CouchDB replication to Google BigQuery.
-
Use ChatGPT to Talk to Your Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Cloudflare data for you.
-
Create Reports from Azure Data Catalog Data in Looker Studio
Use CData Connect AI to gain access to live Azure Data Catalog data and create custom reports in Looker Studio.
-
How to Work with Cassandra Data in ETL Validator JDBC
Connect to Cassandra from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Perigon Replication to SQLite
Use CData Sync for automated, continuous, customizable Perigon replication to SQLite.
-
Connect to Zoom Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoom as an External Source in Dremio.
-
Use JayDeBeApi to access ClickTime Data in Python
Use standard Python scripting and the development environment of your choice to access live ClickTime data.
-
Automated Continuous Vimeo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Vimeo replication to MongoDB.
-
Integrate SAP Business Warehouse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Business Warehouse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Business Warehouse data.
-
Connecting Moonlit Workflow with Facebook Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Facebook Ads data in real time.
-
How to Connect the Power BI Service to Microsoft Planner: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft Planner from PowerBI.com to provide real-time Microsoft Planner data across the organization.
-
Connect to ChartMogul Data in DBeaver
Use the CData ODBC Driver to connect to ChartMogul data in DBeaver.
-
Query PostgreSQL Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume PostgreSQL entities in PHP by modeling them as objects.
-
Build Google Directory Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Directory data and build visualizations in Tableau Cloud.
-
Use Manus AI to Talk to Your Salesforce Pardot 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 Salesforce Pardot data.
-
Connect to Zoho Projects from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Projects data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Publish Notion-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Notion data.
-
Integrate Miro Data in the Pentaho Report Designer
Publish reports based on Miro data in the Pentaho BI tool.
-
Integrate Live SAP HANA XS Advanced Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP HANA XS Advanced from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP HANA XS Advanced data.
-
Build Voice Agents in ElevenLabs with access to Live Google Calendar Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Calendar data.
-
Connecting GenSpark with Square Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Square data without any replication or custom integration required.
-
Automated Continuous Jodoo Replication to SQLite
Use CData Sync for automated, continuous, customizable Jodoo replication to SQLite.
-
Visualize Live ZohoDesk Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ZohoDesk data into custom reports in Power BI.
-
Integrating Cursor with GraphQL 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 Spark Data in Google Apps Script via Connect AI
Use CData Connect AI to access Spark data in Google Apps Script.
-
Integrating Placid Data in Talend Cloud Data Management Platform
Connect Placid Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Data Flows from SQL Server to Google Contacts through SSIS
Easily push SQL Server data to Google Contacts using the CData SSIS Tasks for Google Contacts.
-
Publish Crystal Reports on Landbot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Landbot data.
-
Publish Crystal Reports on OData Services
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date OData services.
-
Connect to Sybase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sybase data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Real-Time Access to SurveyMonkey in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SurveyMonkey data in real time.
-
Operational Reporting on Reckon Accounts Hosted Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Reckon Accounts Hosted data.
-
Use the CData Software JDBC Driver for Epicor Kinetic in MicroStrategy Web
Connect to Epicor Kinetic data in MicroStrategy Web using the CData Software JDBC Driver for Epicor Kinetic.
-
Easily Integrate EnterpriseDB Data in Lazarus Pascal IDE
Learn how to easily integrate live EnterpriseDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Feed PayPal Data into FineReport
How to set PayPal data as a JDBC data source in FineReport.
-
Connect to Jira Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Jira to connect to Jira data and execute queries in PowerBuilder.
-
Analyze Shippo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Shippo data and visualize live Shippo data in Infragistics Reveal.
-
Connect to OneNote Data in RapidMiner
Integrate OneNote data with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Multiple Mouseflow Accounts
Replicate multiple Mouseflow accounts to one or many databases.
-
How to Build an ETL App for Accelo Data in Python with CData
Create ETL applications and real-time data pipelines for Accelo data in Python with petl.
-
Invoiced Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Invoiced facts in real time.
-
Getting Started with the CData JDBC Driver for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pipeliner CRM.
-
Access Live Google Forms Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Forms data from your Excel spreadsheets.
-
Load Facebook Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Facebook data to a database.
-
Create SAP BusinessObjects BI-Connected Dashboards in Grafana
Connect to SAP BusinessObjects BI Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP BusinessObjects BI data.
-
Connect to SQL Analysis Services Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SQL Analysis Services and the Script function in FileMaker Pro to connect to SQL Analysis Services and work with SQL Analysis Services data in your FileMaker application.
-
DataBind Charts to Campaigner Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Campaigner data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect and Query Live SparkPost Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SparkPost data into Databricks and enable direct, live querying and analysis without replication.
-
Create Stripe-Connected Dashboards in Grafana
Connect to Stripe Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Stripe data.
-
Use JayDeBeApi to access Cloudflare Data in Python
Use standard Python scripting and the development environment of your choice to access live Cloudflare data.
-
Connect to RabbitMQ Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to RabbitMQ and work with RabbitMQ data in your FileMaker application.
-
How to Connect to & Open Opsgenie Data in Microsoft Excel
This article uses the CData ODBC driver for Opsgenie to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to Live Elasticsearch 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 Elasticsearch data for you.
-
Connect to AfterShip Data in ACL Analytics
Connect to AfterShip data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to AfterShip data.
-
Use JayDeBeApi to access Cosmos DB Data in Python
Use standard Python scripting and the development environment of your choice to access live Cosmos DB data.
-
Automated Continuous Float Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Float replication to delimited files (CSV/TSV).
-
Getting Started with the CData ODBC Driver for Spark
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Spark.
-
Integrating LlamaIndex with BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on BigQuery data in real time.
-
Explore Geographical Relationships in QuickBooks Online Data with Power Map
Create data visualizations with QuickBooks Online data in Power Map.
-
Integrating Claude Code with Sugar CRM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sugar CRM data within assisted coding and automated development workflows.
-
Process & Analyze JotForm Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live JotForm Data.
-
How to Work with Salesloft Data in ETL Validator JDBC
Connect to Salesloft from ETL Validator jobs using the CData Software JDBC Driver.
-
How to work with Placid Data in Apache Spark using SQL
Access and process Placid Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live SAP Concur 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 SAP Concur data through MCP integration.
-
Use JayDeBeApi to access Amazon Athena Data in Python
Use standard Python scripting and the development environment of your choice to access live Amazon Athena data.
-
Integrating Dataiku with LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live LinkedIn data.
-
How to Connect to & Open ZohoExpense Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoExpense to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dashboards and Visualize Live Jira Data in Geckoboard
Use CData Connect AI to connect to live Jira data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Access Live RSS Feeds in Power Automate Desktop via ODBC
The CData ODBC Driver for RSS enables you to integrate RSS feeds into workflows built using Microsoft Power Automate Desktop.
-
Connect to FTP Data in CloverDX (formerly CloverETL)
Transfer FTP data using the visual workflow in the CloverDX data integration tool.
-
Integrate Live Google Sheets Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Sheets data to Blue Prism using the CData ODBC Driver for Google Sheets to create automated workflows for repetitive business tasks.
-
How to connect to Google Ad Manager Data in DBVisualizer
Integrate Google Ad Manager data with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Live Gong Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Gong data.
-
DataBind Controls to Active Directory Data in C++Builder
DataBind to Active Directory data in C++Builder with standard components and controls.
-
Access Box Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Box data from your Oracle system.
-
Use the CData Software ODBC Driver for ClickUp in MicroStrategy Desktop
Connect to ClickUp data in MicroStrategy Desktop using the CData Software ODBC Driver for ClickUp.
-
Automated Continuous Gumroad Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Gumroad replication to Azure SQL Database.
-
Link Mistral AI with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mistral AI data in Filemaker Pro for Mac or Windows.
-
Automated Continuous Campaigner Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Campaigner replication to Azure SQL Database.
-
Automated Continuous Webex Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Webex replication to Apache Kafka.
-
Use the CData Software JDBC Driver for Demio in MicroStrategy Web
Connect to Demio data in MicroStrategy Web using the CData Software JDBC Driver for Demio.
-
How to use SQLAlchemy ORM to access ZendeskSell Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZendeskSell data.
-
Import Real-Time LaunchDarkly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LaunchDarkly data in ColdFusion.
-
How to Connect to Live Airtable Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Airtable data through natural language.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP
Create SAP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Dotmailer Replication to MySQL
Use CData Sync for automated, continuous, customizable Dotmailer replication to MySQL.
-
How to Connect to Live Spark 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 Spark data for you.
-
Create Reports with Adobe Target Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Target data.
-
Choosing the Best Method to Connect Bugsnag to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bugsnag data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Claude Code CLI with Redis 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.
-
Integrating OpenCode with Active Directory 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 SuiteCRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SuiteCRM data using standard SQL.
-
Create Klipfolio-Connected Business Apps in AppSheet
Connect to Klipfolio Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Klipfolio data.
-
Getting Started with the CData JDBC Driver for Hugging Face
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Hugging Face.
-
Getting Started with the CData ODBC Driver for ChargeOver
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ChargeOver.
-
Access Live Oracle SCM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle SCM data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Automated Workflows with Live VWO Data in Workato
Use CData Connect AI to connect to live VWO data and build automated workflows in Workato.