CData Software - Knowledge Base
Recent Articles
-
Integrate ConvertAPI with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ConvertAPI with External Services.
-
Extend Google Sheets with Certinia Data
Make calls to Certinia from Google Apps Script via the API Server.
-
How to import SFTP Data into Apache Solr
Use the CData Software JDBC Driver for SFTP in Data Import Handler and create an automated import of SFTP to Apache Solr Enterprise Search platform.
-
Stream ServiceNow Data into Apache Kafka Topics
Access and stream ServiceNow in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query, Visualize, and Share live PayPal Data in Redash
Use CData Connect AI to connect to live PayPal in Redash for querying, visualizing, and sharing.
-
Integrating Codex CLI with ZendeskSell 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.
-
Analyze MongoDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MongoDB with the CData JDBC Driver for MongoDB.
-
Integrating Antigravity CLI with ScrapingBee via CData CLI
Connect ScrapingBee to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to update Marketo from Excel
This article explains how to transfer data from Excel to Marketo using the Excel Add-In for Marketo.
-
Replicate MailChimp Data to Multiple Databases
Replicate MailChimp to disparate databases with a point-and-click configuration.
-
Automated Continuous Amazon DynamoDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Amazon S3.
-
Create Azure Data Lake Storage-Connected Applications in Appsmith
Connect to Azure Data Lake Storage Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Data Lake Storage.
-
Integrating Dataiku with GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live GraphQL.
-
Visualize Bullhorn CRM Data in TIBCO Spotfire through OData
Integrate Bullhorn CRM into dashboards in TIBCO Spotfire.
-
Provide OData Services of Cloudant Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for IBM Cloudant by developing a WCF Service Application.
-
Work with Live Sage Cloud Accounting Data in Power Query
Use CData Connect AI to connect to Sage Business Cloud Accounting and work with live Sage Business Cloud Accounting in Microsoft Power Query.
-
Connect to Real-Time Pipeliner CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Pipeliner CRM in Power Apps.
-
Automated Continuous LinkedIn Ads Replication to Vertica
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Vertica.
-
Integrate Theia IDE with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create Bannerbear Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Bannerbear data access from reports, embedded analytics, and more.
-
Access Live SAP SuccessFactors LMS Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP SuccessFactors LMS from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Gumloop with Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce & Force.com within automated workflows.
-
Automated Continuous Aha! Replication to SQLite
Use CData Sync for automated, continuous, customizable Aha! replication to SQLite.
-
Use the CData Software JDBC Driver for Slack in MicroStrategy
Connect to Slack in MicroStrategy Developer using the CData Software JDBC Driver for Slack.
-
Connecting Moonlit Workflow with Sage Cloud Accounting Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Sage Business Cloud Accounting in real time.
-
Connect to MessageBird Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MessageBird and the SQL Gateway to access MessageBird from Google Apps Script.
-
Import Real-Time Microsoft Entra ID Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Entra ID in ColdFusion.
-
Back Up Freshteam 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 Freshteam data.
-
Connect Sage Intacct Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sage Intacct using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Aweber Data from a Connection Pool in JBoss
Integrate Aweber into Java servlets: Use the Management Console in JBoss to install the Aweber JDBC Driver.
-
Build an OLAP Cube in SSAS from Klipfolio Data
Establish a connection to Klipfolio data from SQL Server Analysis Services, and use the Klipfolio Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build a Simple VCL Application for ZeroBounce Data
How to build a simple VCL Application to view ZeroBounce in RAD Studio using the CData ODBC Driver for ZeroBounce.
-
Use the CData Software ODBC Driver for Google Search in MicroStrategy Desktop
Connect to Google Search in MicroStrategy Desktop using the CData Software ODBC Driver for Google Search.
-
Connect to Shippo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Shippo using standard SQL.
-
Access Oracle Financials Cloud Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle Financials Cloud from your Oracle system.
-
Automated Continuous Adobe Target Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Adobe Target replication to OneLake in Microsoft Fabric.
-
Build SAP Ariba Source-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP Ariba Source Data from Zoho Analytics and import live SAP Ariba Source.
-
Visualize Google Spanner Data in Sisense
Create an ElastiCube in Sisense app with access to Google Spanner.
-
How to Connect to Live MailChimp Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live MailChimp without replication.
-
Deploy the ADO.NET Provider for OneNote on an SSRS Report Server
Connect to Microsoft OneNote 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.
-
Connecting Pipedream with SendGrid 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 SendGrid data in real time.
-
Use Grok to Talk to Your SAS xpt 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 SAS XPORT for you.
-
Connect to Sugar CRM Data in Aqua Data Studio
Access Sugar CRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Mode Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mode. Leverage the pyodbc module for ODBC in Python.
-
Connect Google Translate to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Translate using the CData Python MCP Server.
-
Integrate Live Unbounce Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Unbounce to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use Claude to Talk to Your Sales Data
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your finance & accounting data for you
-
Excel Spreadsheet Automation on CSV Data with the QUERY Formula
Pull data from CSV, automate spreadsheets, and more with the QUERY formula.
-
Build MVC Applications with Connectivity to Zoho Projects Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Projects from an ASP.NET MVC application.
-
Build Semantic Layer Views for Greenplum Data in APOS Live Data Gateway
Use the CData Connector for Greenplum in APOS Live Data Gateway to build Semantic Layer Views for Pivotal GreenPlum.
-
Connect to Discord Data in RapidMiner
Integrate Discord with standard components and data source configuration wizards in RapidMiner Studio.
-
Write a Simple Go Application to work with OpenWeatherMap Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to OpenWeatherMap.
-
A PostgreSQL Interface for Active Directory Data using the CData ODBC Driver
Use the SQL Gateway and Active Directory ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Kiro CLI with ConstantContact 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.
-
Migrating data from Deel to Databricks using CData SSIS Components.
Easily push Deel to Databricks using the CData SSIS Tasks for Deel and Databricks.
-
Build AI/ML Models with Live SQL Analysis Services Data using Dataiku
Connect SQL Analysis Services Data with Dataiku using the CData JDBC Driver for SQL Analysis Services.
-
DataBind Charts to Highrise Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Highrise CRM 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.
-
Getting Started with the CData ADO.NET Provider for ADP
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for ADP.
-
Integrate Oracle Sales Data in the Pentaho Report Designer
Publish reports based on Oracle Sales in the Pentaho BI tool.
-
Access Klipfolio Data from MySQL in PHP
Connect to Klipfolio through the standard MySQL libraries in PHP.
-
How to integrate Exact Online with Apache Airflow
Access and process Exact Online in Apache Airflow using the CData JDBC Driver.
-
Visualize Adobe Experience Manager Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Experience Manager.
-
Query Google Forms Data as a MySQL Database in Node.js
Execute MySQL queries against Google Forms from Node.js.
-
Automated SAP HANA Data Replication to Teradata
Use CData Sync to Customize and automate SAP HANA replication to Teradata.
-
Connect to JotForm Data in DBArtisan
Use wizards in DBArtisan to configure JotForm as a data source.
-
Integrate CouchDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CouchDB with External Services.
-
Bind Live SAP Fieldglass Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Fieldglass data
-
Build MVC Applications with Connectivity to SendGrid Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SendGrid from an ASP.NET MVC application.
-
How to publish and share CouchDB Data dashboards with Tableau Server
The CData ODBC driver for CouchDB enables you integrate Apache CouchDB into Tableau dashboards.
-
Consume Oracle Service Cloud OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Service Cloud feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Odoo Replication to Databricks
Use CData Sync for automated, continuous, customizable Odoo replication to Databricks.
-
Build Semantic Layer Views for Raisers Edge NXT Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Raisers Edge NXT.
-
Import Real-Time Perigon Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Perigon in ColdFusion.
-
Natively Connect to Oracle Sales Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle Sales. Leverage the native support for ODBC in PHP.
-
Connect to and Query Pushbullet Data in QlikView over ODBC
Create data visualizations with Pushbullet in QlikView.
-
Access Sage 300 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sage 300 from HeidiSQL.
-
Create Reports with Redis Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redis.
-
Getting Started with the CData JDBC Driver for Todoist
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Todoist.
-
Build Automated Zoom-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoom and build automated workflows in Zapier.
-
Build Dashboards with SAP Ariba Procurement Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Ariba Procurement in DBxtra.
-
Create Dashboards and Visualize Live Salesforce Data in Geckoboard
Use CData Connect AI to connect to live Salesforce & Force.com and create dashboards for real-time monitoring and visualization in Geckoboard.
-
DataBind Google Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Ads with the DevExpress Windows Forms and Web controls to provide Google Ads to a chart.
-
How to Build an ETL App for Figshare Data in Python with CData
Create ETL applications and real-time data pipelines for Figshare in Python with petl.
-
Build Dashboards with Contentful Data in Dundas BI
Create dynamic dashboards and perform analytics based on Contentful in Dundas BI.
-
Connect to Nuclia Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Nuclia.
-
Integrate Live Microsoft Exchange Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Exchange and integrate live Microsoft Exchange into apps built in Microsoft Power Apps.
-
Import Real-Time SendGrid Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SendGrid in ColdFusion.
-
Integrating Codex CLI with SparkPost 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.
-
Bridge Salesforce CRM Analytics Connectivity with Apache NiFi
Access and process Salesforce CRM Analytics in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Grafana in MicroStrategy Web
Connect to Grafana in MicroStrategy Web using the CData Software JDBC Driver for Grafana.
-
Operational Reporting on Avaza Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Avaza.
-
Connect Odoo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Odoo ERP using the CData Python MCP Server.
-
Connect to LaunchDarkly Data in CloverDX (formerly CloverETL)
Transfer LaunchDarkly using the visual workflow in the CloverDX data integration tool.
-
How to Seamlessly Import Gmail Data into IBM SPSS Modeler
Integrate Gmail data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Access Live Google Translate Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Translate enables you to integrate Google Translate into workflows built using Microsoft Power Automate Desktop.
-
Analyze SAP SuccessFactors LMS Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP SuccessFactors LMS in Microsoft R Open.
-
Operational Reporting on Rebilly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Rebilly.
-
Replicate Multiple Salesloft Accounts
Replicate multiple Salesloft accounts to one or many databases.
-
Connect Outlook to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Outlook with IBM WebSphere for seamless data integration and connectivity.
-
Access Hive Data from MySQL in PHP
Connect to Hive through the standard MySQL libraries in PHP.