CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Gumroad Data in OpenOffice Base
Connect to Gumroad data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Basecamp Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Basecamp data using standard SQL.
-
Connect to Oracle Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle to connect to Oracle data and execute queries in PowerBuilder.
-
Connect to Greenhouse from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Greenhouse data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Microsoft Planner Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Planner data with the CData JDBC Driver for Microsoft Planner.
-
How to Connect to & Open JotForm Data in Microsoft Excel
This article uses the CData ODBC driver for JotForm to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bridge Freshsales Connectivity with Apache NiFi
Access and process Freshsales data in Apache NiFi using the CData JDBC Driver.
-
Operational Reporting on Suadeo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Suadeo data.
-
Explore Geographical Relationships in Marketo Data with Power Map
Create data visualizations with Marketo data in Power Map.
-
Connect to and Visualize Live MySQL Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MySQL data.
-
How to Connect DBeaver to Datadog via a JDBC Driver
Manage Datadog data with visual tools in DBeaver like the query browser.
-
Connect to eBay from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from eBay data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live CloudConvert Data in Coginiti Pro
Connect to and query live CloudConvert data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Onfleet Replication to MySQL
Use CData Sync for automated, continuous, customizable Onfleet replication to MySQL.
-
Automated Continuous Gorgias Replication to MongoDB
Use CData Sync for automated, continuous, customizable Gorgias replication to MongoDB.
-
Automated Continuous MailChimp Replication to Snowflake
Use CData Sync for automated, continuous, customizable MailChimp replication to Snowflake.
-
Build Automated Azure DevOps-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure DevOps data and build automated workflows in Zapier.
-
Teradata Reporting in OBIEE with the Teradata JDBC Driver
Deploy the Teradata JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Cline with Live BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live BenchmarkEmail data from within your IDE.
-
Connect to Factorial Data in RapidMiner
Integrate Factorial data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Use a Microsoft Access Database to Update ActiveCampaign Data in Real Time
Update ActiveCampaign data by creating a linked table in Microsoft Access with the CData ActiveCampaign ODBC Driver.
-
Integrate Access Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Access data from Informatica Cloud.
-
Analyze Twitter Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Twitter Ads from Power Pivot. You will use the Table Import Wizard to load Twitter Ads data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing data for you.
-
Connect and Visualize Live ZohoPeople Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ZohoPeople data into the Databricks platform and create visualization dashboards with real-time ZohoPeople data.
-
Build Apps with Live Retently Data Using the Low-Code Development Platform of Mendix
Connect Retently data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Connect to Live Square Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Square data for you.
-
Connect to and Query Apify Data in QlikView over ODBC
Create data visualizations with Apify data in QlikView.
-
How to Visualize Google Search Results in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Search results in Python.
-
Connect to Sybase IQ Data in CloverDX (formerly CloverETL)
Transfer Sybase IQ data using the visual workflow in the CloverDX data integration tool.
-
Integrating Claude Code CLI with Adobe Analytics 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.
-
Write a Simple Go Application to work with EmailOctopus Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to EmailOctopus data.
-
Build Charts with CouchDB Data in Clear Analytics
Create dynamic charts and perform analytics based on CouchDB data in Clear Analytics.
-
How to Connect DBeaver to SAP Concur via a JDBC Driver
Manage SAP Concur data with visual tools in DBeaver like the query browser.
-
Access Live SendInBlue Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SendInBlue data into the statistical analysis tools available in SAS JMP. This article shows how to use SendInBlue data in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To an ODBC Data Source for Databricks
Create an ODBC connection to Databricks in Informatica and browse and transfer Databricks data.
-
How to connect and process Paymo data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Paymo data.
-
Use the CData Software JDBC Driver for Egnyte in MicroStrategy
Connect to Egnyte data in MicroStrategy Developer using the CData Software JDBC Driver for Egnyte.
-
How to connect and process JDBC-ODBC Bridge data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live JDBC-ODBC Bridge data.
-
Easily Integrate Dynamics 365 Data in Lazarus Pascal IDE
Learn how to easily integrate live Dynamics 365 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Viewing Microsoft Exchange Data in RAD Studio Data Explorer
How to view Microsoft Exchange data in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Exchange.
-
Access Live Twilio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Twilio data into the statistical analysis tools available in SAS JMP. This article shows how to use Twilio data in the Graph Builder and Query Builder.
-
Connect to GitLab Data in Ruby
Connect to GitLab data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Testmonitor Data in JReport Designer
Create charts and reports based on Testmonitor data in JReport Designer.
-
How to Create Power BI Visual Reports with Real-Time Zoho Creator Data
Use CData Power BI Connectors to visualize Zoho Creator data in Power BI.
-
Connecting Moonlit Workflow with API 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 API data in real time.
-
ETL Parquet in Oracle Data Integrator
This article shows how to transfer Parquet data into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange data for you.
-
Publish ShipEngine-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ShipEngine data.
-
Replicate Wrike Data from PowerShell
Write a quick PowerShell script to query Wrike data. Use connectivity to the live data to replicate Wrike data to SQL Server.
-
How to Access Front Data Using Entity Framework
This article shows how to access Front data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Excel Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Excel Online replication to Google Cloud SQL.
-
Visualize Live Oracle Financials Cloud Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Financials Cloud data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Zendesk Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zendesk replication to PostgreSQL.
-
Create Data Visualizations in Cognos BI with Perplexity Data
Access Perplexity data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Apps with Live Mailgun Data Using the Low-Code Development Platform of Mendix
Connect Mailgun data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous JSON Replication to Vertica
Use CData Sync for automated, continuous, customizable JSON replication to Vertica.
-
Integrating OpenCode with Anaplan 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.
-
Getting Started with the CData Tableau Connector for Intercom
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate xBase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live xBase data from Informatica Cloud.
-
Automated Continuous Box Replication to MySQL
Use CData Sync for automated, continuous, customizable Box replication to MySQL.
-
Build Pipelines with Live Spark Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Spark from Google Cloud Data Fusion, enabling the integration of live Spark data into the building and management of effective data pipelines.
-
How to Connect to Live Salesloft Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Salesloft data without replication.
-
Query eBay Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against eBay Analytics data from Node.js.
-
Build Visualizations of Google Sheets Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Sheets data in Birst.
-
Automated Continuous Auth0 Replication to Databricks
Use CData Sync for automated, continuous, customizable Auth0 replication to Databricks.
-
Use Dash to Build Web Apps on LinkedIn Data via CData Connect AI
Build interactive Dash web apps on live LinkedIn data using pandas and the CData Connect AI Python SDK.
-
Visualize Live Planio Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Planio data.
-
Build Data Flows from Dynamics CRM to SQL Server using SSIS
Easily back up Dynamics CRM data to SQL Server using the SSIS components for Dynamics CRM.
-
Build an OLAP Cube in SSAS from ClickTime Data
Establish a connection to ClickTime data data from SQL Server Analysis Services, and use the ClickTime Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Agno to Talk to Your Sage 200 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 Sage 200 data for you.
-
Replicate Multiple MessageBird Accounts
Replicate multiple MessageBird accounts to one or many databases.
-
Trigger CouchDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for CouchDB with standard wizards in Logic Apps.
-
Connect AdRoll to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AdRoll with IBM WebSphere for seamless data integration and connectivity.
-
Natively Connect to Teamwork Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Teamwork data. Leverage the native support for ODBC in PHP.
-
Integrate PolarTeamPro Data in Pentaho Data Integration
Build ETL pipelines based on PolarTeamPro data in the Pentaho Data Integration tool.
-
Build Data Flows from SQL Server to Redis through SSIS
Easily push SQL Server data to Redis using the CData SSIS Tasks for Redis.
-
Use the CData Software ODBC Driver for SendInBlue in MicroStrategy Desktop
Connect to SendInBlue data in MicroStrategy Desktop using the CData Software ODBC Driver for SendInBlue.
-
Access Live DB2 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live DB2 data from your Excel spreadsheets.
-
Prepare, Blend, and Analyze Workday Data in Alteryx Designer (ODBC)
Build workflows to access live Workday data for self-service data analytics.
-
Access Oracle SCM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle SCM data from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CampaignMonitor
Provide connectivity to CampaignMonitor data through an SAP BusinessObjects universe.
-
Seamlessly Bring Sybase IQ Data into Retool Using CData Connect AI
Integrate Sybase IQ data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build GitHub-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live GitHub data.
-
Automated Continuous Front Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Front replication to IBM DB2.
-
Integrate with Live QuickBooks Time Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to QuickBooks Time from the MuleSoft Anypoint Platform to integrate live QuickBooks Time data into custom reports and dashboards.
-
Publish Reports with Marketo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Marketo data.
-
Visualize Cvent Data in TIBCO Spotfire through ADO.NET
Integrate Cvent data into dashboards in TIBCO Spotfire.
-
Deploy the ADO.NET Provider for Lakebase on an SSRS Report Server
Connect to Lakebase data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous Mistral AI Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mistral AI replication to Apache Kafka.
-
How to use SQLAlchemy ORM to access Twitter Ads Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twitter Ads data.
-
Easily Integrate Email Data in Lazarus Pascal IDE
Learn how to easily integrate live Email data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access LinkedIn Data from MySQL in Amazon QuickSight
Connect to LinkedIn and build visualizations of LinkedIn data using a MySQL Connection in Amazon QuickSight.
-
Provide OData Services of Drip Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Drip data by developing a WCF Service Application.
-
How to Work with Zoho Creator Data in AWS Glue Jobs Using JDBC
Connect to Zoho Creator from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating GitHub Copilot with JobNimbus 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.
-
Getting Started with the CData Power BI Connector for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Facebook Ads.
-
Integrating Gumloop with OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on OneNote data within automated workflows.
-
How to integrate Metabase with Teradata Data
Use CData Connect AI to connect to live Teradata data and create an interactive dashboard in Metabase from Teradata data.
-
Connect to Live Azure DevOps Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Azure DevOps in CData Connect AI and connect to your Azure DevOps data from PostgreSQL.