CData Software - Knowledge Base
Recent Articles
-
Visualize Sybase 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 Sybase data into TIBCO Spotfire.
-
How to Visualize Reckon Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Reckon data in Python.
-
Connect to Slack Data from PowerBuilder via ADO.NET
This article demonstrates how to access Slack data from Appeon PowerBuilder using the CData ADO.NET Provider for Slack.
-
Getting Started with the CData Python Connector for Smartsheet
Learn to install and license the CData Python Connector and configure a connection to live Smartsheet data.
-
LINQ to BenchmarkEmail 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 BenchmarkEmail Data Provider.
-
Automated Continuous Teradata Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Teradata replication to IBM DB2.
-
How to Connect to & Open Postmark Data in Microsoft Excel
This article uses the CData ODBC driver for Postmark to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to work with Harvest Data in Apache Spark using SQL
Access and process Harvest Data in Apache Spark using the CData Software JDBC Driver.
-
DataBind Snapchat Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Snapchat Ads with the DevExpress Windows Forms and Web controls to provide Snapchat Ads data to a chart.
-
How to connect SharePoint with Cosmos DB Data through external lists
Provide Cosmos DB data to SharePoint users as an external list.
-
Build Agents in Relevance AI with Access to Live Adobe Target Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Adobe Target data within intelligent agent workflows.
-
Getting Started with the CData Python Connector for CircleCI
Learn to install and license the CData Python Connector and configure a connection to live CircleCI data.
-
Consume Dropbox OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dropbox feeds that reflect any changes in SAP Lumira.
-
Access Live IBM Informix 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 IBM Informix data through MCP integration.
-
Create Power BI Reports on Real-Time BigQuery Data
Use the CData ODBC Driver for BigQuery to visualize BigQuery data in Power BI Desktop.
-
Visualize Accelo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Accelo data.
-
Query Sendwithus Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sendwithus data from Node.js.
-
Integrate LibreChat with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cosmos DB data from within the chat interface.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HDFS
Provide connectivity to HDFS data through an SAP BusinessObjects universe.
-
DataBind Jira Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Jira with the DevExpress Windows Forms and Web controls to provide Jira data to a chart.
-
Model, Search, and Visualize Live Zoho CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Zoho CRM data for modeling, searching, and visualizing.
-
Connect to CampaignMonitor Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to CampaignMonitor.
-
Automated Continuous Adobe Commerce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Amazon S3.
-
Automated Continuous IBM Cloud Object Storage Replication to Vertica
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Vertica.
-
How to create Dotmailer federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Dotmailer data in MySQL .
-
Build Dashboards with Cosmos DB Data in Dundas BI
Create dynamic dashboards and perform analytics based on Cosmos DB data in Dundas BI.
-
Design BIRT Reports on Beeminder Data
Provide current Beeminder data to your embedded analytics.
-
Migrating data from Blackbaud FE NXT to Databricks using CData SSIS Components.
Easily push Blackbaud FE NXT data to Databricks using the CData SSIS Tasks for Blackbaud FE NXT and Databricks.
-
Integrate OpenCode with Live Coda Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Coda data from within your AI coding agent.
-
Integrate Microsoft Ads Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Ads data in the Pentaho Data Integration tool.
-
How to Seamlessly Import Bitbucket Data into IBM SPSS Modeler
Integrate Bitbucket data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Explore Geographical Relationships in Greenplum Data with Power Map
Create data visualizations with Greenplum data in Power Map.
-
Getting Started with the CData SSIS Components for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Authorize.Net.
-
Analyze QuickBooks Online Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze QuickBooks Online data with the CData JDBC Driver for QuickBooks Online.
-
Import Real-Time Pipeline CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pipeline CRM data in ColdFusion.
-
How to Visualize Shopify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Shopify data in Python.
-
Build Apps with Live Power BI XMLA Data Using the Low-Code Development Platform of Mendix
Connect Power BI XMLA data with Mendix to build apps using the CData JDBC Driver for Power BI XMLA.
-
Access Live Zendesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zendesk data into the statistical analysis tools available in SAS JMP. This article shows how to use Zendesk data in the Graph Builder and Query Builder.
-
Integrating Dataiku with Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sybase IQ data.
-
Build Charts with FreshBooks Data in Clear Analytics
Create dynamic charts and perform analytics based on FreshBooks data in Clear Analytics.
-
Create Greenplum-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Greenplum Data from Klipfolio and build custom visualizations using live Greenplum data.
-
Use the CData Software JDBC Driver for Missive in MicroStrategy
Connect to Missive data in MicroStrategy Developer using the CData Software JDBC Driver for Missive.
-
Publish Crystal Reports on Exact Online Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exact Online data.
-
Automate Harvest Data Replication to Azure Data Lake
Use CData Sync to customize and automate Harvest data replication to Azure Data Lake.
-
Connecting Pipedream with Elasticsearch 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 Elasticsearch data in real time.
-
Connect to Live Microsoft Entra ID Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Entra ID Data in CData Connect AI and connect to your Microsoft Entra ID data from MicroStrategy.
-
Use ChatGPT to Talk to Your Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Lakebase data for you.
-
How to Work with SAP Ariba Source Data in ETL Validator JDBC
Connect to SAP Ariba Source from ETL Validator jobs using the CData Software JDBC Driver.
-
Write a Simple Go Application to work with Cvent Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cvent data.
-
Integrating Gumloop with Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Azure Data Catalog data within automated workflows.
-
How to Query Teamwork Data in MySQL Workbench
Execute MySQL queries against live Teamwork data from MySQL Workbench.
-
Build Dashboards with AdRoll Data in DBxtra
Create dynamic dashboards and perform analytics based on AdRoll data in DBxtra.
-
Use the CData ODBC Driver for Trello in Microsoft Power Query
You can use the CData Trello ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Trello data into Microsoft Power Query.
-
How to Connect to & Open LinkedIn Data in Microsoft Excel
This article uses the CData ODBC driver for LinkedIn to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Power BI Connector for Jira Assets
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Jira Assets.
-
Integrating OpenCode with IBM Informix 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.
-
Natively Connect to Intercom Data in PHP
The CData ODBC driver for Intercom enables you to create PHP applications with connectivity to Intercom data. Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To a JDBC Data Source for Anaplan
Create Anaplan data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Process & Analyze Sentry Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sentry Data.
-
How to Query Gong Data in MySQL Workbench
Execute MySQL queries against live Gong data from MySQL Workbench.
-
Connect to JSON Services in ACL Analytics
Connect to JSON services via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to JSON services.
-
Connect to PabblySubscriptions Data in JRuby
Create a simple JRuby app with access to live PabblySubscriptions data.
-
Connecting GenSpark with Cloudflare Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Cloudflare data without any replication or custom integration required.
-
Stream Amazon Athena Data into Apache Kafka Topics
Access and stream Amazon Athena data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
View Reports on Real-Time ZendeskSell Data in Power BI Report Server
Use the CData ODBC Driver for ZendeskSell to visualize ZendeskSell data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Harvest Data in DataGrip
Create a Data Source for Harvest in DataGrip and use SQL to query live Harvest data.
-
Connect to Stack Exchange Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Stack Exchange data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous BigCommerce Replication to MySQL
Use CData Sync for automated, continuous, customizable BigCommerce replication to MySQL.
-
Getting Started with the CData ODBC Driver for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Twitter Ads.
-
Migrating data from MarkLogic to Databricks using CData SSIS Components.
Easily push MarkLogic data to Databricks using the CData SSIS Tasks for MarkLogic and Databricks.
-
Integrate Devin with Live Microsoft Entra ID 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 Microsoft Entra ID data.
-
Automated Continuous BigCommerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable BigCommerce replication to AlloyDB.
-
How to Visualize Salesforce Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Salesforce data in Python.
-
Prepare, Blend, and Analyze Cvent Data in Alteryx Designer (Connect AI)
Build workflows to access live Cvent data for self-service data analytics.
-
Build Apps with Live Elorus Data Using the Low-Code Development Platform of Mendix
Connect Elorus data with Mendix to build apps using the CData API Driver for JDBC.
-
Create Google Analytics-Connected Dashboards in Grafana
Connect to Google Analytics Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Analytics data.
-
Getting Started with the CData JDBC Driver for Deel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Deel.
-
Getting Started with the CData JDBC Driver for Pingdom
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pingdom.
-
Integrating Boomi Agentstudio with SuiteCRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SuiteCRM data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate with SAP Hybris C4C Data in JReport Designer
Create charts and reports based on SAP Hybris C4C data in JReport Designer.
-
Analyze Authorize.Net Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Authorize.Net data with the CData JDBC Driver for Authorize.Net.
-
Connect to Oracle Data in RazorSQL
Connect to Oracle from wizards and query Oracle data from the GUI in the RazorSQL database management tool.
-
Query Live CapsuleCRM 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 CapsuleCRM data through a conversational interface.
-
Automated Continuous CSV Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CSV replication to Google Cloud SQL.
-
Prepare, Blend, and Analyze Kintone Data in Alteryx Designer (ODBC)
Build workflows to access live Kintone data for self-service data analytics.
-
Excel Spreadsheet Automation on Sage 300 Data with the QUERY Formula
Pull data from Sage 300, automate spreadsheets, and more with the QUERY formula.
-
How to integrate Metabase with Gong Data
Use CData Connect AI to connect to live Gong data and create an interactive dashboard in Metabase from Gong data.
-
Integrate with MarkLogic Data in JReport Designer
Create charts and reports based on MarkLogic data in JReport Designer.
-
How to Connect to & Open Smartsheet Data in Microsoft Excel
This article uses the CData ODBC driver for Smartsheet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate with live Apollo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apollo data in Jitterbit.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange data for you.
-
Use CData Connect AI to Access Moosend Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Moosend data in the Power Pivot business intelligence tool.
-
How to Visualize Placid Data in Python with pandas
Use pandas and other modules to analyze and visualize live Placid data in Python.
-
Automated Continuous Bullhorn CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Oracle.
-
Integrate with Teradata Data in JReport Designer
Create charts and reports based on Teradata data in JReport Designer.
-
Getting Started with the CData ODBC Driver for Email
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Email.
-
Publish Discord-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Discord data.
-
Connect to Real-Time ShipStation Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ShipStation and Dataflow to import and use ShipStation data in Power Apps.
-
Automated Continuous Oracle Eloqua Reporting Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Apache Kafka.
-
Automated Continuous Amplitude Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amplitude replication to Google Cloud SQL.