CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Acumatica Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Acumatica replication to PostgreSQL.
-
Getting Started with the CData Excel Add-In for Zoom
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoom.
-
Automated Continuous Reckon Accounts Hosted Replication to MongoDB
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to MongoDB.
-
Using the CData Software ODBC Driver for FreeAgent in PyCharm
Connect to FreeAgent as an ODBC data source in PyCharm using the CData Software ODBC Driver for FreeAgent.
-
Connect to Live Square Data in MicroStrategy through CData Connect AI
Create a live connection to Square Data in CData Connect AI and connect to your Square from MicroStrategy.
-
Integrate with live Bullhorn CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Bullhorn CRM in Jitterbit.
-
Query ClickUp Data as a MySQL Database in Node.js
Execute MySQL queries against ClickUp from Node.js.
-
Migrating data from Grafana to Google BigQuery using CData SSIS Components.
Easily push Grafana to Google BigQuery using the CData SSIS Tasks for Grafana and Google BigQuery.
-
Migrating data from Perigon to Google BigQuery using CData SSIS Components.
Easily push Perigon to Google BigQuery using the CData SSIS Tasks for Perigon and Google BigQuery.
-
Visualize Elasticsearch 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 Elasticsearch into TIBCO Spotfire.
-
Build Google Contacts-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Contacts to explore live Google Contacts Data in Gemini Code Assist to assist with building Google Contacts-powered applications.
-
How to Connect to Live Stripe Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Stripe securely in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for Scrapfly
Create Scrapfly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous SAP BusinessObjects BI Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to SQLite.
-
Create Printify Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Printify data access from reports, embedded analytics, and more.
-
DataBind Charts to CouchDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache CouchDB 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.
-
Analyze SAP Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP ERP/NetWeaver and visualize live SAP ERP/NetWeaver in Infragistics Reveal.
-
Visualize Oracle Financials Cloud Data in TIBCO Spotfire through ADO.NET
Integrate Oracle Financials Cloud into dashboards in TIBCO Spotfire.
-
Query Wistia Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Wistia from Node.js.
-
Replicate CampaignMonitor Data to Multiple Databases
Replicate CampaignMonitor to disparate databases with a point-and-click configuration.
-
Connect to Google Ads Data in RazorSQL
Connect to Google Ads from wizards and query Google Ads from the GUI in the RazorSQL database management tool.
-
Wave Financial Reporting in OBIEE with the Wave Financial JDBC Driver
Deploy the Wave Financial JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build MVC Applications with Connectivity to Microsoft Teams Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Teams from an ASP.NET MVC application.
-
How to connect to Supabase Data from IntelliJ
Integrate connectivity to Supabase with wizards in IntelliJ.
-
Create Google Campaign Manager 360 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Campaign Manager 360 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Authorize.Net Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Authorize.Net from Node.js.
-
Build SAP ByDesign-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP ByDesign to explore live SAP ByDesign Data in Claude Code to assist with building SAP ByDesign-powered applications.
-
Visualize Oracle Data in TIBCO Spotfire through ADO.NET
Integrate Oracle Database into dashboards in TIBCO Spotfire.
-
Automated Continuous MailChimp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MailChimp replication to IBM DB2.
-
Build Data Flows from SQL Server to Act CRM through SSIS
Easily push SQL Server data to Act CRM using the CData SSIS Tasks for Act CRM.
-
Access Live Oracle Eloqua Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Eloqua data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use Biml to Build SSIS Tasks to Replicate Humanity Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Humanity to SQL Server.
-
How to integrate Metabase with Oracle Eloqua Data
Use CData Connect AI to connect to live Oracle Eloqua and create an interactive dashboard in Metabase from Oracle Eloqua.
-
Natively Connect to Asana Data in PHP
The CData ODBC driver for Asana enables you to create PHP applications with connectivity to Asana. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for HelloSign in MicroStrategy
Connect to HelloSign in MicroStrategy Developer using the CData Software JDBC Driver for HelloSign.
-
DataBind Wave Financial Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Wave Financial with the DevExpress Windows Forms and Web controls to provide Wave Financial to a chart.
-
Replicate SharePoint Data from PowerShell
Write a quick PowerShell script to query Microsoft SharePoint. Use connectivity to the live data to replicate Microsoft SharePoint to SQL Server.
-
How to Connect to Live YouTube Analytics Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your YouTube Analytics for you.
-
Publish Reports with Act-On Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act-On.
-
Use the CData ODBC Driver for JSON from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for JSON to connect to JSON from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring JSON in Excel.
-
Trigger Sage Intacct IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Sage Intacct with standard wizards in Logic Apps.
-
Query Oracle Service Cloud Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Service Cloud entities in PHP by modeling them as objects.
-
Create Reports with QuickBooks Time Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Time.
-
Analyze Discourse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Discourse from Power Pivot. You will use the Table Import Wizard to load Discourse. You can visually build the import query or use any SQL supported by the driver.
-
View Reports on Real-Time AdRoll Data in Power BI Report Server
Use the CData ODBC Driver for AdRoll to visualize AdRoll in Power BI Desktop and then publish them to Power BI Report Server.
-
Import and Visualize Postmark Data in Power View
Create data visualizations based on Postmark in Excel.
-
Publish Reports with Keap Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Keap.
-
Getting Started with the CData Excel Add-In for Sendwithus
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sendwithus.
-
Visualize Live GitHub Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live GitHub.
-
Automate Salesforce Data Replication to Couchbase
Use CData Sync to Customize and automate Salesforce & Force.com replication to Couchbase.
-
Choosing the Best Method to Connect Simplesat to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Simplesat from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create DocuSign Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time DocuSign data access from reports, embedded analytics, and more.
-
Work with Live HBase Data in Power Query
Use CData Connect AI to connect to Apache HBase and work with live Apache HBase in Microsoft Power Query.
-
DataBind Controls to Foursquare Data in C++Builder
DataBind to Foursquare in C++Builder with standard components and controls.
-
How to Access ZeroBounce Data Using Entity Framework
This article shows how to access ZeroBounce using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Datadog Replication to SQL Server
Use CData Sync for automated, continuous, customizable Datadog replication to SQL Server.
-
Process & Analyze Azure Analysis Services Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Analysis Services Data.
-
Integrate Open WebUI with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Gong from within the chat interface.
-
How to Access Live LDAP Objects in Visual Studio Code via Cline
Run CData MCP Server for LDAP on Windows Subsytem for Linux (WSL) and connect to live LDAP from the Cline extension in Visual Studio Code.
-
Integrating LangChain with SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Hybris C4C within automated workflows.
-
How to load GraphQL data into Elasticsearch via Logstash
Introducing a simple method to load GraphQL data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Trello Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Trello data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Import Real-Time HelloSign Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HelloSign in ColdFusion.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Presto using the Model Context Protocol.
-
Connecting Agentforce with AlloyDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google AlloyDB for you.
-
DataBind Charts to Attio Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Attio 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.
-
Creating NetSuite SuiteAnalytics-Connected Applications in Unqork
You can use CData Connect AI to feed NetSuite SuiteAnalytics to Unqork and build custom business apps.
-
Integrating OpenCode Terminal with JDBC-ODBC Bridge 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.
-
Build Act CRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Act CRM Data from Zoho Analytics and import live Act CRM.
-
How to connect to Quaderno Data from IntelliJ
Integrate connectivity to Quaderno with wizards in IntelliJ.
-
How to integrate DocuSign with Apache Airflow
Access and process DocuSign in Apache Airflow using the CData JDBC Driver.
-
How to Build an ETL App for Procore Data in Python with CData Connect AI
Build ETL pipelines that read and write live Procore in Python with petl and the CData Connect AI Python SDK.
-
Integrating Codex CLI with Zoho CRM 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.
-
Design BIRT Reports on Dynamics 365 Business Central Data
Provide current Dynamics 365 Business Central to your embedded analytics.
-
Query Paylocity Data in DataGrip
Create a Data Source for Paylocity in DataGrip and use SQL to query live Paylocity.
-
Integrate Cursor with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Drive from within the editor.
-
Integrate QuickBooks Online Data into Power Automate Desktop using CData Connect
CData Connect for QuickBooks Online Data enables you to integrate QuickBooks Online into workflows built using Microsoft Power Automate Desktop.
-
Stream Salesforce Marketing Data into Apache Kafka Topics
Access and stream Salesforce Marketing Cloud in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
SAP Business One Reporting in OBIEE with the SAP Business One JDBC Driver
Deploy the SAP Business One JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build an OLAP Cube in SSAS from Close Data
Establish a connection to Close data from SQL Server Analysis Services, and use the Close Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live QuickBooks Online 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 QuickBooks Online for you.
-
Connect to Quickbase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Quickbase as an External Source in Dremio.
-
Connect to SAP Business Warehouse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Business Warehouse and the SQL Gateway to access SAP Business Warehouse from Google Apps Script.
-
Bridge Nethunt Connectivity with Apache NiFi
Access and process Nethunt in Apache NiFi using the CData JDBC Driver.
-
DataBind Charts to Elorus Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Elorus 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.
-
Automated Continuous LaunchDarkly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to PostgreSQL.
-
Explore Geographical Relationships in Planio Data with Power Map
Create data visualizations with Planio in Power Map.
-
Integrate Azure DevOps Data into Power Automate Desktop using CData Connect
CData Connect for Azure DevOps Data enables you to integrate Azure DevOps into workflows built using Microsoft Power Automate Desktop.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cvent
Provide connectivity to Cvent through an SAP BusinessObjects universe.
-
Build Data Flows from Odoo to SQL Server using SSIS
Easily back up Odoo ERP to SQL Server using the SSIS components for Odoo.
-
Automated Continuous Smartsheet Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Smartsheet replication to AlloyDB.
-
DataBind Controls to ZohoInvoice Data in C++Builder
DataBind to ZohoInvoice in C++Builder with standard components and controls.
-
Integrating Kiro CLI with Oracle Sales 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 Pinterest to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pinterest using the CData Python MCP Server.
-
Add ChartMogul Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ChartMogul with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with Splunk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Splunk to a JSON file on disk.
-
Connect to Zoho Recruit Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho Recruit to connect to Zoho Recruit and execute queries in PowerBuilder.
-
Analyze Zuora Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zuora and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Perform Batch Operations with Outreach.io Data in Apache NiFi
Connect to Outreach.io and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Goose with Live WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live WooCommerce from within the local AI agent.