CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Deel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Deel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time Templated Data
Use the CData ODBC Driver for Templated to visualize Templated in Power BI Desktop.
-
How to Connect the Power BI Service to Couchbase: Complete Guide
Connect to the CData Software Power BI Connector for Couchbase from PowerBI.com to provide real-time Couchbase across the organization.
-
How to connect to Google Spanner Data in DBVisualizer
Integrate Google Spanner with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Pipeliner CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate QuickBooks Online Data Replication to Azure Synapse
Use CData Sync to customize and automate QuickBooks Online replication to Azure Synapse.
-
Import and Visualize Microsoft OneDrive Data in Power View
Create data visualizations based on Microsoft OneDrive in Excel.
-
Create Dashboards and Visualize Live Oracle SCM Data in Geckoboard
Use CData Connect AI to connect to live Oracle SCM and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Kiro CLI with QuickBooks 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for AdRoll
Provide connectivity to AdRoll through an SAP BusinessObjects universe.
-
Automated Continuous Greenhouse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Greenhouse replication to delimited files (CSV/TSV).
-
How to integrate Samanage with Apache Airflow
Access and process Samanage in Apache Airflow using the CData JDBC Driver.
-
Connect to Zoho CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoho CRM in Airbyte.
-
How to publish and share ActiveCampaign Data dashboards with Tableau Server
The CData ODBC driver for ActiveCampaign enables you integrate ActiveCampaign into Tableau dashboards.
-
How to Connect to Live Greenhouse 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 Greenhouse for you.
-
How to Query Live Salesforce Data 360 Data in Claude Desktop
Connect to and query live Salesforce Data 360 Data in Claude Desktop using CData MCP Server.
-
Use Dash to Build Web Apps on SharePoint Data via CData Connect AI
Build interactive Dash web apps on live Microsoft SharePoint using pandas and the CData Connect AI Python SDK.
-
Design BIRT Reports on Calendly Data
Provide current Calendly to your embedded analytics.
-
Connect to Oracle Sales Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Sales to connect to Oracle Sales and execute queries in PowerBuilder.
-
Rapidly Develop Sendwithus-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Sendwithus.
-
Build a PostgreSQL Interface for SAP SuccessFactors Data using the CData JDBC Driver
Use the Remoting features of the SAP SuccessFactors JDBC Driver to create a PostgreSQL entry-point for data access.
-
Explore Geographical Relationships in Tanda Data with Power Map
Create data visualizations with Tanda in Power Map.
-
Use the CData ODBC Driver for Oracle Service Cloud from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Service Cloud to connect to Oracle Service Cloud from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Service Cloud in Excel.
-
How to Connect to MariaDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MariaDB. Leverage the pyodbc module for ODBC in Python.
-
Integrate Open WebUI with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Snapchat Ads from within the chat interface.
-
Connecting Pipedream with Hive 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 Hive data in real time.
-
Integrating OpenCode Terminal with Xero 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 ODBC Driver for Act CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Act CRM.
-
Connect to Sage 200 Data in Google Apps Script via Connect AI
Use CData Connect AI to access Sage 200 in Google Apps Script.
-
How to connect and process SendInBlue from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SendInBlue.
-
How to Connect Flowise AI Agents to Live Twitter Ads 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 Twitter Ads without replication.
-
Automated Continuous Excel Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Excel replication to OneLake in Microsoft Fabric.
-
Automated Continuous Cassandra Replication to MySQL
Use CData Sync for automated, continuous, customizable Cassandra replication to MySQL.
-
Apollo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Apollo facts in real time.
-
DataBind Charts to EnterpriseDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to EnterpriseDB 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.
-
Create Power BI Reports on Real-Time Facebook Ads Data
Use the CData ODBC Driver for Facebook Ads to visualize Facebook Ads in Power BI Desktop.
-
Use the CData Software ODBC Driver for Google Forms in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Forms in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Forms.
-
Integrating Codex CLI with Google Spanner 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.
-
Use the CData Software JDBC Driver for Klipfolio in MicroStrategy
Connect to Klipfolio in MicroStrategy Developer using the CData Software JDBC Driver for Klipfolio.
-
How to connect and process Shippo from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Shippo.
-
Connect and Query Live Zoho Books Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoho Books into Databricks
-
Build a Singer.io Tap for Mailgun With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mailgun data using
-
Automate SpaceX Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SpaceX from PowerShell? This article demonstrates how to utilize the SpaceX Cmdlets for tasks like connecting to SpaceX, automating operations, downloading data, and more.
-
How to publish and share LinkedIn Data dashboards with Tableau Server
The CData ODBC driver for LinkedIn enables you integrate LinkedIn into Tableau dashboards.
-
Use Dash to Build Web Apps on Twitter Ads Data via CData Connect AI
Build interactive Dash web apps on live Twitter Ads using pandas and the CData Connect AI Python SDK.
-
How to integrate Metabase with Zendesk Data
Use CData Connect AI to connect to live Zendesk and create an interactive dashboard in Metabase from Zendesk.
-
Analyze Tanda Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Tanda in Microsoft R Open.
-
Use the CData Software JDBC Driver for Eventbrite in MicroStrategy Desktop
Connect to Eventbrite in MicroStrategy Desktop using the CData Software JDBC Driver for Eventbrite.
-
Analyze Airtable Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Airtable with the CData JDBC Driver for Airtable.
-
Analyze SAP BusinessObjects BI Data in Looker
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Looker and build custom apps using live SAP BusinessObjects BI.
-
Integrate Open WebUI with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Databricks from within the chat interface.
-
Access Live Lakebase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Lakebase from your Excel spreadsheets.
-
Analyze Shortcut Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Shortcut in Microsoft R Open.
-
Create Paylocity-Connected Applications in Appsmith
Connect to Paylocity Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Paylocity.
-
Migrating data from Templated to Databricks using CData SSIS Components.
Easily push Templated to Databricks using the CData SSIS Tasks for Templated and Databricks.
-
How to use SQLAlchemy ORM to access Workable Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Workable.
-
Automate Redis Data Replication to Couchbase
Use CData Sync to Customize and automate Redis replication to Couchbase.
-
How to Access Live Salesforce Pardot Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesforce Pardot enables you to integrate Salesforce Pardot into workflows built using Microsoft Power Automate Desktop.
-
Consume Email OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Email feeds that reflect any changes in SAP Lumira.
-
Use Manus AI to Talk to Your Microsoft Ads 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 Microsoft Ads.
-
A PostgreSQL Interface for GetResponse Data using the CData ODBC Driver
Use the SQL Gateway and GetResponse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query ChartMogul Data in QlikView over ODBC
Create data visualizations with ChartMogul in QlikView.
-
Connect to and Visualize Live QuickBooks Online Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live QuickBooks Online.
-
Connecting Mastra with PostgreSQL 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 PostgreSQL, no replication required.
-
Automated Continuous Redis Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Redis replication to Azure SQL Database.
-
How to import Rootly Data into Apache Solr
Use the CData Software JDBC Driver for Rootly in Data Import Handler and create an automated import of Rootly to Apache Solr Enterprise Search platform.
-
Connect to Bullhorn CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Bullhorn CRM as an External Source in Dremio.
-
Build Jira-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Atlassian Jira and build Jira-connected web apps with Axios.
-
Visualize Live Shopify Data in the Power BI Service
Use CData Connect AI to connect to live Shopify and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to WordPress Data in DBVisualizer
Integrate WordPress with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Nuclia Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Nuclia from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Microsoft Planner Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Planner data access from reports, embedded analytics, and more.
-
Build ElevenLabs-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ElevenLabs.
-
Feed Wrike Data into FineReport
How to set Wrike as a JDBC data source in FineReport.
-
Access Live Pipedrive Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Pipedrive from your Excel spreadsheets.
-
Analyze FTP Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of FTP Servers and visualize FTP Servers in SAP Analytics Cloud.
-
Excel Spreadsheet Automation on Copper Data with the QUERY Formula
Pull data from Copper, automate spreadsheets, and more with the QUERY formula.
-
Use Grok to Talk to Your Exact Online 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 Exact Online for you.
-
Build Zoho Inventory Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Inventory and build visualizations in Tableau.
-
Build Charts with RabbitMQ Data in Clear Analytics
Create dynamic charts and perform analytics based on RabbitMQ in Clear Analytics.
-
Back Up Hugging Face 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 Hugging Face data.
-
Connect to Google Spanner from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Spanner to connect to Google Spanner from Web applications running on WebLogic.
-
Import Real-Time Elorus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Elorus in ColdFusion.
-
Access SAP ByDesign 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 SAP Business ByDesign.
-
Visualize Azure Data Catalog Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Data Catalog.
-
How to update YouTube Analytics from Excel
This article explains how to transfer data from Excel to YouTube Analytics using the Excel Add-In for YouTube Analytics.
-
Build SAP Ariba Procurement-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP Ariba Procurement Data from Zoho Analytics and import live SAP Ariba Procurement.
-
Build MVC Applications with Connectivity to Timely Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Timely from an ASP.NET MVC application.
-
Extract, Transform, and Load Perplexity Data in Informatica PowerCenter
Create a simple Workflow for Perplexity in Informatica PowerCenter.
-
Integrating Claude Code CLI with Oracle 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.
-
How to create an RPA flow for Opsgenie Data in UiPath Studio
Use the Opsgenie ODBC Driver to create workflows that access real-time Opsgenie without any coding.
-
Connect to and Query Clari Data in QlikView over ODBC
Create data visualizations with Clari in QlikView.
-
Automate Azure DevOps Data Replication to SAP HANA
Use CData Sync to customize and automate Azure DevOps replication to SAP HANA.
-
Replicate Multiple Codat Accounts
Replicate multiple Codat accounts to one or many databases.
-
How to Access Live Reckon Data in Visual Studio Code via Cline
Run CData MCP Server for Reckon on Windows Subsytem for Linux (WSL) and connect to live Reckon from the Cline extension in Visual Studio Code.
-
Visualize Couchbase Data in Sisense
Create an ElastiCube in Sisense app with access to Couchbase.
-
Build Pipelines with Live Power BI XMLA Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Power BI XMLA from Google Cloud Data Fusion, enabling the integration of live Power BI XMLA into the building and management of effective data pipelines.
-
Automate Office 365 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Office 365 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect and process ZeroBounce from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZeroBounce.
-
Analyze Live Slack Data in SAS Viya
Use CData Connect AI to connect to Slack from SAS Viya and deploy self-service analytics using live Slack.