CData Software - Knowledge Base
Recent Articles
-
Connect to Smartsheet Data in Jaspersoft Studio
Execute SQL to remote Smartsheet data in Jaspersoft Studio.
-
Automated Continuous XML Replication to MongoDB
Use CData Sync for automated, continuous, customizable XML replication to MongoDB.
-
Prepare, Blend, and Analyze Aweber Data in Alteryx Designer (ODBC)
Build workflows to access live Aweber data for self-service data analytics.
-
Integrating Dataiku with Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Yelp data.
-
Connect to MySQL from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MySQL data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Contentful Data in the Pentaho Report Designer
Publish reports based on Contentful data in the Pentaho BI tool.
-
Build Charts with Wrike Data in Clear Analytics
Create dynamic charts and perform analytics based on Wrike data in Clear Analytics.
-
How to Connect to Live LinkedIn Ads Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your LinkedIn Ads data for you.
-
Integrate Cline with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon DynamoDB data from within your IDE.
-
Integrating Gumloop with Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sage Intacct data within automated workflows.
-
Import Real-Time ZarMoney Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZarMoney data in ColdFusion.
-
Design BIRT Reports on Sentry Data
Provide current Sentry data to your embedded analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Clockify
Provide connectivity to Clockify data through an SAP BusinessObjects universe.
-
DataBind Controls to Mouseflow Data in Delphi
DataBind to Mouseflow data in Delphi with standard data access components and controls.
-
Connecting Pipedream with Sendwithus Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Sendwithus data in real time.
-
Build Semantic Layer Views for Discord Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Discord data.
-
Getting Started with the CData ODBC Driver for Bitly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bitly.
-
Connect to OneNote Data in Claris FileMaker Pro
Use the CData ODBC Driver for OneNote in FileMaker Pro to connect to OneNote and work with OneNote data in your FileMaker applications.
-
Enable the Zoho Projects JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoho Projects data.
-
Use Agno to Talk to Your Zoom 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 Zoom data for you.
-
How to use SQLAlchemy ORM to access HBase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HBase data.
-
How to Visualize Superchat Data in Python with pandas
Use pandas and other modules to analyze and visualize live Superchat data in Python.
-
DataBind Controls to Guru Data in Delphi
DataBind to Guru data in Delphi with standard data access components and controls.
-
Migrating data from Google Cloud Storage to Snowflake using CData SSIS Components.
Easily push Google Cloud Storage data to Snowflake using the CData SSIS Tasks for Google Cloud Storage and Snowflake.
-
Replicate Perigon Data to Multiple Databases
Replicate Perigon data to disparate databases with a point-and-click configuration.
-
Establish a Live Connection with Facebook Data using Tableau Bridge
The CData ODBC Driver for Facebook enables you to integrate live Facebook data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Miro Data from MySQL in PHP
Connect to Miro through the standard MySQL libraries in PHP.
-
Build Pipelines with Live QuickBooks Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to QuickBooks from Google Cloud Data Fusion, enabling the integration of live QuickBooks data into the building and management of effective data pipelines.
-
Use Azure AI Foundry to Talk to Your Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Moosend data for you.
-
Process & Analyze Sybase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sybase Data.
-
Connect to Freshdesk Data from AWS Glue
Use CData Connect AI to gain access to live Freshdesk data from your AWS Glue jobs.
-
Build Dashboards with Figshare Data in DBxtra
Create dynamic dashboards and perform analytics based on Figshare data in DBxtra.
-
Access Live Omnisend Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Omnisend data from your Google Sheets.
-
How to Connect to & Open SAS xpt Data in Microsoft Excel
This article uses the CData ODBC driver for SAS xpt to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Slack Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Slack data from your Excel spreadsheets.
-
Build Data Flows from Cloudant to SQL Server using SSIS
Easily back up Cloudant data to SQL Server using the SSIS components for Cloudant.
-
Building Dynamic Web Pages with Anaplan Data Using AngularJS
Create single-page applications with live connectivity to Anaplan using the CData API Server.
-
Add Flowlu Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Flowlu with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query Harvest Data in MySQL Workbench
Execute MySQL queries against live Harvest data from MySQL Workbench.
-
How to Connect to Live PostgreSQL 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 PostgreSQL data for you.
-
Creating Dropbox-Connected Applications in Unqork
You can use CData Connect AI to feed Dropbox data to Unqork and build custom business apps.
-
Build Agents in Relevance AI with Access to Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on LinkedIn data within intelligent agent workflows.
-
Getting Started with the CData ADO.NET Provider for Confluence
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Confluence.
-
Visualize Live Quickbase Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Quickbase data.
-
Connecting GenSpark with Tavily Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Tavily data without any replication or custom integration required.
-
Automated Continuous Mistral AI Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Mistral AI replication to delimited files (CSV/TSV).
-
Enable the Chargebee JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Chargebee data.
-
Getting Started with the CData Connect AI Python SDK for SageHR
Install the CData Connect AI Python SDK to read live SageHR data with standard DB-API 2.0 Python code.
-
Use Claude to Talk to Your HubSpot 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 HubSpot data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle SCM
Create an ODBC connection to Oracle SCM in Informatica and browse and transfer Oracle SCM data.
-
A PostgreSQL Interface for Mouseflow Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mouseflow JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating SAP Netweaver Gateway Data in Talend Cloud Data Management Platform
Connect SAP Netweaver Gateway Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Netweaver Gateway.
-
Connecting Moonlit Workflow with ClickUp 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 ClickUp data in real time.
-
Visualize Supabase 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 Supabase data into TIBCO Spotfire.
-
Build SFTP-Connected Apps in Choreo
Use CData Connect AI to connect to SFTP Data from Choreo and build custom apps using live SFTP data.
-
Visualize Live Bitbucket Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Bitbucket data into custom reports in Power BI.
-
Visualize Exact Online Data in TIBCO Spotfire through ADO.NET
Integrate Exact Online data into dashboards in TIBCO Spotfire.
-
Connect Campaigner to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Campaigner with IBM WebSphere for seamless data integration and connectivity.
-
Link SendInBlue with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SendInBlue data in Filemaker Pro for Mac or Windows.
-
Connect to ShipEngine Data in Ruby
Connect to ShipEngine data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Yelp Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Yelp data in Microsoft R Open.
-
Connect to IBM Informix Data in HULFT Integrate
Connect to IBM Informix as a JDBC data source in HULFT Integrate
-
Connect to MailChimp Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MailChimp data.
-
Getting Started with the CData Tableau Connector for Google Search
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Search.
-
How to Connect Flowise AI Agents to Live Mailjet 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 Mailjet data without replication.
-
Automated Continuous Aweber Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Aweber replication to Google Cloud SQL.
-
Access Testmonitor Data from MySQL in PHP
Connect to Testmonitor through the standard MySQL libraries in PHP.
-
Migrating data from DocuSign to Google BigQuery using CData SSIS Components.
Easily push DocuSign data to Google BigQuery using the CData SSIS Tasks for DocuSign and Google BigQuery.
-
How to use SQLAlchemy ORM to access WordPress Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of WordPress data.
-
How to Build an ETL App for Yelp Data in Python with CData Connect AI
Extract and transform live Yelp data in Python with petl and the CData Connect AI Python SDK.
-
How to integrate DB2 with Apache Airflow
Access and process DB2 data in Apache Airflow using the CData JDBC Driver.
-
Connect to Freshsales Data in RapidMiner
Integrate Freshsales data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Vercel Data from MySQL in Amazon QuickSight
Connect to Vercel and build visualizations of Vercel data using a MySQL Connection in Amazon QuickSight.
-
Connect to Live Dynamics CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Dynamics CRM Data in CData Connect AI and connect to your Dynamics CRM data from MicroStrategy.
-
Model Microsoft Planner Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Planner, enabling the direct import of real-time Microsoft Planner data.
-
Visualize Grafana Data in TIBCO Spotfire through ADO.NET
Integrate Grafana data into dashboards in TIBCO Spotfire.
-
Automated Continuous Mixpanel Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Mixpanel replication to AlloyDB.
-
Build Apps with Live Supabase data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Supabase data into the Adalo platform and build custom mobile and web applications with real-time Supabase data.
-
Visualize Optimizely Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Optimizely data.
-
Klipfolio Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Klipfolio data through CData Connect AI using different applications and tools.
-
Getting Started with the CData ODBC Driver for Mixpanel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mixpanel.
-
View Reports on Real-Time Telegram Data in Power BI Report Server
Use the CData ODBC Driver for Telegram to visualize Telegram data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to QuickBooks Data from Crystal Reports
Use CData Connect AI to connect to and report on live QuickBooks data from Crystal Reports.
-
Build a Simple VCL Application for Billsby Data
How to build a simple VCL Application to view Billsby data in RAD Studio using the CData ODBC Driver for Billsby.
-
How to connect to Autopilot Data from Spring Boot
Connect to Autopilot in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to SAP BusinessObjects BI in SpagoBI
Create reports featuring live SAP BusinessObjects BI data in SpagoBI Studio. Host SAP BusinessObjects BI reports on SpagoBI Server.
-
Automated Continuous SAP Concur Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Concur replication to AlloyDB.
-
Automated Continuous PabblySubscriptions Replication to Vertica
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Vertica.
-
Integrate Live Notion Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Notion from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Notion data.
-
Migrating data from Apollo to Snowflake using CData SSIS Components.
Easily push Apollo data to Snowflake using the CData SSIS Tasks for Apollo and Snowflake.
-
Build ConstantContact-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ConstantContact Data and create custom apps in Bubble.
-
Integrate with Tally Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Tally data in SnapLogic.
-
How to work with Datadog Data in Apache Spark using SQL
Access and process Datadog Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Power BI Connector for Adobe Target
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Adobe Target.
-
Automated Continuous GraphQL Replication to Databricks
Use CData Sync for automated, continuous, customizable GraphQL replication to Databricks.
-
Integrate SendGrid Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SendGrid data and integrate live SendGrid data into your Power Automate tasks.
-
How to Work with Zoho CRM Data in ETL Validator JDBC
Connect to Zoho CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect and Query Live Excel Online Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Excel Online data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous ClickUp Replication to Databricks
Use CData Sync for automated, continuous, customizable ClickUp replication to Databricks.
-
How to Build an ETL App for Pipedrive Data in Python with CData Connect AI
Build ETL pipelines that read and write live Pipedrive data in Python with petl and the CData Connect AI Python SDK.