CData Software - Knowledge Base
Recent Articles
-
Connect to Odoo Data from PowerBuilder via JDBC
This article demonstrates how to access Odoo data from PowerBuilder using the Odoo JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Aha!
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze PolarTeamPro Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PolarTeamPro data with the CData JDBC Driver for PolarTeamPro.
-
Build AI/ML Models with Live Bitly Data using Dataiku
Connect Bitly Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Claude Code with Google Campaign Manager 360 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Campaign Manager 360 data within assisted coding and automated development workflows.
-
Automated Continuous ChartMogul Replication to Databricks
Use CData Sync for automated, continuous, customizable ChartMogul replication to Databricks.
-
Manage Onfleet Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Onfleet.
-
Use JayDeBeApi to access Microsoft Entra ID Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Entra ID data.
-
How to Create Power BI Visual Reports with Real-Time Tally Data
Use CData Power BI Connectors to visualize Tally data in Power BI.
-
How to Connect to Live LinkedIn 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 LinkedIn data for you.
-
Model Microsoft Entra ID Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Entra ID, enabling the direct import of real-time Microsoft Entra ID data.
-
How to Access Live Zoho Books Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Books enables you to integrate Zoho Books data into workflows built using Microsoft Power Automate Desktop.
-
Connect to GetResponse 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 GetResponse and work with GetResponse data in your FileMaker application.
-
Visualize Live Demio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Demio data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Azure Analysis Services Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Analysis Services data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Publish Crystal Reports on Factorial Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Factorial data.
-
Sage Intacct Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage Intacct facts in real time.
-
How to connect Amazon QuickSight to Tally Data
Create a connection to Tally data in CData Connect AI and insert Tally data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build ADP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ADP data and build web apps with connectivity to live ADP data.
-
Automated Continuous Oracle Eloqua Reporting Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to SQL Server.
-
Use the CData Software ODBC Driver for Act CRM in MicroStrategy Desktop
Connect to Act CRM data in MicroStrategy Desktop using the CData Software ODBC Driver for Act CRM.
-
Import Real-Time ChargeOver Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ChargeOver data in ColdFusion.
-
Automated Continuous Splunk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Splunk replication to AlloyDB.
-
Migrating data from Square to Databricks using CData SSIS Components.
Easily push Square data to Databricks using the CData SSIS Tasks for Square and Databricks.
-
Connect to Jira Assets Data in DBArtisan
Use wizards in DBArtisan to configure Jira Assets data as a data source.
-
Use the CData Software JDBC Driver for Google Spanner in MicroStrategy
Connect to Google Spanner data in MicroStrategy Developer using the CData Software JDBC Driver for Google Spanner.
-
Automate Adobe Commerce Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Commerce data replication to Couchbase.
-
How to connect to Microsoft Ads Data with Squirrel SQL client
Connect to Microsoft Ads data and execute queries in the Squirrel SQL Client.
-
Operational Reporting on Gmail Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Gmail data.
-
Interact with Live MailChimp Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live MailChimp data.
-
Automate SAP BusinessObjects BI Data Replication to SAP HANA
Use CData Sync to customize and automate SAP BusinessObjects BI data replication to SAP HANA.
-
Choosing the Best Method to Connect Customer.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Customer.io data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Pipelines with Live Bitbucket Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Bitbucket from Google Cloud Data Fusion, enabling the integration of live Bitbucket data into the building and management of effective data pipelines.
-
Build Visualizations of CockroachDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CockroachDB data in Birst.
-
Build ADP-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ADP data.
-
How to Connect to & Open CapsuleCRM Data in Microsoft Excel
This article uses the CData ODBC driver for CapsuleCRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Todoist Data in Pentaho Data Integration
Build ETL pipelines based on Todoist data in the Pentaho Data Integration tool.
-
Connect and Query Live Impala Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Impala data into Databricks and enable direct, live querying and analysis without replication.
-
Query Live Sage Cloud Accounting Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Sage Cloud Accounting data through a conversational interface.
-
Build Pipelines with Live CockroachDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to CockroachDB from Google Cloud Data Fusion, enabling the integration of live CockroachDB data into the building and management of effective data pipelines.
-
Query SAP ByDesign Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP ByDesign data.
-
Automated Continuous Discourse Replication to Snowflake
Use CData Sync for automated, continuous, customizable Discourse replication to Snowflake.
-
Getting Started with the CData Python Connector for FTP
Learn to install and license the CData Python Connector and configure a connection to live FTP data.
-
How to Create Power BI Visual Reports with Real-Time Facebook Ads Data
Use CData Power BI Connectors to visualize Facebook Ads data in Power BI.
-
Integrating OpenWeatherMap Data in Talend Cloud Data Management Platform
Connect OpenWeatherMap Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Enable the Paylocity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Paylocity data.
-
Use the CData Software JDBC Driver for Google Search in MicroStrategy Web
Connect to Google Search results in MicroStrategy Web using the CData Software JDBC Driver for Google Search.
-
Getting Started with the CData Excel Add-In for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Epicor Kinetic.
-
Connect to Amazon Athena Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Amazon Athena Data and connect to Amazon Athena data in Akorbi Digital RunMyProcess.
-
How to Connect to Live Adobe Experience Manager 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 Adobe Experience Manager data for you.
-
Connect and Query Live Supabase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Supabase data into Databricks and enable direct, live querying and analysis without replication.
-
Instantly Reporting in OBIEE with the Instantly JDBC Driver
Deploy the Instantly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate SendPulse Data in the Pentaho Report Designer
Publish reports based on SendPulse data in the Pentaho BI tool.
-
Access Retently Data from MySQL in Amazon QuickSight
Connect to Retently and build visualizations of Retently data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Paddle Replication to SQLite
Use CData Sync for automated, continuous, customizable Paddle replication to SQLite.
-
How to create Visio diagrams from Dropbox Data
Automatically update Dropbox data with the changes you make to Visio master shapes.
-
Create Data Visualizations Based On SAP Hybris C4C Data in Mode
Use CData Connect AI to connect to SAP Hybris C4C Data from Mode and build visualizations using live SAP Hybris C4C data.
-
Replicate Multiple Unbounce Accounts via the CData Sync CLI
Replicate multiple Unbounce accounts to one or many databases.
-
Connect to Placid Data from a Connection Pool in JBoss
Integrate Placid data into Java servlets: Use the Management Console in JBoss to install the Placid JDBC Driver.
-
Integrate with Zuora Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zuora data to a JSON file on disk.
-
Create Datasets from Microsoft Planner in Domo Workbench and Build Visualizations of Microsoft Planner Data in Domo
Use the CData Software ODBC Driver for Microsoft Planner to create datasets from Microsoft Planner data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Gumloop with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on FreshBooks data within automated workflows.
-
Getting Started with the CData JDBC Driver for Opsgenie
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Opsgenie.
-
Connect to HCL Domino Data in RapidMiner
Integrate HCL Domino data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Cursor with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Spark data from within the editor.
-
Replicate Multiple Adobe Commerce Accounts via the CData Sync CLI
Replicate multiple Adobe Commerce accounts to one or many databases.
-
Automated Continuous Stack Exchange Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Apache Cassandra.
-
Integrating Antigravity CLI with QuickBooks Online data via CData CLI
Connect QuickBooks Online data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live Pingdom Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pingdom data into the statistical analysis tools available in SAS JMP. This article shows how to use Pingdom data in the Graph Builder and Query Builder.
-
Build Pipeline CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Pipeline CRM data and build web apps with connectivity to live Pipeline CRM data.
-
Connect to Dynamics 365 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Dynamics 365 data.
-
Integrate Devin with Live PayPal Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live PayPal data.
-
Use the CData Software ODBC Driver for Oracle in MicroStrategy Desktop
Connect to Oracle data in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle.
-
Use the CData Software ODBC Driver for Webex in SAS for Real-Time Reporting and Analytics
Connect to real-time Webex data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Webex.
-
Analyze Azure Data Lake Storage Data in Cognos Analytics
Use CData Connect AI to connect to Azure Data Lake Storage Data from Cognos Analytics and analyze live Azure Data Lake Storage data.
-
Connect to Marketo Data in ACL Analytics
Connect to Marketo data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Marketo data.
-
Migrating data from Autopilot to Google BigQuery using CData SSIS Components.
Easily push Autopilot data to Google BigQuery using the CData SSIS Tasks for Autopilot and Google BigQuery.
-
Integrate OpenCode with Live IBM Informix Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live IBM Informix data from within your AI coding agent.
-
Query ZohoPeople Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoPeople data.
-
Integrating Boomi Agentstudio with Grafana Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Grafana data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous MailerLite Replication to SQLite
Use CData Sync for automated, continuous, customizable MailerLite replication to SQLite.
-
Connect LDAP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LDAP objects using the CData Python MCP Server.
-
How to connect to Oracle HCM Cloud Data in DBVisualizer
Integrate Oracle HCM Cloud data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Cline with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Pipedrive data from within your IDE.
-
Integrate LibreChat with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live eBay data from within the chat interface.
-
How to Access Live Act CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Act CRM enables you to integrate Act CRM data into workflows built using Microsoft Power Automate Desktop.
-
Connect to ScrapingBee Data in HULFT Integrate
Connect to ScrapingBee as a JDBC data source in HULFT Integrate
-
Connect to MailChimp Data in RazorSQL
Connect to MailChimp from wizards and query MailChimp data from the GUI in the RazorSQL database management tool.
-
Create Reports with OpenWeatherMap Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OpenWeatherMap data.
-
How to integrate Highrise with Apache Airflow
Access and process Highrise data in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for BigCommerce in MicroStrategy
Connect to BigCommerce data in MicroStrategy Developer using the CData Software JDBC Driver for BigCommerce.
-
Access Live Splunk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Splunk data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated PabblySubscriptions Data Replication to Teradata
Use CData Sync to Customize and automate PabblySubscriptions data replication to Teradata.
-
Create Power BI Reports on Real-Time Azure Table Data
Use the CData ODBC Driver for Azure Table to visualize Azure Table data in Power BI Desktop.
-
Getting Started with the CData JDBC Driver for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics 365 Business Central.
-
Connect to EmailOctopus Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for EmailOctopus data.
-
Build Apps with Live Kintone Data Using the Low-Code Development Platform of Mendix
Connect Kintone data with Mendix to build apps using the CData JDBC Driver for Kintone.
-
Create Greenplum-Connected Applications in Appsmith
Connect to Greenplum Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Greenplum data.
-
LINQ to HDFS Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the HDFS Data Provider.
-
Visualize Outreach.io 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 Outreach.io data into TIBCO Spotfire.