CData Software - Knowledge Base
Recent Articles
-
Create Power BI Reports on Real-Time Greenplum Data
Use the CData ODBC Driver for Greenplum to visualize Greenplum data in Power BI Desktop.
-
Query PhantomBuster Data as a MySQL Database in Node.js
Execute MySQL queries against PhantomBuster data from Node.js.
-
Integrating LlamaIndex with SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SingleStore data in real time.
-
Analyze SuiteCRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SuiteCRM data and visualize SuiteCRM data in SAP Analytics Cloud.
-
Connect and Visualize Live Snowflake Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Snowflake data into the Databricks platform and create visualization dashboards with real-time Snowflake data.
-
Integrating Dataiku with API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live API data.
-
Publish QuickBooks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live QuickBooks data.
-
DataBind Foursquare Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Foursquare data to a chart.
-
Publish Dynamics CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dynamics CRM data.
-
Integrate Google Tasks Data in Pentaho Data Integration
Build ETL pipelines based on Google Tasks data in the Pentaho Data Integration tool.
-
Connect to Confluence Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Confluence data.
-
Automated Continuous Facebook Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Oracle.
-
Automated Continuous Perigon Replication to Databricks
Use CData Sync for automated, continuous, customizable Perigon replication to Databricks.
-
Connect to Dynamics CRM Data in NetBeans
Connect to Dynamics CRM data in NetBeans with the data source configuration wizard.
-
Create Azure Table-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Table Data from OutSystems and build custom enterprise apps using live Azure Table data.
-
How to import Webflow Data into Apache Solr
Use the CData Software JDBC Driver for Webflow in Data Import Handler and create an automated import of Webflow data to Apache Solr Enterprise Search platform.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Databricks
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Databricks.
-
Access MailChimp 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 MailChimp data.
-
Use CData Connect AI to Access GraphQL Data in Microsoft Power Pivot
Use CData Connect AI to connect to live GraphQL data in the Power Pivot business intelligence tool.
-
Query GitHub Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GitHub data from Node.js.
-
Connect to SAP Fieldglass Data from a Connection Pool in JBoss
Integrate SAP Fieldglass data into Java servlets: Use the Management Console in JBoss to install the SAP Fieldglass JDBC Driver.
-
Explore Geographical Relationships in Attio Data with Power Map
Create data visualizations with Attio data in Power Map.
-
Automated Continuous VWO Replication to Databricks
Use CData Sync for automated, continuous, customizable VWO replication to Databricks.
-
A PostgreSQL Interface for Okta Data using the CData ODBC Driver
Use the SQL Gateway and Okta ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live SuiteCRM Data in Excel 365 Online (Excel for the web)
Connect to SuiteCRM data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Jira Data in Ruby
Connect to Jira data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to SAP HANA XS Advanced Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP HANA XS Advanced data from HeidiSQL.
-
Visualize Microsoft Entra ID 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 Microsoft Entra ID data into TIBCO Spotfire.
-
DataBind PingOne Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for PingOne with the DevExpress Windows Forms and Web controls to provide PingOne data to a chart.
-
Create Data Visualizations in Cognos BI with ChargeOver Data
Access ChargeOver data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to integrate Anaplan with Apache Airflow
Access and process Anaplan data in Apache Airflow using the CData JDBC Driver.
-
Build Google Contacts-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Contacts data and build web apps with connectivity to live Google Contacts data.
-
Visualize Live Nethunt Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Nethunt data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate IBM Informix Data Replication to Azure Data Lake
Use CData Sync to customize and automate IBM Informix data replication to Azure Data Lake.
-
Access Live Pinterest Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Pinterest data through MCP integration.
-
Integrating LangGraph with ActiveCampaign Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ActiveCampaign data within automated workflows.
-
Stream Oracle Sales Data into Apache Kafka Topics
Access and stream Oracle Sales data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Everhour Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Everhour replication to Google Cloud SQL.
-
Use the CData Software ODBC Driver for Cosmos DB in MicroStrategy Web
Connect to Cosmos DB data in MicroStrategy Web using the CData Software ODBC Driver for Cosmos DB.
-
Integrate Cursor with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Financials Cloud data from within the editor.
-
Connect to LinkedIn Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LinkedIn and the SQL Gateway to access LinkedIn data from Google Apps Script.
-
Integrating Claude Code CLI with Cassandra 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.
-
LINQ to Gmail 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 Gmail Data Provider.
-
Integrating LangChain with Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Reckon data within automated workflows.
-
Integrate LibreChat with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Email data from within the chat interface.
-
Use the CData ODBC Driver for FHIR in Microsoft Power Query
You can use the CData FHIR ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FHIR data into Microsoft Power Query.
-
Create SSAS Tabular Models from Planio Data
How to build a SQL Server Analysis Service Tabular Model from Planio data using CData drivers.
-
Connect to Exact Online Data from HeidiSQL
Use CData Connect AI to connect to and query live Exact Online data from HeidiSQL.
-
Publish Reports with Office 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Office 365 data.
-
How to integrate Testmonitor with Apache Airflow
Access and process Testmonitor data in Apache Airflow using the CData JDBC Driver.
-
Access Act CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Act CRM data from HeidiSQL.
-
Integrate with Act-On Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Act-On data to a JSON file on disk.
-
How to connect to XML Data in DBVisualizer
Integrate XML data with visual data analysis tools and data connection wizards in DBVisualizer
-
Migrating data from Codat to Databricks using CData SSIS Components.
Easily push Codat data to Databricks using the CData SSIS Tasks for Codat and Databricks.
-
Choosing the Best Method to Connect ADP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ADP data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect and process Sage Cloud Accounting data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sage Cloud Accounting data.
-
How to Connect Supabase Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Supabase data in real time using natural language.
-
How to Connect to FreeAgent Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FreeAgent data. Leverage the pyodbc module for ODBC in Python.
-
Extract, Transform, and Load FTP Data in Informatica PowerCenter
Create a simple Workflow for FTP data in Informatica PowerCenter.
-
Access Live Xero Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Xero data from your Excel spreadsheets.
-
Integrate Excel Online Data into Power Automate Desktop using CData Connect
CData Connect for Excel Online Data enables you to integrate Excel Online data into workflows built using Microsoft Power Automate Desktop.
-
Process & Analyze ShipStation Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ShipStation Data.
-
Access Live Vertica Data in Excel 365 Online (Excel for the web)
Connect to Vertica data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use Agno to Talk to Your Kintone 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 Kintone data for you.
-
Connect to Samanage from a Connection Pool in WebLogic
Use the CData JDBC Driver for Samanage to connect to Samanage data from Web applications running on WebLogic.
-
Integrate with Close Data in JReport Designer
Create charts and reports based on Close data in JReport Designer.
-
Create Sage Cloud Accounting Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sage Cloud Accounting data access from reports, embedded analytics, and more.
-
Seamlessly Bring Zuora Data into Retool Using CData Connect AI
Integrate Zuora data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate Wave Financial Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Wave Financial data from PowerShell? This article demonstrates how to utilize the Wave Financial Cmdlets for tasks like connecting to Wave Financial data, automating operations, downloading data, and more.
-
Analyze Twitter Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Twitter Ads data and visualize live Twitter Ads data in Infragistics Reveal.
-
How to integrate SAP HANA XS Advanced with Apache Airflow
Access and process SAP HANA XS Advanced data in Apache Airflow using the CData JDBC Driver.
-
Build Data Flows from Moosend to SQL Server using SSIS
Easily back up Moosend data to SQL Server using the SSIS components for Moosend.
-
Integrate Active Directory Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Active Directory data from Informatica Cloud.
-
Integrating Codex with OData services 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 Connect to & Open Coda Data in Microsoft Excel
This article uses the CData ODBC driver for Coda to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Visualize Nuclia Data in Python with pandas
Use pandas and other modules to analyze and visualize live Nuclia data in Python.
-
Connect to Todoist Data in RapidMiner
Integrate Todoist data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Live Salesforce Data 360 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce Data 360 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce Data 360 data.
-
Connect to and Query Aircall Data in QlikView over ODBC
Create data visualizations with Aircall data in QlikView.
-
Connect to Act CRM Data in Ruby
Connect to Act CRM data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData Connect AI Python SDK for Paylocity
Install the CData Connect AI Python SDK to read and write live Paylocity data with standard DB-API 2.0 Python code.
-
Automate Blackbaud FE NXT Data Replication to Azure Data Lake
Use CData Sync to customize and automate Blackbaud FE NXT data replication to Azure Data Lake.
-
Build Marketo-Connected Apps in Choreo
Use CData Connect AI to connect to Marketo Data from Choreo and build custom apps using live Marketo data.
-
Use the CData Software ODBC Driver for Smartsheet in MicroStrategy Web
Connect to Smartsheet data in MicroStrategy Web using the CData Software ODBC Driver for Smartsheet.
-
Build Automated Workflows with Live Dynamics CRM Data in Workato
Use CData Connect AI to connect to live Dynamics CRM data and build automated workflows in Workato.
-
A PostgreSQL Interface for SuiteCRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the SuiteCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Adobe Analytics-Connected Dashboards in Grafana
Connect to Adobe Analytics Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Adobe Analytics data.
-
Provide OData Services of JobNimbus Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for JobNimbus data by developing a WCF Service Application.
-
Use Dash to Build to Web Apps on Discourse Data
Create Python applications that use pandas and Dash to build Discourse-connected web apps.
-
How to connect to Coda Data from IntelliJ
Integrate connectivity to Coda data with wizards in IntelliJ.
-
Connect Todoist to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Todoist with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Gong in MicroStrategy Desktop
Connect to Gong data in MicroStrategy Desktop using the CData Software ODBC Driver for Gong.
-
Integrating GitHub Copilot with Amazon S3 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.
-
Connect to ZendeskSell Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZendeskSell data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Validate Mode Data with QuerySurge
Access and validate Mode data in QuerySurge using the CData JDBC Driver.
-
Query, Visualize, and Share live Azure DevOps Data in Redash
Use CData Connect AI to connect to live Azure DevOps data in Redash for querying, visualizing, and sharing.
-
Stream Printify Data into Apache Kafka Topics
Access and stream Printify data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Charts with Recurly Data in Clear Analytics
Create dynamic charts and perform analytics based on Recurly data in Clear Analytics.
-
Integrating Claude Code CLI with Bright Data 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 Dashboards and Visualize Live Bitbucket Data in Geckoboard
Use CData Connect AI to connect to live Bitbucket data and create dashboards for real-time monitoring and visualization in Geckoboard.