CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from SQL Server to Outreach.io through SSIS
Easily push SQL Server data to Outreach.io using the CData SSIS Tasks for Outreach.io.
-
Use Dash to Build to Web Apps on Salesloft Data
Create Python applications that use pandas and Dash to build Salesloft-connected web apps.
-
DataBind Controls to BenchmarkEmail Data in C++Builder
DataBind to BenchmarkEmail data in C++Builder with standard components and controls.
-
Access Customer.io 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 Customer.io data.
-
Connect to ADP Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ADP data.
-
Integrate Paymo Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Paymo data and integrate live Paymo data into your Power Automate tasks.
-
Getting Started with the CData Tableau Connector for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Adobe Analytics.
-
DataBind ScrapingBee Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ScrapingBee data to a chart.
-
How to Connect to Live Anaplan 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 Anaplan data for you.
-
Build Dashboards with Jira Data in DBxtra
Create dynamic dashboards and perform analytics based on Jira data in DBxtra.
-
Access Live Twilio Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Twilio data from your Excel spreadsheets.
-
Natively Connect to Klaviyo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Klaviyo data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Excel Add-In for NetSuite
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for NetSuite.
-
Integrating LlamaIndex with Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sendwithus data in real time.
-
Write a Simple Go Application to work with Clio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Clio data.
-
Connect to HCL Domino Data from a Connection Pool in Jetty
The HCL Domino JDBC Driver supports connection pooling: This article shows how to connect faster to HCL Domino data from Web apps in Jetty.
-
How to Connect to & Open Clio Data in Microsoft Excel
This article uses the CData ODBC driver for Clio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Add Azure Data Lake Storage Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Data Lake Storage with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Adobe Target-Connected Nintex Workflows
Use CData Connect AI to connect to Adobe Target Data from Nintex Workflow Cloud and build custom workflows using live Adobe Target data.
-
How to Query Notion Data in MySQL Workbench
Execute MySQL queries against live Notion data from MySQL Workbench.
-
Validate Zuora Data with QuerySurge
Access and validate Zuora data in QuerySurge using the CData JDBC Driver.
-
Edit and Search External SAP Netweaver Gateway Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Netweaver Gateway data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Netweaver Gateway Data objects that you can access from apps and the dashboard.
-
Automated Continuous Oracle Eloqua Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to MySQL.
-
A PostgreSQL Interface for Zoho Projects Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Projects JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Dash to Build to Web Apps on Unbounce Data
Create Python applications that use pandas and Dash to build Unbounce-connected web apps.
-
Use the CData Software JDBC Driver for Zoho Books in MicroStrategy
Connect to Zoho Books data in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Books.
-
Use JayDeBeApi to access MongoDB Data in Python
Use standard Python scripting and the development environment of your choice to access live MongoDB data.
-
Natively Connect to Strava Data in PHP
The CData ODBC driver for Strava enables you to create PHP applications with connectivity to Strava data. Leverage the native support for ODBC in PHP.
-
Integrate with live Salesforce CRM Analytics Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce CRM Analytics data in Jitterbit.
-
Connect and Visualize Live XML Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live XML data into the Databricks platform and create visualization dashboards with real-time XML data.
-
Connect to Postmark Data in Aqua Data Studio
Access Postmark data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Feed Pipeline CRM Data into FineReport
How to set Pipeline CRM data as a JDBC data source in FineReport.
-
Connect Discourse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Discourse data using the CData Python MCP Server.
-
Use the CData ODBC Driver for Mailjet from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mailjet to connect to Mailjet data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mailjet data in Excel.
-
Query Live MailChimp Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live MailChimp data directly from the development environment.
-
Use the CData Software ODBC Driver for ServiceDesk Plus in SAS for Real-Time Reporting and Analytics
Connect to real-time ServiceDesk Plus data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ServiceDesk Plus.
-
Use JayDeBeApi to access Salesloft Data in Python
Use standard Python scripting and the development environment of your choice to access live Salesloft data.
-
Query eBay Analytics Data in DataGrip
Create a Data Source for eBay Analytics in DataGrip and use SQL to query live eBay Analytics data.
-
Analyze SAP Hybris C4C Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Hybris C4C data in Microsoft R Open.
-
How to Build an ETL App for Coda Data in Python with CData Connect AI
Extract and transform live Coda data in Python with petl and the CData Connect AI Python SDK.
-
Import and Visualize CloudConvert Data in Power View
Create data visualizations based on CloudConvert data in Excel.
-
Integrating ZohoPeople Data in Talend Cloud Data Management Platform
Connect ZohoPeople Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to work with Pipeline CRM Data in Apache Spark using SQL
Access and process Pipeline CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Google Cloud Storage Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Cloud Storage data in DBxtra.
-
Replicate Outreach.io Data to Multiple Databases
Replicate Outreach.io data to disparate databases with a point-and-click configuration.
-
How to connect to Kintone Data in DBVisualizer
Integrate Kintone data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Databricks Agent Bricks to Talk to Your SAP Netweaver Gateway Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Netweaver Gateway data for you.
-
Connect Zoho Books Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Books data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Mailjet Data in Jaspersoft Studio
Execute SQL to remote Mailjet data in Jaspersoft Studio.
-
Query Gmail Data in DataGrip
Create a Data Source for Gmail in DataGrip and use SQL to query live Gmail data.
-
Create Xero Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Xero from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize ElevenLabs Data in TIBCO Spotfire through ADO.NET
Integrate ElevenLabs data into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for QuickBooks Time in SAS for Real-Time Reporting and Analytics
Connect to real-time QuickBooks Time data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks Time.
-
DataBind Charts to AlloyDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to AlloyDB data 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.
-
Connect to Toggl Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Toggl data in Airbyte.
-
Getting Started with the CData JDBC Driver for JobNimbus
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for JobNimbus.
-
Create FHIR-Connected Applications in Appsmith
Connect to FHIR Data via CData Connect AI in Appsmith and create custom business applications with real-time access to FHIR data.
-
How to Build an ETL App for Dynamics NAV Data in Python with CData
Create ETL applications and real-time data pipelines for Dynamics NAV data in Python with petl.
-
How to import QuickBooks Online Data into Apache Solr
Use the CData Software JDBC Driver for QuickBooks Online in Data Import Handler and create an automated import of QuickBooks Online data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Tableau Connector for Keap
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Datasets from SAP Concur in Domo Workbench and Build Visualizations of SAP Concur Data in Domo
Use the CData Software ODBC Driver for SAP Concur to create datasets from SAP Concur data in Domo Workbench and then build visualizations in the Domo service.
-
Automate Adobe Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate Adobe Analytics data replication to Azure Synapse.
-
Automated Continuous Grafana Replication to Oracle
Use CData Sync for automated, continuous, customizable Grafana replication to Oracle.
-
Visualize Azure Synapse Data in TIBCO Spotfire through ADO.NET
Integrate Azure Synapse data into dashboards in TIBCO Spotfire.
-
Integrate with Live SparkPost Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SparkPost from the MuleSoft Anypoint Platform to integrate live SparkPost data into custom reports and dashboards.
-
Create SFTP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SFTP data access from reports, embedded analytics, and more.
-
Choosing the Best Method to Connect Cohere to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Cohere data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect DBeaver to TaxJar via a JDBC Driver
Manage TaxJar data with visual tools in DBeaver like the query browser.
-
Integrating Claude Code with Sage Cloud Accounting Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sage Cloud Accounting data within assisted coding and automated development workflows.
-
Write a Simple Go Application to work with Redis Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Redis data.
-
Automated Continuous Dotmailer Replication to Oracle
Use CData Sync for automated, continuous, customizable Dotmailer replication to Oracle.
-
Deploy the ADO.NET Provider for Basecamp on an SSRS Report Server
Connect to Basecamp 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 Pinecone Replication to Oracle
Use CData Sync for automated, continuous, customizable Pinecone replication to Oracle.
-
Connect to Datadog Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Datadog data.
-
Analyze Zuora Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zuora data and visualize live Zuora data in Infragistics Reveal.
-
Analyze Anaplan Data in Cognos Analytics
Use CData Connect AI to connect to Anaplan Data from Cognos Analytics and analyze live Anaplan data.
-
Connect to Calendly Data in Aqua Data Studio
Access Calendly data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Paddle from Asprova with CData Software ODBC Driver for Paddle
This article shows how to connect faster to Paddle data from Asprova.
-
Integrate OpenCode with Live Oracle Sales Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Oracle Sales data from within your AI coding agent.
-
Migrating data from Intercom to Databricks using CData SSIS Components.
Easily push Intercom data to Databricks using the CData SSIS Tasks for Intercom and Databricks.
-
Write a Simple Go Application to work with Jira Assets Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Jira Assets data.
-
Replicate Spotify Data from PowerShell
Write a quick PowerShell script to query Spotify data. Use connectivity to the live data to replicate Spotify data to SQL Server.
-
Build a Simple VCL Application for SAP Business Warehouse Data
How to build a simple VCL Application to view SAP Business Warehouse data in RAD Studio using the CData ODBC Driver for SAP Business Warehouse.
-
Analyze OpenWeatherMap Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze OpenWeatherMap data with the CData JDBC Driver for OpenWeatherMap.
-
How to use SQLAlchemy ORM to access Chargebee Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Chargebee data.
-
Publish Reports with Pipeline CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipeline CRM data.
-
Access Rebilly Data from MySQL in Amazon QuickSight
Connect to Rebilly and build visualizations of Rebilly data using a MySQL Connection in Amazon QuickSight.
-
Build Apps with Live HDFS data in Adalo using CData Connect AI
Use CData Connect AI to integrate live HDFS data into the Adalo platform and build custom mobile and web applications with real-time HDFS data.
-
How to Connect the Power BI Service to NetSuite: Complete Guide
Connect to the CData Software Power BI Connector for NetSuite from PowerBI.com to provide real-time NetSuite data across the organization.
-
Working with Demio Data in LINQPad
Execute LINQ queries to Demio data in LINQPad.
-
Integrate Google's Antigravity Agent with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sybase IQ data using the Model Context Protocol.
-
Use the CData Software ODBC Driver for Wave Financial in MicroStrategy Web
Connect to Wave Financial data in MicroStrategy Web using the CData Software ODBC Driver for Wave Financial.
-
Access Live YouTube Analytics Data in TIBCO Data Virtualization
Use the YouTube Analytics Tibco DV Adapter to create a YouTube Analytics data data source in TIBCO Data Virtualization Studio and gain access to live YouTube Analytics data from your TDV Server.
-
Use Grok to Talk to Your SAP Business Warehouse 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 SAP Business Warehouse data for you.
-
Integrating Cursor with Cvent 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.
-
Use Azure AI Foundry to Talk to Your Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Salesloft data for you.
-
Analyze SAP Business One Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Business One data with the CData JDBC Driver for SAP Business One.
-
How to Access Contentful Data Using Entity Framework
This article shows how to access Contentful data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software ODBC Driver for Asana in MicroStrategy Desktop
Connect to Asana data in MicroStrategy Desktop using the CData Software ODBC Driver for Asana.
-
Provide OData Services of Lakebase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Lakebase data by developing a WCF Service Application.