CData Software - Knowledge Base
Recent Articles
-
Integrate Google's Vertex AI Agent with Live IBM Cloud Object Storage 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 IBM Cloud Object Storage data within intelligent workflows.
-
How to connect to Snowflake Data from IntelliJ
Integrate connectivity to Snowflake data with wizards in IntelliJ.
-
Establish a Live Connection with Basecamp Data using Tableau Bridge
The CData ODBC Driver for Basecamp enables you to integrate live Basecamp data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for Grafana in Microsoft Power Query
You can use the CData Grafana ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Grafana data into Microsoft Power Query.
-
How to use SQLAlchemy ORM to access QuickBooks Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of QuickBooks data.
-
Integrate Dify with Live Google Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Analytics data.
-
Enable the Bannerbear JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bannerbear data.
-
Getting Started with the CData Excel Add-In for Insightly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Insightly.
-
Use the CData Software JDBC Driver for Codat in MicroStrategy Web
Connect to Codat data in MicroStrategy Web using the CData Software JDBC Driver for Codat.
-
How to connect and process Foursquare data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Foursquare data.
-
Build Tally-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Tally data and build Tally-connected web apps with Axios.
-
Integrate Dify with Live ZohoSubscriptions Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live ZohoSubscriptions data.
-
Create SSAS Tabular Models from Google Tasks Data
How to build a SQL Server Analysis Service Tabular Model from Google Tasks data using CData drivers.
-
Connect to Confluence from Asprova with CData Software ODBC Driver for Confluence
This article shows how to connect faster to Confluence data from Asprova.
-
Automated Continuous Bugsnag Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bugsnag replication to delimited files (CSV/TSV).
-
Access Missive Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Missive data from HeidiSQL.
-
Consume Airtable OData Feeds in PowerBuilder
This article demonstrates how to consume Airtable data as OData feeds from PowerBuilder using the API Server.
-
How to publish and share SAP BusinessObjects BI Data dashboards with Tableau Server
The CData ODBC driver for SAP BusinessObjects BI enables you integrate SAP BusinessObjects BI data into Tableau dashboards.
-
Automated Continuous Pipeliner CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pipeliner CRM data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Zoom Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoom replication to Snowflake.
-
Configure the CData JDBC Driver for Zoom in a Connection Pool in Tomcat
Connect to Zoom data from a connection pool in Tomcat.
-
Use Databricks Agent Bricks to Talk to Your Samanage Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Samanage data for you.
-
Connect to SageHR Data in DBeaver
Use the CData ODBC Driver to connect to SageHR data in DBeaver.
-
Integrating OpenCode with CapsuleCRM 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 QuickBooks Online Replication to SQL Server
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to SQL Server.
-
How to Connect the Power BI Service to ElevenLabs: Complete Guide
Connect to the CData Software Power BI Connector for ElevenLabs from PowerBI.com to provide real-time ElevenLabs data across the organization.
-
Connect to Redshift Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Redshift and the Script function in FileMaker Pro to connect to Redshift and work with Redshift data in your FileMaker application.
-
Back Up Reply.io data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Reply.io data data.
-
Consume Snapchat Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Snapchat Ads data as OData feeds from PowerBuilder using the API Server.
-
How to Connect to Live Adobe Commerce Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Commerce data securely in real time.
-
Import Real-Time SurveyMonkey Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SurveyMonkey data in ColdFusion.
-
Integrating Zoom Data in Talend Cloud Data Management Platform
Connect Zoom Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
DataBind Google Cloud Storage Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Cloud Storage with the DevExpress Windows Forms and Web controls to provide Google Cloud Storage data to a chart.
-
Working with PingOne Data in LINQPad
Execute LINQ queries to PingOne data in LINQPad.
-
Create Amazon Marketplace-Connected Dashboards in Grafana
Connect to Amazon Marketplace Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Amazon Marketplace data.
-
Perform Batch Operations with XML Data in Apache NiFi
Connect to XML data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Cline with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle Service Cloud data from within your IDE.
-
Automated Continuous SQL Server Replication to MongoDB
Use CData Sync for automated, continuous, customizable SQL Server replication to MongoDB.
-
Getting Started with the CData SSIS Components for Instagram
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Instagram.
-
Connect Salesforce CRM Analytics to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesforce CRM Analytics with IBM WebSphere for seamless data integration and connectivity.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Calendly
Provide connectivity to Calendly data through an SAP BusinessObjects universe.
-
Build FreeAgent-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to FreeAgent data and build web apps with connectivity to live FreeAgent data.
-
How to integrate Metabase with Dynamics 365 Data
Use CData Connect AI to connect to live Dynamics 365 data and create an interactive dashboard in Metabase from Dynamics 365 data.
-
Build Epicor Kinetic-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Epicor Kinetic data.
-
Connect to Calendly Data in Ruby
Connect to Calendly data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Creating Zoom-Connected Applications in Unqork
You can use CData Connect AI to feed Zoom data to Unqork and build custom business apps.
-
Integrate with Copper Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Copper data to a JSON file on disk.
-
Query Greenplum Data as a SQL Server Database in Node.js
Execute SQL Server queries against Greenplum data from Node.js.
-
Sendwithus Reporting in OBIEE with the Sendwithus JDBC Driver
Deploy the Sendwithus JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
DataBind SQL Analysis Services Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SQL Analysis Services with the DevExpress Windows Forms and Web controls to provide SQL Analysis Services data to a chart.
-
How to create Visio diagrams from HBase Data
Automatically update HBase data with the changes you make to Visio master shapes.
-
Use Claude to Talk to Your Slack 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 Slack data for you.
-
How to Work with BigCommerce Data in ETL Validator JDBC
Connect to BigCommerce from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create an RPA flow for Amazon Marketplace Data in UiPath Studio
Use the Amazon Marketplace ODBC Driver to create workflows that access real-time Amazon Marketplace data without any coding.
-
How to Easily Query Gmail Data in OpenOffice Base
Connect to Gmail data in OpenOffice Base using the CData ODBC Driver for Gmail and generate reports with live data insights.
-
Access Live LinkedIn Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to LinkedIn data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Design BIRT Reports on Azure Table Data
Provide current Azure Table data to your embedded analytics.
-
How to connect and process SFTP data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SFTP data.
-
How to import Productboard Data into Apache Solr
Use the CData Software JDBC Driver for Productboard in Data Import Handler and create an automated import of Productboard data to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Close in MicroStrategy Web
Connect to Close data in MicroStrategy Web using the CData Software ODBC Driver for Close.
-
Use Databricks Agent Bricks to Talk to Your FHIR Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your FHIR data for you.
-
Connect to Shortcut Data from Crystal Reports
Use CData Connect AI to connect to and report on live Shortcut data from Crystal Reports.
-
Analyze Sage 200 Data in Cognos Analytics
Use CData Connect AI to connect to Sage 200 Data from Cognos Analytics and analyze live Sage 200 data.
-
Connect to SAP BusinessObjects BI Data in ACL Analytics
Connect to SAP BusinessObjects BI data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP BusinessObjects BI data.
-
Query BigQuery Data in DataGrip
Create a Data Source for BigQuery in DataGrip and use SQL to query live BigQuery data.
-
Connect to QuickBooks Online Data in NetBeans
Connect to QuickBooks Online data in NetBeans with the data source configuration wizard.
-
DataBind xBase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for xBase with the DevExpress Windows Forms and Web controls to provide xBase data to a chart.
-
Connect to Oracle SCM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle SCM and the SQL Gateway to access Oracle SCM data from Google Apps Script.
-
Integrate Real-Time Access to Email in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Email data in real time.
-
Connect to Salesforce Pardot Data in ACL Analytics
Connect to Salesforce Pardot data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce Pardot data.
-
Oracle SCM Reporting in OBIEE with the Oracle SCM JDBC Driver
Deploy the Oracle SCM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Live SharePoint Excel Services Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SharePoint Excel Services data.
-
Automate Vertica Data Replication to Azure Data Lake
Use CData Sync to customize and automate Vertica data replication to Azure Data Lake.
-
Natively Connect to SpaceX Data in PHP
The CData ODBC driver for SpaceX enables you to create PHP applications with connectivity to SpaceX data. Leverage the native support for ODBC in PHP.
-
How to Build an ETL App for Stripe Data in Python with CData Connect AI
Build ETL pipelines that read and write live Stripe data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Mailgun Replication to MySQL
Use CData Sync for automated, continuous, customizable Mailgun replication to MySQL.
-
Connect to Clio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Clio and the SQL Gateway to access Clio data from Google Apps Script.
-
Connecting Mastra with Oracle Eloqua 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 Oracle Eloqua data, no replication required.
-
How to Connect to Live Azure Table 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 Azure Table data for you.
-
Operational Reporting on Amazon Marketplace Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amazon Marketplace data.
-
Use the CData Software ODBC Driver for Reply.io in MicroStrategy Web
Connect to Reply.io data in MicroStrategy Web using the CData Software ODBC Driver for Reply.io.
-
Use Grok to Talk to Your SQL Analysis Services 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 SQL Analysis Services data for you.
-
Create AgileCRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for AgileCRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Live Cvent Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Cvent data.
-
Integrate Microsoft OneDrive with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft OneDrive with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft OneDrive data.
-
Build Data Flows from PayPal to SQL Server using SSIS
Easily back up PayPal data to SQL Server using the SSIS components for PayPal.
-
How to Visualize Campaigner Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Campaigner data in Python.
-
Create Reports from ADP Data in Looker Studio
Use CData Connect AI to gain access to live ADP data and create custom reports in Looker Studio.
-
Procore Reporting in OBIEE with the Procore JDBC Driver
Deploy the Procore JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Zuora Replication to Databricks
Use CData Sync for automated, continuous, customizable Zuora replication to Databricks.
-
Connect to Elasticsearch Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Elasticsearch data from Filemaker Pro on Mac.
-
Create Dynamic Amazon Athena Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon Athena to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Apify Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Apify data and visualize live Apify data in Infragistics Reveal.
-
Create Dashboards and Visualize Live ZohoPeople Data in Geckoboard
Use CData Connect AI to connect to live ZohoPeople data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to use SQLAlchemy ORM to access Authorize.Net Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Authorize.Net data.
-
How to Connect to & Open Google Tasks Data in Microsoft Excel
This article uses the CData ODBC driver for Google Tasks to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Azure Analysis Services Data in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Analysis Services in FileMaker Pro to connect to Azure Analysis Services and work with Azure Analysis Services data in your FileMaker applications.
-
Integrate SAP SuccessFactors LMS with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP SuccessFactors LMS with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP SuccessFactors LMS data.
-
Connect to SendPulse Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SendPulse Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Enable the Google Search JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Search results.